SET AUTOCOMMIT TO OFF is no longer supported

Поиск
Список
Период
Сортировка
От Jamie Deppeler
Тема SET AUTOCOMMIT TO OFF is no longer supported
Дата
Msg-id 42C86DCD.7060800@doitonce.net.au
обсуждение исходный текст
Ответы Re: SET AUTOCOMMIT TO OFF is no longer supported  (Michael Fuhr <mike@fuhr.org>)
Список 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>

В списке pgsql-general по дате отправления:

Предыдущее
От: "Andrus Moor"
Дата:
Сообщение: Re: Hot to restrict access to subset of data
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: SET AUTOCOMMIT TO OFF is no longer supported