Postgres 7.4.1 - SET AUTOCOMMIT TO OFF is no longer supporte

[ebdr]

Hi,

I upgraded postgres from 7.2 to 7.4.1 and using jboss-3.2.0_tomcat-4.1.24. I am getting the following error when trying access data with my entity EJBs. Where is the autocommit defined in the configuration files of JBoss?

org.jboss.resource.connectionmanager.JBossLocalXAException: Error trying to start local tx: ; - nested throwable: (org.jboss.resource.JBossResourceExc
eption: SQLException; - nested throwable: (java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported
))
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:729)
at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1137)
at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:624)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:460)
at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:358)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:490)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:798)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:120)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:91)

Thank you for your help,

Eric

[ebdr]

Hi Again,

Sorry about the noise. This error was caused by me using the wrong version jdbc driver. After using the proper jdbc driver, it all worked fine.

best regards,

Eric

[gonegolfin]

Eric,

Exactly which driver are you using now? I was using pg73jdbc3.jar with 7.3.2. I upgraded to PostgreSQL 7.4.1 and am seeing the same problem you are. I had thought that pg73jdbc3.jar is the latest.

Thanks,
Brian

[jrd]

Eric,
I had the same problem and I just downloaded the latest JDBC driver (7.4.1) and it fixed the problem.

http://jdbc.postgresql.org/download.html

--jD