cant specify connection property in URL when using ducklake direct attach

[gahtan-syarif]

I'm trying to specify connection properties while using ducklake direct attach through dbeaver using this jdbc url format:

jdbc:duckdb:ducklake:postgres:postgresql://user:pwd@127.0.0.1:5432/dbname;s3_endpoint=localhost:9000;;s3_access_key_id=minioadmin;;s3_secret_access_key=minioadmin;;s3_url_style=path;;s3_use_ssl=false;

This causes the error:

Connection Error: Can't open a connection to same database file with a different configuration than existing connections

this problem doesnt occur when i don't specify the s3 connection properties.

[staticlibs]

@gahtan-syarif

Thanks for the report! This is a bug, specific to jdbc:duckdb:ducklake URLs, I am going to do a 1.3.1.1 update soon to include the fix.

What is happening here, is that DB pinning (#238) is enabled automatically for jdbc:duckdb:ducklake URLs. So the initial connection remains open in DBeaver. It was supposed to be possible to override it with jdbc_pin_db=false in URL, but this part is broken and needs to be fixed now.

Current workaround is to restart DBeaver after the DuckLake connection options change.

[gahtan-syarif]

i see, restarting dbeaver indeed made it work thanks!

[staticlibs]

I am going to do a 1.3.1.1 update soon

1.3.2 was scheduled, the fix is going to be included there.