[CONJ-91] IndexOutOfBounds exception thrown by java.sql.Connection.isValid() Created: 2014-04-11  Updated: 2014-09-09  Resolved: 2014-09-09

Status: Closed
Project: MariaDB Connector/J
Component/s: None
Affects Version/s: None
Fix Version/s: 1.1.8

Type: Bug Priority: Minor
Reporter: Bob Stine Assignee: Massimo Siani (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

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;
 
    }



 Comments   
Comment by Massimo Siani (Inactive) [ 2014-07-07 ]

Test case in rev 515

Generated at Thu Feb 08 03:13:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.