Failure to auto load httpfs extension after upgrading to 1.5.*

[filipe-amberflo-io]

After updating to 1.5.0.0 (and newer) versions, I'm seeing the following error:

org.jooq.exception.DataAccessException: SQL [CREATE SECRET s3_credentials (
    TYPE S3,
    PROVIDER config,
    KEY_ID '....',
    SECRET '....',
    REGION 'us-west-2'
);
]; Extension Autoloading Error: An error occurred while trying to automatically install the required extension 'httpfs':
Can't find the home directory at ''
Specify a home directory using the SET home_directory='/path/to/dir' option.

This happens when I run my code in AWS Lambda ARM64, but not when running on my machine.

Version 1.4.4.0 and earlier work fine.

Snippet that triggers the issue (when running on AWS Lambda).

final var conn = (DuckDBConnection) DriverManager.getConnection("jdbc:duckdb:");

final var config = new DefaultConfiguration().set(conn).set(SQLDialect.DUCKDB);
final var context = DSL.using(config);

context.execute("""
        SET home_directory='/tmp/.duckdb';
        SET secret_directory='/tmp/.duckdb/sec';
        SET extension_directory='/tmp/.duckdb/ext';
        SET temp_directory='/tmp';
        SET TimeZone='UTC';
        """);

context.execute("""
        CREATE SECRET s3_credentials (
            TYPE S3,
            PROVIDER config,
            KEY_ID ?,
            SECRET ?,
            REGION ?
        );
        """, DSL.inline(accessKey), DSL.inline(secretKey), DSL.inline(region));

[staticlibs]

Hi, thanks for the report! I believe this was fixed in duckdb/duckdb#22341. Unfortunately it is not yet added to the duckdb-java repo (1.5 branch is not yet updated), going to be included with 1.5.3 update.

Adding explicit install and load should help as a workaround with the current version:

INSTALL httpfs;
LOAD httpfs;

[filipe-amberflo-io]

Alright, thank you!