fix PG的重复设置事务等级的bug

tianzhenyu · tianzhenyu · commit d6cb2e14fb87 · 2021-09-28T16:30:39.000+08:00
diff --git a/APIJSONORM/src/main/java/apijson/orm/AbstractSQLExecutor.java b/APIJSONORM/src/main/java/apijson/orm/AbstractSQLExecutor.java
@@ -764,13 +764,18 @@ public void setTransactionIsolation(int transactionIsolation) {
 	}
 
 	@Override
+	private boolean setIsolationStatus = false; //设置事务等级
 	public void begin(int transactionIsolation) throws SQLException {
 		Log.d("\n\n" + TAG, "<<<<<<<<<<<<<< TRANSACTION begin transactionIsolation = " + transactionIsolation + " >>>>>>>>>>>>>>>>>>>>>>> \n\n");
 		//不做判断，如果掩盖了问题，调用层都不知道为啥事务没有提交成功
 		//		if (connection == null || connection.isClosed()) {
 		//			return;
 		//		}
-		connection.setTransactionIsolation(transactionIsolation);
+		connection.setAutoCommit(false);
+		if(! this.setIsolationStatus){ //只设置一次Isolation等级 PG重复设置事务等级会报错
+			connection.setTransactionIsolation(transactionIsolation);
+		}
+		this.setIsolationStatus=true;
 		connection.setAutoCommit(false); //java.sql.SQLException: Can''t call commit when autocommit=true
 	}
 	@Override
