From 6c34a55f0d204946b4c800dee3a1f3a6270e3845 Mon Sep 17 00:00:00 2001 From: adam Date: Sun, 22 Jul 2007 02:28:18 +0000 Subject: [PATCH] SqliteDB: bug fixes darcs-hash:20070722022818-5007d-01fe60c63da8cbf769e5568db31e43a3fa3619de.gz --- src/org/ibex/mail/SqliteDB.java | 11 +++++------ 1 file changed, 5 insertions(+), 6 deletions(-) diff --git a/src/org/ibex/mail/SqliteDB.java b/src/org/ibex/mail/SqliteDB.java index 900e07c..42a1755 100644 --- a/src/org/ibex/mail/SqliteDB.java +++ b/src/org/ibex/mail/SqliteDB.java @@ -43,8 +43,10 @@ public class SqliteDB { conn = DriverManager.getConnection("jdbc:sqlite:"+filename); conn.prepareStatement("PRAGMA auto_vacuum = 1").executeUpdate(); conn.prepareStatement("VACUUM").executeUpdate(); + // until we have better assurances about locking on network filesystems... - conn.prepareStatement("PRAGMA locking_mode = EXCLUSIVE").executeUpdate(); + conn.prepareStatement("PRAGMA locking_mode = EXCLUSIVE").executeQuery(); + conn.prepareStatement("PRAGMA temp_store = MEMORY").executeUpdate(); conn.prepareStatement("PRAGMA page_size=4096").executeUpdate(); conn.prepareStatement("PRAGMA cache_size=2000").executeUpdate(); @@ -72,15 +74,12 @@ public class SqliteDB { private String reapColumn = null; private SqliteTable(String name, String schema) throws SQLException { this.name = name; - PreparedStatement ps = conn.prepareStatement("create table if not exists ?"); - ps.setString(1, name+" "+schema); + PreparedStatement ps = conn.prepareStatement("create table if not exists " + name + " " + schema); ps.executeUpdate(); tables.put(name, this); } public void createIndex(String name, String column) throws SQLException { - PreparedStatement ps = conn.prepareStatement("create index if not exists ? on ?"); - ps.setString(1, name); - ps.setString(2, column); + PreparedStatement ps = conn.prepareStatement("create index if not exists "+name+" on "+column); ps.executeUpdate(); } protected void reap(String reapColumn) { -- 1.7.10.4