Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 37648 invoked from network); 22 Jun 2005 18:24:25 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 22 Jun 2005 18:24:25 -0000 Received: (qmail 66910 invoked by uid 500); 22 Jun 2005 18:24:23 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 66858 invoked by uid 500); 22 Jun 2005 18:24:22 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 66823 invoked by uid 99); 22 Jun 2005 18:24:22 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Jun 2005 11:24:22 -0700 Received: from ajax.apache.org (ajax.apache.org [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 41F9A15 for ; Wed, 22 Jun 2005 20:24:21 +0200 (CEST) Message-ID: <1769225092.1119464661269.JavaMail.jira@ajax.apache.org> Date: Wed, 22 Jun 2005 20:24:21 +0200 (CEST) From: "Kathey Marsden (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Closed: (DERBY-346) running jdbcapi/xaSimplePostive.sql under the DerbyNetClient framework gives error "Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction." In-Reply-To: <1067364826.1118425335204.JavaMail.jira@ajax.apache.org> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/DERBY-346?page=all ] Kathey Marsden closed DERBY-346: -------------------------------- > running jdbcapi/xaSimplePostive.sql under the DerbyNetClient framework gives error "Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction." > -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-346 > URL: http://issues.apache.org/jira/browse/DERBY-346 > Project: Derby > Type: Bug > Components: Network Client > Versions: 10.1.1.0 > Reporter: Kathey Marsden > Assignee: Kathey Marsden > Fix For: 10.2.0.0 > > Running jdbcapi/xaSimplePositive.sql with network client causes an error in the last case: > Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction. > The trace on the client is: > ij(XA)> select * from APP.global_xactTable where gxid is not null order by gxid; > ERROR XJ05C: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ05C, SQLERRMC: XJ05C.S > org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ05C, SQLERRMC: XJ05C.S > at org.apache.derby.client.am.Statement.completeSqlca(Statement.java:1354) > at org.apache.derby.client.am.Statement.completeOpenQuery(Statement.java:1025) > at org.apache.derby.client.net.NetStatementReply.parseOpenQueryFailure(NetStatementReply.java:503) > at org.apache.derby.client.net.NetStatementReply.parseOPNQRYreply(NetStatementReply.java:226) > at org.apache.derby.client.net.NetStatementReply.readOpenQuery(NetStatementReply.java:56) > at org.apache.derby.client.net.StatementReply.readOpenQuery(StatementReply.java:49) > at org.apache.derby.client.net.NetStatement.readOpenQuery_(NetStatement.java:151) > at org.apache.derby.client.am.Statement.readOpenQuery(Statement.java:1021) > at org.apache.derby.client.am.Statement.flowExecute(Statement.java:1556) > at org.apache.derby.client.am.Statement.executeX(Statement.java:631) > at org.apache.derby.client.am.Statement.execute(Statement.java:622) > at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:299) > at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:433) > at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:312) > at org.apache.derby.impl.tools.ij.Main.go(Main.java:203) > at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169) > at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55) > at org.apache.derby.tools.ij.main(ij.java:60) > On the server, the trace is: > Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction. > SQL Exception: Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction. > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:79) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:96) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:160) > at org.apache.derby.jdbc.EmbedXAConnection.checkHoldCursors(EmbedXAConnection.java:712) > at org.apache.derby.jdbc.XAStatementControl.checkHoldCursors(XAStatementControl.java:193) > at org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.execute(BrokeredPreparedStatement.java:426) > at org.apache.derby.impl.drda.DRDAStatement.execute(DRDAStatement.java:548) > at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(DRDAConnThread.java:3533) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:871) > at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:226) > handle SQLException here > I have been trying to get the jdbcapi/xaSimplePostive.sql test running with network client. The changes for DERBY -246 and DERBY-339 allow all but the last case in xaSimplePositve to pass. Unfortunately I have not yet been able to strip down the test to get a smaller reproducable case. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira