SQLException - SET AUTOCOMMIT TO OFF is no longer supported - Mailing list pgsql-sql
| From | Dinesh Pandey |
|---|---|
| Subject | SQLException - SET AUTOCOMMIT TO OFF is no longer supported |
| Date | |
| Msg-id | 20050824111848.BBB54D6E53@svr1.postgresql.org Whole thread Raw |
| Responses |
Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported
("Dinesh Pandey" <dpandey@secf.com>)
|
| List | pgsql-sql |
<div class="Section1"><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">I have created datasource but getting this error on JBOSS startup.</span></font><p class="MsoNormal"><b><fontface="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana;font-weight:bold"> </span></font></b><p class="MsoNormal"><b><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana;font-weight:bold">Using:</span></font></b><font face="Verdana" size="2"><span style="font-size:10.0pt;font-family:Verdana">PostgreSQL 8.0</span></font><p class="MsoNormal"><b><font face="Verdana" size="2"><spanstyle="font-size:10.0pt; font-family:Verdana;font-weight:bold">JBOSS</span></font></b><font face="Verdana" size="2"><span style="font-size:10.0pt;font-family:Verdana">:JBOSS-3.2.6</span></font><p class="MsoNormal"><font face="Verdana" size="2"><spanstyle="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><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 class="MsoNormal"><font face="Verdana" size="2"><spanstyle="font-size:10.0pt; font-family:Verdana">org.jboss.resource.connectionmanager.JBossLocalXAException: Error trying to start local tx: ; - nestedthrowable: (org.jboss.resource.JBossResourceException: </span></font><p class="MsoNormal"><b><font color="blue" face="Verdana"size="2"><span style="font-size:10.0pt;font-family:Verdana;color:blue;font-weight:bold">SQLException; - nestedthrowable: (java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported</span></font></b><p class="MsoNormal"><fontface="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">))</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:654)</span></font><p class="MsoNormal"><fontface="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1196)</span></font><p class="MsoNormal"><fontface="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:649)</span></font><p class="MsoNormal"><fontface="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p><font face="Verdana" size="2"><span style="font-size:10.0pt">Thanks<br /> Dinesh Pandey</span></font><pclass="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt"> </span></font></div>