Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported

From: "Russell Simpkins" <russellsimpkins(at)hotmail(dot)com>
To: <dpandey(at)secf(dot)com>, "'PostgreSQL'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported
Date: 2005-08-24 11:38:40
Message-ID: BAY103-DAV10836E7F29403766F12C34B5A80@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message John DeSoi 2005-08-24 12:08:22 Re: Number of rows in a cursor ?
Previous Message Russell Simpkins 2005-08-24 11:37:30 Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported