From: AsamK <asamk@gmx.de>
Date: Tue, 14 Jan 2025 21:31:36 +0000 (+0100)
Subject: Set sqlite PRAGMA via Url
X-Git-Tag: v0.13.12~13
X-Git-Url: https://git.nmode.ca/signal-cli/commitdiff_plain/74c2604dc80616292c8cb06ed88c2c694d843fdb

Set sqlite PRAGMA via Url
---

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);
     }
 }