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>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
