X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A1814D7236 for ; Wed, 24 Aug 2005 08:38:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97414-10 for ; Wed, 24 Aug 2005 11:38:29 +0000 (GMT) Received: from hotmail.com (bay103-dav10.bay103.hotmail.com [65.54.174.82]) by svr1.postgresql.org (Postfix) with ESMTP id 86176D715A for ; Wed, 24 Aug 2005 08:38:28 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 24 Aug 2005 04:38:32 -0700 Message-ID: Received: from 65.54.174.200 by BAY103-DAV10.phx.gbl with DAV; Wed, 24 Aug 2005 11:38:31 +0000 X-Originating-IP: [65.54.174.200] X-Originating-Email: [russellsimpkins@hotmail.com] X-Sender: russellsimpkins@hotmail.com From: "Russell Simpkins" To: , "'PostgreSQL'" References: <20050824111848.BBB54D6E53@svr1.postgresql.org> Subject: Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Date: Wed, 24 Aug 2005 07:38:40 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0082_01C5A87E.D8FEA580" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-OriginalArrivalTime: 24 Aug 2005 11:38:32.0156 (UTC) FILETIME=[5ACD39C0:01C5A8A0] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.093 required=5 tests=[AWL=-1.695, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, FORGED_MUA_OUTLOOK=3.037, HTML_MESSAGE=0.001, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: *** X-Archive-Number: 200508/219 X-Sequence-Number: 22447 This is a multi-part message in MIME format. ------=_NextPart_000_0082_01C5A87E.D8FEA580 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have created datasource but getting this error on JBOSS startup. =20 Using: PostgreSQL 8.0 JBOSS: JBOSS-3.2.6 =20 16:09:37,093 WARN [TransactionImpl] XAException: = tx=3DTransactionImpl:XidImpl [FormatId=3D257, GlobalId=3Ddinesh//1, = BranchQual=3D] errorCode=3DXA_UNKNOWN(0) org.jboss.resource.connectionmanager.JBossLocalXAException: Error = trying to start local tx: ; - nested throwable: = (org.jboss.resource.JBossResourceException:=20 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) =20 at = org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:649) =20 Thanks Dinesh Pandey I think you need to get a more up to date version of your JDBC Driver ------=_NextPart_000_0082_01C5A87E.D8FEA580 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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

Using:=20 PostgreSQL 8.0

JBOSS:=20 JBOSS-3.2.6

16:09:37,093 = WARN =20 [TransactionImpl] XAException: tx=3DTransactionImpl:XidImpl = [FormatId=3D257,=20 GlobalId=3Ddinesh//1, BranchQual=3D]=20 errorCode=3DXA_UNKNOWN(0)

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

SQLException;=20 - nested throwable: (java.sql.SQLException: ERROR: SET = AUTOCOMMIT TO OFF=20 is no longer supported

))

       =20 at=20 = org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.= start(TxConnectionManager.java:654)

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

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

Thanks
Dinesh=20 Pandey

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

------=_NextPart_000_0082_01C5A87E.D8FEA580--