Java SQLException isConnectionError(final SQLException error)

Description

Checks if an SQLException is a connection error.

A connection error can be caused by network errors.

License

Apache License

Parameter

Parameter	Description
error	an SQLException to check.

Return

true if error was a connection error, otherwise false.

Declaration

public static boolean isConnectionError(final SQLException error) 

Method Source Code

//package com.java2s;
/*//from  w  w  w  . j  ava 2s.c o m
 * Copyright 2007 the project originators.
 * 
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

import java.sql.SQLException;

public class Main {
    /**
     * Checks if an SQLException is a connection error.<p>
     *
     * A connection error can be caused by network errors.
     *
     * @param error an SQLException to check.
     * 
     * @return <code>true</code> if error was a connection error, otherwise <code>false</code>.
     */
    public static boolean isConnectionError(final SQLException error) {
        int errorCode = error.getErrorCode();

        if (errorCode == 17002) {
            return true;
        } else {
            return false;
        }
    }
}

Related

1. getSingleSQLExceptionCause(SQLException e)
2. getSQLErrorCode(SQLException ex_)
3. getSQLExceptionMessage(SQLException ex)
4. getSqlStateString(SQLException se)
5. getStringFromException(java.lang.Throwable exception)
6. isConstraintViolation(SQLException e)
7. isDatabaseAlreadyExistsException(Exception e)
8. isDataConversionException(SQLException se)
9. isDuplicateKeyException(Exception ex)