[DERBY-2065] Network and embedded difference in SQLSTATE and message when Connection.close() with open transaction.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 10.4.1.3
• Component/s: Network Client, Network Server
• Issue & fix info: Release Note Needed
• Assignee: Jorgen Loland
• Reporter: Bernt Johnsen
• Created: 09/Nov/06 09:31
• Updated: 30/Jun/09 16:12
• Resolved: 30/Oct/07 11:54

Description

Network and embedded difference in SQLSTATE and message when Connection.close() with open transaction.
----------- NetworkClient --------------
Message: Cannot close a connection while a transaction is still active.
SQLState: 25001
----------- Embedded --------------
Message: Invalid transaction state.
SQLState: 25000

Issue Links

• duplicates: DERBY-1166 Incorrect SQLState used in EmbedConnection.java.close() when there is an active transaction
• is duplicated by: DERBY-3114 Harmonize sql state thrown when closing a connection with pending transaction between net end embedded drivers
• is part of: DERBY-310 Document and/or change Derby client code to match behavior with Embedded driver where possible.