"postgresql-9.0-801.jdbc4.jar" Causing "Error committing transaction. Cause: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled." Exception - Mailing list pgsql-jdbc

From Emi Lu
Subject "postgresql-9.0-801.jdbc4.jar" Causing "Error committing transaction. Cause: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled." Exception
Date
Msg-id 4DE52F68.9060909@encs.concordia.ca
Whole thread Raw
Responses Re: "postgresql-9.0-801.jdbc4.jar" Causing "Error committing transaction. Cause: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled." Exception  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Hello list,

JDBC8 returns autocommit = false; which is what I want.

But when I upgrade to JDBC9, I got:
===================================================
### Error committing transaction.  Cause:
org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.

Is there anything need to be configured if using
"postgresql-9.0-801.jdbc4.jar" to set autocommit = false always?

I use springframework3.0.5 + mybatis3 to setup DB connections:

applicationContext-mybatis.xml

<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
       <property name="driverClassName" value="${driverClassName}" />
       <property name="url"             value="${url}"      />
       <property name="username"        value="${username}" />
       <property name="password"        value="${password}" />
</bean>


This codes return autocommit= false for JDBC8; while JDBC9 returns
autocommit=true as default.


Thanks a lot!
Emi
---

. Postgresql8.3

. mybatis-3.0.5-SNAPSHOT.jar
. mybatis-spring-1.0.1-SNAPSHOT.jar
. spring3.0.5

. postgresql-9.0-801.jdbc4.jar


SqlSession sql_session = sqlSessionFactory.openSession(false);
....
sql_session.commit();






pgsql-jdbc by date:

Previous
From: Emi Lu
Date:
Subject: "postgresql-9.0-801.jdbc4.jar" Causing "Error committing transaction. Cause: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled." Exception
Next
From: Simon Mitchell
Date:
Subject: Re: PreparedStatement error for date parameter with overlaps