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 2CB04D6F4E for ; Wed, 24 Aug 2005 08:37:23 -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 33770-02 for ; Wed, 24 Aug 2005 11:37:20 +0000 (GMT) Received: from hotmail.com (bay103-dav10.bay103.hotmail.com [65.54.174.82]) by svr1.postgresql.org (Postfix) with ESMTP id E5F6ED6ECE for ; Wed, 24 Aug 2005 08:37:17 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 24 Aug 2005 04:37:20 -0700 Message-ID: Received: from 65.54.174.200 by BAY103-DAV10.phx.gbl with DAV; Wed, 24 Aug 2005 11:37:20 +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:37:30 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0079_01C5A87E.AEAF5900" 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:37:20.0923 (UTC) FILETIME=[3057EEB0:01C5A8A0] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.988 required=5 tests=[AWL=-1.800, 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/218 X-Sequence-Number: 22446 This is a multi-part message in MIME format. ------=_NextPart_000_0079_01C5A87E.AEAF5900 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =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 ------=_NextPart_000_0079_01C5A87E.AEAF5900 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

 

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

------=_NextPart_000_0079_01C5A87E.AEAF5900--