Thread: SET AUTOCOMMIT TO OFF is no longer supported

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>

On Mon, Jul 04, 2005 at 08:59:25AM +1000, Jamie Deppeler wrote:
>
> 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.

Server-side AUTOCOMMIT was removed in 7.4 for having been a Bad Idea.

http://www.postgresql.org/docs/7.4/static/release-7-4.html
http://archives.postgresql.org/pgsql-committers/2003-05/msg00080.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/