comparison src/fschmidt/db/postgres/PostgresExceptionHandler.java @ 68:00520880ad02

add fschmidt source
author Franklin Schmidt <fschmidt@gmail.com>
date Sun, 05 Oct 2025 17:24:15 -0600
parents
children
comparison
equal deleted inserted replaced
67:9d0fefce6985 68:00520880ad02
1 package fschmidt.db.postgres;
2
3 import java.sql.Connection;
4 import java.sql.Savepoint;
5 import java.sql.Statement;
6 import java.sql.SQLException;
7
8
9 public final class PostgresExceptionHandler {
10 private boolean inTrans;
11 private Connection pgCon;
12 private Savepoint sp;
13
14 public PostgresExceptionHandler(Statement stmt) throws SQLException {
15 pgCon = stmt.getConnection();
16 inTrans = !pgCon.getAutoCommit();
17 if( inTrans )
18 sp = pgCon.setSavepoint();
19 }
20
21 public void handleException() throws SQLException {
22 if( inTrans )
23 pgCon.rollback(sp);
24 }
25
26 public void close() throws SQLException {
27 if( inTrans )
28 pgCon.releaseSavepoint(sp);
29 }
30
31 }