Skip to content

在批量插入PG的时候会报错重复设置事务等级的bug。 #316

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
TommyLemon merged 2 commits into from
Sep 30, 2021
Merged

在批量插入PG的时候会报错重复设置事务等级的bug。 #316

Changes from 1 commit
Commits
Show all changes
2 commits
Select commit Hold shift + click to select a range
d6cb2e1
fix PG的重复设置事务等级的bug
Sep 28, 2021
0ca192a
fix PG的重复设置事务等级的bug
Sep 28, 2021
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Next Next commit
fix PG的重复设置事务等级的bug
  • Loading branch information
tianzhenyu
tianzhenyu committed Sep 28, 2021
commit d6cb2e14fb878cd83d0bb4f6972935fd8c3aa7e9
7 changes: 6 additions & 1 deletion APIJSONORM/src/main/java/apijson/orm/AbstractSQLExecutor.java
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -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
Expand Down