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