Is it possible to use this to with c3p0 DataSource?

[Stephenttt]

Hi, i try to open my encrypted sqlite database as an C3P0 DataSource, but dont know to to set the getConnection properties.

Here is my original code to open sqlite as dataSource:

I look into the SQLiteMCChacha20Config.getDefault().withKey().build().toProperty(), and try this

I wonder how i can using SQLiteConfig to setup SQLiteDataSource as an C3P0.DataSource.

Thank you.

[Stephenttt]

I can get SQLiteDataSource working, but c3p0 seem like does not support encrypted sqlite db file.

[Chris-SP365]

Did you try using the encryption supported config classes? Like SQLiteMCConfig?
It seems you're using the base version without encryption support.

Also please make sure that no base SQLite is in your project, just our SQLite.

[Stephenttt]

I did and SQLiteDataSource work fine,

But when i put the SQLiteDataSource into c3p0 DataSource, it just keep giving me error about it is not a database file. I think c3p0 doesn't support encrypted sqlite database.
Thank you for your reply.

[Chris-SP365]

Ok it seems you now are using the SQLiteMCChacha20Config which supports encryption. But afterwards, you export the settings to properties and build a new config without encryption.

Just use build() on the SQLiteMCChacha20Config WITHOUT toProperties() and use the resulting config class directly.