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 AC93ED7206 for ; Wed, 24 Aug 2005 08:25:22 -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 88300-09 for ; Wed, 24 Aug 2005 11:25:19 +0000 (GMT) Received: from secf.com (209-128-104-244.BAYAREA.NET [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 72AC6D72F8 for ; Wed, 24 Aug 2005 08:25:17 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001550941.msg for ; Wed, 24 Aug 2005 04:27:09 -0700 Reply-To: From: "Dinesh Pandey" To: "'PostgreSQL'" Subject: Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Date: Wed, 24 Aug 2005 16:52:27 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0041_01C5A8CC.38700F70" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <20050824111848.BBB54D6E53@svr1.postgresql.org> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcWonRTfZn0P4tamRVWbmjF/pF5ZwgAANIVQ X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Wed, 24 Aug 2005 04:27:09 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-MDAV-Processed: mail.secf.com, Wed, 24 Aug 2005 04:27:10 -0700 Message-Id: <20050824112517.72AC6D72F8@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.314 required=5 tests=[AWL=-0.441, FORGED_RCVD_HELO=0.05, HTML_MESSAGE=0.001, MSGID_FROM_MTA_ID=1.704] X-Spam-Level: * X-Archive-Number: 200508/216 X-Sequence-Number: 22444 This is a multi-part message in MIME format. ------=_NextPart_000_0041_01C5A8CC.38700F70 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0041_01C5A8CC.38700F70 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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=3DTransactionImpl:XidImpl [FormatId=3D257, GlobalId=3Ddinesh//1, = BranchQual=3D] errorCode=3DXA_UNKNOWN(0)

org.jboss.resource.connectionmanager.JBossLocalXAExc= eption: 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

------=_NextPart_000_0041_01C5A8CC.38700F70--