[DERBY-1090] Implement Connection.isValid as defined by JDBC4

• Type: Sub-task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 10.2.1.6
• Component/s: JDBC
• Assignee: Olav Sandstaa
• Reporter: Olav Sandstaa
• Created: 09/Mar/06 05:25
• Updated: 29/Aug/12 21:39
• Resolved: 15/May/06 15:03

Description

The Javadoc for JDBC4 says this about Connection.isValid:

boolean isValid(int timeout) throws SQLException

Returns true if the connection has not been closed and is still valid. The driver shall submit a query on the connection or use some other mechanism that positively verifies the connection is still valid when this method is called.

The query submitted by the driver to validate the connection shall be executed in the context of the current transaction.

Parameters: timeout - - The time in seconds to wait for the database operation used to validate the connection to complete. If the timeout period expires before the operation completes, this method returns false. A value of 0 indicates a timeout is not applied to the database operation.

Returns: true if the connection is valid, false otherwise

Issue Links

• relates to: DERBY-5912 testIsValidImplemented fails for NetworkServer in some slow running machines/configurations