SET AUTOCOMMIT TO OFF is no longer supported - Mailing list pgsql-jdbc
From | Arcadius A. |
---|---|
Subject | SET AUTOCOMMIT TO OFF is no longer supported |
Date | |
Msg-id | 3FD28B67.6070000@sh.cvut.cz Whole thread Raw |
Responses |
Re: SET AUTOCOMMIT TO OFF is no longer supported
|
List | pgsql-jdbc |
Hello! I'm writing a very simple application in WebLogic WorkShop 8.1. I'm using the pg73jdbc3.jar for the PostgreSQL7.4 DB. I didn't have any problem setting up weblogic connection pool and datasource .... but at run time, I get the following error: SET AUTOCOMMIT TO OFF is no longer supported. The stacktrace is appended at the end of this message. I've googled a bit and found out that the problem is with the JDBC driver and that I should get a new source from a CVS repository and compile it. Now, I'm trying to get the source code from the CVS .... but it's taking too long. Please has anyone got a compiled version of the new JDBC driver for PostgreSQL7.4 ? Thanks in advance. Arcadius. PS: I apologize if this message has been sent twice. <stacktrace> Submitted at Sunday, December 7, 2003 1:04:26 AM CET java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:482) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:461) at org.postgresql.jdbc1.AbstractJdbc1Connection.setAutoCommit(AbstractJdbc1Connection.java:957) at weblogic.jdbc.wrapper.JTSConnection.init(JTSConnection.java:82) at weblogic.jdbc.jts.Driver.newConnection(Driver.java:680) at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:196) at weblogic.jdbc.jts.Driver.connect(Driver.java:154) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:298) at com.bea.wlw.runtime.core.control.DatabaseControlImpl.getConnection(DatabaseControlImpl.jcs:1360) at com.bea.wlw.runtime.core.control.DatabaseControlImpl.context_onAcquire(DatabaseControlImpl.jcs:1252) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:353) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:420) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:393) at com.bea.wlw.runtime.core.container.Invocable.fireEvent(Invocable.java:603) at com.bea.wlw.runtime.core.context.WlwThreadContext.sendEvent(WlwThreadContext.java:989) at com.bea.wlw.runtime.core.context.WlwThreadContext.raiseEvent(WlwThreadContext.java:919) at com.bea.wlw.runtime.core.container.Container.raiseContextEvent(Container.java:553) at com.bea.wlw.runtime.jcs.container.JcsContainer.onAcquire(JcsContainer.java:513) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:353) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:420) at com.bea.wlw.runtime.core.container.Invocable.sendContextEvent(Invocable.java:524) at com.bea.wlw.runtime.jcs.container.JcsContainer.sendContextEvent(JcsContainer.java:464) at com.bea.wlw.runtime.core.context.WlwThreadContext.acquireResources(WlwThreadContext.java:676) at com.bea.wlw.runtime.jcs.container.JcsProxy.invoke(JcsProxy.java:307) at $Proxy9.getConnection(Unknown Source) at dp.findById(dp.jws:28) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:353) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:420) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:393) at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:245) at com.bea.wlw.runtime.core.bean.BaseContainerBean.invokeBase(BaseContainerBean.java:185) at com.bea.wlw.runtime.core.bean.SLSBContainerBean.invoke(SLSBContainerBean.java:103) at com.bea.wlwgen.StatelessContainer_ly05hg_ELOImpl.invoke(StatelessContainer_ly05hg_ELOImpl.java:153) at com.bea.wlwgen.GenericStatelessSLSBContAdpt.invokeOnBean(GenericStatelessSLSBContAdpt.java:59) at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(BaseDispatcherBean.java:160) at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.invoke(BaseDispatcherBean.java:54) at com.bea.wlw.runtime.core.bean.SyncDispatcherBean.invoke(SyncDispatcherBean.java:159) at com.bea.wlw.runtime.core.bean.SyncDispatcher_k1mrl8_EOImpl.invoke(SyncDispatcher_k1mrl8_EOImpl.java:100) at com.bea.wlw.runtime.core.dispatcher.Dispatcher.remoteDispatch(Dispatcher.java:134) at com.bea.wlw.runtime.core.dispatcher.Dispatcher.dispatch(Dispatcher.java:46) at com.bea.wlw.runtime.core.dispatcher.HttpServerHelper.exploreExec(HttpServerHelper.java:253) at com.bea.wlw.runtime.core.dispatcher.HttpServerHelper.executeGetRequest(HttpServerHelper.java:570) at com.bea.wlw.runtime.core.dispatcher.HttpServer.doGet(HttpServer.java:81) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:305) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6310) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3622) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2569) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170) </stacktrace>
pgsql-jdbc by date: