From 74c2604dc80616292c8cb06ed88c2c694d843fdb Mon Sep 17 00:00:00 2001 From: AsamK Date: Tue, 14 Jan 2025 22:31:36 +0100 Subject: [PATCH] Set sqlite PRAGMA via Url --- .../main/java/org/asamk/signal/manager/storage/Database.java | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/lib/src/main/java/org/asamk/signal/manager/storage/Database.java b/lib/src/main/java/org/asamk/signal/manager/storage/Database.java index 2fb09a4f..938bb010 100644 --- a/lib/src/main/java/org/asamk/signal/manager/storage/Database.java +++ b/lib/src/main/java/org/asamk/signal/manager/storage/Database.java @@ -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); } } -- 2.50.1