Re: SET AUTOCOMMIT TO OFF is no longer supported

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>

On 07/12/2003 02:07 Arcadius A. wrote:
> 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

The JDBC driver source is in the PostgreSQL source tarball available at
all the usual mirror sites. It's also available at
http://jdbc.postgresql.org/download.html.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

Paul Thomas wrote:
> The JDBC driver source is in the PostgreSQL source tarball available at
> all the usual mirror sites. It's also available at
> http://jdbc.postgresql.org/download.html.
>

Thanks.
I just want to point out that the developement version of the driver at
http://jdbc.postgresql.org/download.html (devpgjdbc3.jar),solved my
problem of "SET AUTOCOMMIT TO OFF is no longer supported" . It seems to
be a bit old, but it works.

Regards.

Arcadius.

On 07/12/2003 15:10 Arcadius A. wrote:
> Paul Thomas wrote:
>> The JDBC driver source is in the PostgreSQL source tarball available at
>> all the usual mirror sites. It's also available at
>> http://jdbc.postgresql.org/download.html.
>>
>
> Thanks.
> I just want to point out that the developement version of the driver at
> http://jdbc.postgresql.org/download.html (devpgjdbc3.jar),solved my
> problem of "SET AUTOCOMMIT TO OFF is no longer supported" . It seems to
> be a bit old, but it works.

It looks like its the same build number as in the tarball (209). I'm not
sure why its still considered beta.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+