changeset 1428:d21a7cf8fa9e

fix postgres check
author Franklin Schmidt <fschmidt@gmail.com>
date Sun, 24 Nov 2019 21:02:38 -0700
parents a076e89a2879
children 82415c9c0015
files src/luan/modules/lucene/PostgresBackup.java
diffstat 1 files changed, 9 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
diff -r a076e89a2879 -r d21a7cf8fa9e src/luan/modules/lucene/PostgresBackup.java
--- a/src/luan/modules/lucene/PostgresBackup.java	Sun Nov 24 18:23:57 2019 -0700
+++ b/src/luan/modules/lucene/PostgresBackup.java	Sun Nov 24 21:02:38 2019 -0700
@@ -200,6 +200,15 @@
 		Checker() throws SQLException {
 			con = newConnection();
 			con.setAutoCommit(false);
+			con.setReadOnly(true);
+			con.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
+
+			// hack to capture data in transaction
+			Statement stmt = con.createStatement();
+			ResultSet rs = stmt.executeQuery("select 'x' from lucene");
+			while(rs.next());
+			stmt.close();
+
 			pstmt = con.prepareStatement(
 				"select data from lucene where id=?"
 			);