]> nmode's Git Repositories - signal-cli/commitdiff
Set sqlite PRAGMA via Url
authorAsamK <asamk@gmx.de>
Tue, 14 Jan 2025 21:31:36 +0000 (22:31 +0100)
committerAsamK <asamk@gmx.de>
Tue, 14 Jan 2025 21:31:36 +0000 (22:31 +0100)
lib/src/main/java/org/asamk/signal/manager/storage/Database.java

index 2fb09a4fc72d1e63b03ba05592d3b677128fca4b..938bb010e73e7492bc22b431b41570ee11bd1de4 100644 (file)
@@ -95,10 +95,9 @@ public abstract class Database implements AutoCloseable {
         sqliteConfig.setTransactionMode(SQLiteConfig.TransactionMode.IMMEDIATE);
 
         HikariConfig config = new HikariConfig();
-        config.setJdbcUrl("jdbc:sqlite:" + databaseFile);
+        config.setJdbcUrl("jdbc:sqlite:" + databaseFile + "?foreign_keys=ON");
         config.setDataSourceProperties(sqliteConfig.toProperties());
         config.setMinimumIdle(1);
-        config.setConnectionInitSql("PRAGMA foreign_keys=ON");
         return new HikariDataSource(config);
     }
 }