[DERBY-2532] Client does not return SQLException on XAConnection.getXAResource() on a closed connection, Embedded does

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.5.3.1, 10.6.2.1, 10.7.1.1
• Component/s: Network Client
• Bug behavior facts: Embedded/Client difference
• Assignee: Sabari S Kumar
• Reporter: Myrna van Lunteren
• Created: 09/Apr/07 05:52
• Updated: 13/Jan/11 21:48
• Resolved: 04/Jun/10 09:56

Description

In the following scenario from converted test DataSourceTest:
(non-tested code based on the test code)
----------------
ClientXADataSource dsx = new ClientXADataSource();
dsx.setDatabaseName("tstdb");
XAConnection xac = dsx.getXAConnection();
XAConnection xac2 = dsx.getXAConnection();
XAResource xar2 = xac2.getXAResource();
xac2.close();

// allow close on already closed XAConnection
xac2.close();
try

{ xac2.getXAResource(); // Network Server does not think this is worth an exception. }

catch (SQLException sqle)

{ System.out.println("expect a 08003 as with Embedded"); }

------------------
With DerbyNetClient, the xac2.getXAResource() does not return an SQLException.

This ought to be documented if expected, or fixed.

Issue Links

• is part of: DERBY-310 Document and/or change Derby client code to match behavior with Embedded driver where possible.
• relates to: DERBY-2492 convert checkDataSource, checkDataSource30 and checkDriver.java to junit