SQLException - SET AUTOCOMMIT TO OFF is no longer supported

From: "Dinesh Pandey" <dpandey(at)secf(dot)com>
To: "'PostgreSQL'" <pgsql-sql(at)postgresql(dot)org>
Subject: SQLException - SET AUTOCOMMIT TO OFF is no longer supported
Date: 2005-08-24 11:15:06
Message-ID: 20050824111848.BBB54D6E53@svr1.postgresql.org
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.sta
rt(TxConnectionManager.java:654)

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

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

Thanks
Dinesh Pandey

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dinesh Pandey 2005-08-24 11:22:27 Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported
Previous Message Bo Lorentsen 2005-08-24 10:31:12 Re: Number of rows in a cursor ?