Re: 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: Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported
Date: 2005-08-24 11:22:27
Message-ID: 20050824112517.72AC6D72F8@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Russell Simpkins 2005-08-24 11:36:29 Re: Number of rows in a cursor ?
Previous Message Dinesh Pandey 2005-08-24 11:15:06 SQLException - SET AUTOCOMMIT TO OFF is no longer supported