Re: 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/