[ http://issues.apache.org/jira/browse/DERBY-346?page=all ]
Kathey Marsden updated DERBY-346:
---------------------------------
Attachment: derby346.diff
This patch changes Network Server to pass the holdability to the prepare method
of BrokeredConnection30 when running under JDK14.
It also adds the jdbcapi/xaSimplePositive.sql test to the derbynetclientmats
test suite. The netxapositive test has been removed as it was a subset of
xaSimplePositive.
Note:It seems that under JDK13 the default holdability for BrokeredConnections
in global transactions is consistently, CLOSE_CURSORS_AT_COMMIT, but for
JDK141, the default holdability is sometimes set to HOLD_CURSORS_OVER_COMMIT.
Ran jdbcapi/xaSimplePositive.sql test under JDK131 and JDK142 as well as
derbyentclientmats.
> 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.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Attachments: derby346.diff
>
> 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
