Postgres Pro
Downloads
Home   >   mailing lists

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

From Dinesh Pandey
Subject Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported
Date
Msg-id 20050824112517.72AC6D72F8@svr1.postgresql.org
Whole thread Raw
In response to SQLException - SET AUTOCOMMIT TO OFF is no longer supported  ("Dinesh Pandey" <dpandey@secf.com>)
Responses Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported  ("Joel Fradkin" <jfradkin@wazagua.com>)
List pgsql-sql
Tree view

After using correct version of JDBC driver I am able to start JBOSS server.

 

Thanks
Dinesh Pandey

 

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

 

pgsql-sql by date:

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