[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: Re: [SQL] SQLException - SET AUTOCOMMIT TO OFF is no longer supported
From: "Joel Fradkin" <jfradkin () wazagua ! com>
Date: 2005-08-24 12:42:49
Message-ID: 001b01c5a8a9$5667a6a0$797ba8c0 () jfradkin
[Download RAW message or body]
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.
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.
-----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=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
[Attachment #3 (text/html)]
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{margin-right:0in;
margin-left:0in;
font-size:10.0pt;
font-family:Verdana;}
span.EmailStyle18
{font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;}
span.EmailStyle19
{font-family:Verdana;
color:navy;}
span.EmailStyle20
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I am getting ready to start using jboss
with postgres (newer to jboss then postgres).</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Is there a mailing list for java postgres
support?</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Can you post the connection elements for
JBOSS or is that something documented in the JDBC driver?</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Joel Fradkin</span></font></p>
<div>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'> </span></font></p>
</div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Wazagua, Inc.<br>
2520 Trailmate Dr<br>
Sarasota, F</span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>lorid</span></font><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>a 34243<br>
Tel. 941-753-7111 ext 305</span></font></p>
<div>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'> </span></font></p>
</div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><a \
href="mailto:jfradkin@wazagua.com">jfradkin@wazagua.com</a><br> <a \
href="http://www.wazagua.com">www.wazagua.com</a><br> Powered by Wazagua<br>
Providing you with the latest Web-based technology & advanced tools.<br>
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc<br>
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.</span></font></p>
<div>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'> </span></font></p>
</div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><br>
</span></font><font color=navy><span style='color:navy'> </span></font></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Dinesh Pandey<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, August 24, 2005
7:22 AM<br>
<b><span style='font-weight:bold'>To:</span></b> 'PostgreSQL'<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [SQL] SQLException -
SET AUTOCOMMIT TO OFF is no longer supported</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy
face=Verdana><span style='font-size:10.0pt;font-family:Verdana;color:navy'>After
using correct version of JDBC driver I am able to start JBOSS \
server.</span></font></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=navy
face="Times New Roman"><span \
style='font-size:12.0pt;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'>Thanks<br>
Dinesh Pandey</span></font></p>
</div>
<div>
<div class=MsoNormal align=center style='margin-left:.5in;text-align:center'><font
size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>
<hr size=2 width="100%" align=center>
</span></font></div>
</div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy
face=Verdana><span style='font-size:10.0pt;font-family:Verdana;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>I have created datasource but
getting this error on JBOSS startup.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><b><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;font-weight:bold'> </span></font></b></p>
<p class=MsoNormal style='margin-left:.5in'><b><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;font-weight:bold'>Using:</span></font></b><font
size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>
PostgreSQL 8.0</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><b><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;font-weight:bold'>JBOSS</span></font></b><font
size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>:
JBOSS-3.2.6</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>16:09:37,093 WARN
[TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257,
GlobalId=dinesh//1, BranchQual=] errorCode=XA_UNKNOWN(0)</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>org.jboss.resource.connectionmanager.JBossLocalXAException:
Error trying to start local tx: ; - nested throwable:
(org.jboss.resource.JBossResourceException: </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><b><font size=2 color=blue
face=Verdana><span style='font-size:10.0pt;font-family:Verdana;color:blue;
font-weight:bold'>SQLException; - nested throwable: (java.sql.SQLException:
ERROR: SET AUTOCOMMIT TO OFF is no longer supported</span></font></b></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>))</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:654)</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>
at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1196)</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>
at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:649)</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'> </span></font></p>
<p style='margin-left:.5in'><font size=2 face=Verdana><span style='font-size:
10.0pt'>Thanks<br>
Dinesh Pandey</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic