the iceberg catalog will be lose when use spring boot jdbc after run about an hour

[zhangjun0x01]

use spring boot jdbc to query duckdb,
add the following code to create a iceberg catalog in the spring init method ,
after run about an hour, the iceberg catalog will be lose ,when use java jdbc, it wll be fine.

CREATE OR REPLACE SECRET (
     TYPE ICEBERG,
     ENDPOINT 'http://xxxx:xxxx',
     TOKEN 'admin'
);

CREATE SECRET s3_secret (
      TYPE S3,
      KEY_ID 'xxxx',
      SECRET 'xxxxx',
      REGION 'xxx',
      ENDPOINT 'xxxxx'
);

ATTACH '' AS iceberg (TYPE ICEBERG);

[staticlibs]

@zhangjun0x01

Thanks for the report! I guess this may be related either to httpfs secrets handling or (more likely) to JDBC connections closure/reopening. ATTACH is transient, so the catalog is detached when the last connection to the DB instance is closed.

Can you try to use jdbc_pin_db option (ref) in that env, can be passed like this:

    Properties config = new Properties();
    config.put(DuckDBDriver.JDBC_PIN_DB, true);
    Connection conn = DriverManager.getConnection(url, config);

[zhangjun0x01]

@zhangjun0x01

Thanks for the report! I guess this may be related either to httpfs secrets handling or (more likely) to JDBC connections closure/reopening. ATTACH is transient, so the catalog is detached when the last connection to the DB instance is closed.

Can you try to use jdbc_pin_db option (ref) in that env, can be passed like this:

Properties config = new Properties();
config.put(DuckDBDriver.JDBC_PIN_DB, true);
Connection conn = DriverManager.getConnection(url, config);

thanks ，I'll give it a try

[zhangjun0x01]

@zhangjun0x01

Thanks for the report! I guess this may be related either to httpfs secrets handling or (more likely) to JDBC connections closure/reopening. ATTACH is transient, so the catalog is detached when the last connection to the DB instance is closed.

Can you try to use jdbc_pin_db option (ref) in that env, can be passed like this:

Properties config = new Properties();
config.put(DuckDBDriver.JDBC_PIN_DB, true);
Connection conn = DriverManager.getConnection(url, config);

I try it,it fine.thanks @staticlibs