Java SQLException getSqlStateString(SQLException se)

Description

get Sql State String

License

Apache License

Declaration

public static StringBuilder getSqlStateString(SQLException se) 

Method Source Code

//package com.java2s;
/*/*from w w  w  .  j  ava2 s . c om*/
 * ExceptionUtil.java
 *
 * This file is part of SQL Workbench/J, http://www.sql-workbench.net
 *
 * Copyright 2002-2017, Thomas Kellerer
 *
 * Licensed under a modified Apache License, Version 2.0
 * that restricts the use for certain governments.
 * You may not use this file except in compliance with the License.
 * You may obtain a copy of the License at.
 *
 *     http://sql-workbench.net/manual/license.html
 *
 * 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.
 *
 * To contact the author please send an email to: support@sql-workbench.net
 *
 */

import java.sql.SQLException;

public class Main {
    public static StringBuilder getSqlStateString(SQLException se) {
        StringBuilder result = new StringBuilder(30);
        try {
            String state = se.getSQLState();
            if (state != null && state.length() > 0) {
                result.append("SQL State=");
                result.append(state);
            }
            int error = se.getErrorCode();
            if (error != 0) {
                if (result.length() > 0)
                    result.append(", ");
                result.append("DB Errorcode=");
                result.append(Integer.toString(error));
            }
        } catch (Throwable th) {
            //result.append("(unknown)");
        }
        return result;
    }
}

Related

1. getFullMessage(SQLException exception)
2. getNextExceptionFromLastCause(Exception e)
3. getSingleSQLExceptionCause(SQLException e)
4. getSQLErrorCode(SQLException ex_)
5. getSQLExceptionMessage(SQLException ex)
6. getStringFromException(java.lang.Throwable exception)
7. isConnectionError(final SQLException error)
8. isConstraintViolation(SQLException e)
9. isDatabaseAlreadyExistsException(Exception e)