SET AUTOCOMMIT TO OFF is no longer supported

From: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: SET AUTOCOMMIT TO OFF is no longer supported
Date: 2005-07-03 22:59:25
Message-ID: 42C86DCD.7060800@doitonce.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am application that we have built using postgresql 8.0.3 and tomcat
5.0.28. In the java code i have put a state set autocomit to false
which should be fine but comes up with the error SET AUTOCOMMIT TO OFF
is no longer supported.

I have tried using 2 drivers 7.4 and 8 jdbc driver

stack trace

java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported

Stack trace:QueryExecutor.java ::
org.postgresql.core.QueryExecutor.execute() <131>
AbstractJdbc1Connection.java ::
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL() <482>
AbstractJdbc1Connection.java ::
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL() <461>
AbstractJdbc1Connection.java ::
org.postgresql.jdbc1.AbstractJdbc1Connection.setAutoCommit() <957>
DelegatingConnection.java ::
org.apache.commons.dbcp.DelegatingConnection.setAutoCommit() <268>
PoolingDriver.java ::
org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.setAutoCommit()
<353>
SQLDataSource.java ::
com.once.server.data.source.sql.SQLDataSource.executeInsertCommand() <540>
DataWrapper.java :: com.once.server.data.DataWrapper.executeQuery() <199>
ActionSQL.java :: com.once.ActionSQL.doPost() <142>
HttpServlet.java :: javax.servlet.http.HttpServlet.service() <760>
HttpServlet.java :: javax.servlet.http.HttpServlet.service() <853>
ApplicationFilterChain.java ::
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter() <237>
ApplicationFilterChain.java ::
org.apache.catalina.core.ApplicationFilterChain.doFilter() <157>
StandardWrapperValve.java ::
org.apache.catalina.core.StandardWrapperValve.invoke() <214>
StandardValveContext.java ::
org.apache.catalina.core.StandardValveContext.invokeNext() <104>
StandardPipeline.java ::
org.apache.catalina.core.StandardPipeline.invoke() <520>
StandardContextValve.java ::
org.apache.catalina.core.StandardContextValve.invokeInternal() <198>
StandardContextValve.java ::
org.apache.catalina.core.StandardContextValve.invoke() <152>
StandardValveContext.java ::
org.apache.catalina.core.StandardValveContext.invokeNext() <104>
StandardPipeline.java ::
org.apache.catalina.core.StandardPipeline.invoke() <520>
StandardHostValve.java ::
org.apache.catalina.core.StandardHostValve.invoke() <137>
StandardValveContext.java ::
org.apache.catalina.core.StandardValveContext.invokeNext() <104>
ErrorReportValve.java ::
org.apache.catalina.valves.ErrorReportValve.invoke() <118>
StandardValveContext.java ::
org.apache.catalina.core.StandardValveContext.invokeNext() <102>
StandardPipeline.java ::
org.apache.catalina.core.StandardPipeline.invoke() <520>
StandardEngineValve.java ::
org.apache.catalina.core.StandardEngineValve.invoke() <109>
StandardValveContext.java ::
org.apache.catalina.core.StandardValveContext.invokeNext() <104>
StandardPipeline.java ::
org.apache.catalina.core.StandardPipeline.invoke() <520>
ContainerBase.java :: org.apache.catalina.core.ContainerBase.invoke()
<929>
CoyoteAdapter.java :: org.apache.coyote.tomcat5.CoyoteAdapter.service()
<160>
Http11Processor.java ::
org.apache.coyote.http11.Http11Processor.process() <799>
Http11Protocol.java ::
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection()
<705>
PoolTcpEndpoint.java ::
org.apache.tomcat.util.net.TcpWorkerThread.runIt() <577>
ThreadPool.java ::
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run() <683>
Thread.java :: java.lang.Thread.run() <552>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-07-03 23:31:08 Re: SET AUTOCOMMIT TO OFF is no longer supported
Previous Message Andrus Moor 2005-07-03 21:04:31 Re: Which record causes referential integrity violation on delete