[GENERAL] postgresql-9.0-801.jdbc4.jar always cause org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled Exception

Hello list, . 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(); Always got: === ### Error committing

Re: [GENERAL] postgresql-9.0-801.jdbc4.jar always cause org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled Exception

SqlSession sql_session = sqlSessionFactory.openSession(false); sql_session.commit(); We'll presume that you intend (intentionally or otherwise) for auto-commit to be on since you do not reference any actual JDBC method calls here... While for 8.4-702 JDBC 4, the same codes, no

Re: [GENERAL] postgresql-9.0-801.jdbc4.jar always cause org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled Exception

David, SqlSession sql_session = sqlSessionFactory.openSession(false); sql_session.commit(); We'll presume that you intend (intentionally or otherwise) for auto-commit to be on since you do not reference any actual JDBC method calls here... I'd like always autocommit = false jdbc8.4

Re: [GENERAL] postgresql-9.0-801.jdbc4.jar always cause org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled Exception

-Original Message- From: Emi Lu [mailto:em...@encs.concordia.ca] Sent: Tuesday, May 31, 2011 2:06 PM To: David Johnston Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] postgresql-9.0-801.jdbc4.jar always cause org.postgresql.util.PSQLException: Cannot commit when autoCommit