Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
-
32-bigt CentOS 6.5
Description
I have a daemon that keeps a SQL connection open. It periodically checks the status of the connection using java.sql.Connection.isValid.
I've been running this for months. Today I saw the method throw exception java.lang.IndexOutOfBoundsException. I dealt with it like I would an SQLException, but it suggests that there is a bug in the JDBC driver.
Here's the method:
public boolean connectionIsValid()
|
{
|
final int maxSecondsToWait = 2;
|
|
boolean isValid;
|
|
if (_conn == null)
|
{
|
isValid = false;
|
}
|
else
|
{
|
try
|
{
|
isValid = _conn.isValid(maxSecondsToWait);
|
}
|
catch (Throwable ex)
|
{
|
isValid = false;
|
_logger.error(String.format("AuditorDB.connectionIsValid error: %s", ex.toString()));
|
}
|
}
|
|
return isValid;
|
}
|