starlake-ai / starlake

Declarative text based tool for data analysts and engineers to extract, load, transform and orchestrate their data pipelines.
http://starlake.ai/
Apache License 2.0
57 stars 22 forks source link

[BUG] - extract from duckdb (tutorial) not working with error java.sql.SQLException: Connection Error: Can't open a connection to same database #1087 #1088

Closed zedach closed 1 month ago

zedach commented 1 month ago

Summary

extract from duckdb (tutorial) not working with error Exception in thread "main" java.sql.SQLException: Connection Error: Can't open a connection to same database file with a different configuration than existing connections. connections are not closing correctly.

Related Issue: #IssueId

PR Type: Bug Fix |

Status: WIP/Ready to review

Breaking change? Yes/No

Description

Solution

we can enforce readonly and permit RW connection only on audit insertions with proper close connection.