From dpandey@secf.com Wed Aug 24 11:18:55 2005 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 52BAED7206 for ; Wed, 24 Aug 2005 08:18:55 -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 82639-05 for ; Wed, 24 Aug 2005 11:18:50 +0000 (GMT) Received: from secf.com (209-128-104-244.BAYAREA.NET [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id BBB54D6E53 for ; Wed, 24 Aug 2005 08:18:48 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001550903.msg for ; Wed, 24 Aug 2005 04:19:43 -0700 Reply-To: From: "Dinesh Pandey" To: "'PostgreSQL'" Subject: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Date: Wed, 24 Aug 2005 16:45:06 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003A_01C5A8CB.31036260" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcWonRTfZn0P4tamRVWbmjF/pF5Zwg== X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Wed, 24 Aug 2005 04:19:43 -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:19:44 -0700 Message-Id: <20050824111848.BBB54D6E53@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/215 X-Sequence-Number: 22443 This is a multi-part message in MIME format. ------=_NextPart_000_003A_01C5A8CB.31036260 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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_003A_01C5A8CB.31036260 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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_003A_01C5A8CB.31036260-- From dpandey@secf.com Wed Aug 24 11:25:22 2005 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-- From russellsimpkins@hotmail.com Wed Aug 24 11:37:23 2005 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-- From russellsimpkins@hotmail.com Wed Aug 24 11:38:31 2005 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-- From jfradkin@wazagua.com Wed Aug 24 12:40:39 2005 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 B64ADD730D for ; Wed, 24 Aug 2005 09:40:39 -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 57827-02 for ; Wed, 24 Aug 2005 12:40:35 +0000 (GMT) Received: from svctag-ckgvz71.mailserver.wazagua.com (unknown [209.34.245.244]) by svr1.postgresql.org (Postfix) with ESMTP id 3FC16D732D for ; Wed, 24 Aug 2005 09:40:32 -0300 (ADT) Received: from jfradkin ([66.15.127.235]) by svctag-ckgvz71.mailserver.wazagua.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 24 Aug 2005 08:40:38 -0400 From: "Joel Fradkin" To: , "'PostgreSQL'" Subject: Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Date: Wed, 24 Aug 2005 08:42:49 -0400 Message-ID: <001b01c5a8a9$5667a6a0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001C_01C5A887.CF5606A0" In-Reply-To: <20050824112517.72AC6D72F8@svr1.postgresql.org> X-OriginalArrivalTime: 24 Aug 2005 12:40:38.0671 (UTC) FILETIME=[07FA49F0:01C5A8A9] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.893 required=5 tests=[AWL=-0.184, HTML_MESSAGE=0.001, MSGID_DOLLARS=3.076] X-Spam-Level: ** X-Archive-Number: 200508/221 X-Sequence-Number: 22449 This is a multi-part message in MIME format. ------=_NextPart_000_001C_01C5A887.CF5606A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I am getting ready to start using jboss with postgres (newer to jboss = then postgres). Is there a mailing list for java postgres support? Can you post the connection elements for JBOSS or is that something documented in the JDBC driver? =20 Joel Fradkin =20 Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 =20 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized = review, use, disclosure or distribution is prohibited. If you are not the = intended recipient, please contact the sender by reply email and delete and = destroy all copies of the original message, including attachments. =20 =20 -----Original Message----- From: pgsql-sql-owner@postgresql.org = [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Dinesh Pandey Sent: Wednesday, August 24, 2005 7:22 AM To: 'PostgreSQL' Subject: Re: [SQL] SQLException - SET AUTOCOMMIT TO OFF is no longer supported =20 After using correct version of JDBC driver I am able to start JBOSS = server. =20 Thanks Dinesh Pandey _____ =20 =20 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.= sta rt(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 =20 ------=_NextPart_000_001C_01C5A887.CF5606A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I am getting ready to start using = jboss with postgres (newer to jboss then postgres).

Is there a mailing list for java = postgres support?

Can you post the connection = elements for JBOSS or is that something documented in the JDBC = driver?

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced = tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and = may contain confidential and privileged information. Any unauthorized = review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete = and destroy all copies of the original message, including = attachments.

-----Original = Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] = On Behalf Of Dinesh Pandey
Sent: Wednesday, August = 24, 2005 7:22 AM
To: 'PostgreSQL'
Subject: Re: [SQL] = SQLException - SET AUTOCOMMIT TO OFF is no longer supported

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.connect= ionmanager.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

))

&n= bsp; at = org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.= start(TxConnectionManager.java:654)

&n= bsp; at = org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1196)

&n= bsp; at = org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:649)

Thanks
Dinesh Pandey

------=_NextPart_000_001C_01C5A887.CF5606A0--