Postgres Pro
Downloads
Home   >   mailing lists

Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported - Mailing list pgsql-sql

From Russell Simpkins
Subject Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported
Date
Msg-id BAY103-DAV10836E7F29403766F12C34B5A80@phx.gbl
Whole thread Raw
In response to SQLException - SET AUTOCOMMIT TO OFF is no longer supported  ("Dinesh Pandey" <dpandey@secf.com>)
List pgsql-sql
Tree view
 

I have created datasource but getting this error on JBOSS startup.

 

Using: PostgreSQL 8.0

JBOSS: JBOSS-3.2.6

 

16:09:37,093 WARN  [TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=dinesh//1, BranchQual=] errorCode=XA_UNKNOWN(0)

org.jboss.resource.connectionmanager.JBossLocalXAException: Error trying to start local tx: ; - nested throwable: (org.jboss.resource.JBossResourceException:

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:654)

        at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1196)

 

        at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:649)

 

Thanks
Dinesh Pandey

I think you need to get a more up to date version of your JDBC Driver

pgsql-sql by date:

Previous
From: "Russell Simpkins"
Date:
Subject: Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported
Next
From: John DeSoi
Date:
Subject: Re: Number of rows in a cursor ?