Java by API/java.sql/SQLException

SQLException: getErrorCode()

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   String url = "jdbc:odbc:databaseName";
   String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
   String user = "guest";
   String password = "guest";
   String theStatement = "SELECT lastname, firstname FROM autors";
   try {
     Class.forName(driver);
     Connection connection = DriverManager.getConnection(url, user, password);
     Statement queryAuthors = connection.createStatement();
     ResultSet theResults = queryAuthors.executeQuery(theStatement);
     queryAuthors.close();
   } catch (ClassNotFoundException cnfe) {
     System.err.println(cnfe);
   } catch (SQLException sqle) {
     String sqlMessage = sqle.getMessage();
     String sqlState = sqle.getSQLState();
     int vendorCode = sqle.getErrorCode();
     System.err.println("Exception occurred:");
     System.err.println("Message: " + sqlMessage);
     System.err.println("SQL state: " + sqlState);
     System.err.println("Vendor code: " + vendorCode + "\n----------------");
   }
 }

}

 </source>
   
  
 
  

SQLException: getNextException()

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main {

 public static void main(String[] args) {
   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   try {
     String driver = "oracle.jdbc.driver.OracleDriver";
     Class.forName(driver).newInstance();
     System.out.println("Connecting to database...");
     String jdbcUrl = "jdbc:oracle:thin:@localhost:1521:ORCL";
     conn = DriverManager.getConnection(jdbcUrl, "yourName", "mypwd");
     stmt = conn.createStatement();
     try {
       rs = stmt.executeQuery("Select * from no_table_exisits");
     } catch (SQLException seRs) {
       String exMsg = "Message from MySQL Database";
       String exSqlState = "Exception";
       SQLException mySqlEx = new SQLException(exMsg, exSqlState);
       seRs.setNextException(mySqlEx);
       throw seRs;
     }
   } catch (SQLException se) {
     int count = 1;
     while (se != null) {
       System.out.println("SQLException " + count);
       System.out.println("Code: " + se.getErrorCode());
       System.out.println("SqlState: " + se.getSQLState());
       System.out.println("Error Message: " + se.getMessage());
       se = se.getNextException();
       count++;
     }
   } catch (Exception e) {
     e.printStackTrace();
   }
 }

}

 </source>
   
  
 
  

SQLException: getSQLState()

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main {

 public static void main(String[] args) throws Exception {
   String url = "jdbc:odbc:databaseName";
   String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
   String user = "guest";
   String password = "guest";
   String theStatement = "SELECT lastname, firstname FROM autors";
   try {
     Class.forName(driver);
     Connection connection = DriverManager.getConnection(url, user, password);
     Statement queryAuthors = connection.createStatement();
     ResultSet theResults = queryAuthors.executeQuery(theStatement);
     queryAuthors.close();
   } catch (ClassNotFoundException cnfe) {
     System.err.println(cnfe);
   } catch (SQLException sqle) {
     String sqlMessage = sqle.getMessage();
     String sqlState = sqle.getSQLState();
     int vendorCode = sqle.getErrorCode();
     System.err.println("Exception occurred:");
     System.err.println("Message: " + sqlMessage);
     System.err.println("SQL state: " + sqlState);
     System.err.println("Vendor code: " + vendorCode + "\n----------------");
   }
 }

}

 </source>
   
  
 
  

SQLExeption: getMessage()

   <source lang="java">

/*

* Copyright (c) Ian F. Darwin, http://www.darwinsys.ru/, 1996-2002.
* All rights reserved. Software written by Ian F. Darwin and others.
* $Id: LICENSE,v 1.8 2004/02/09 03:33:38 ian Exp $
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
*    notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
*    notice, this list of conditions and the following disclaimer in the
*    documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS""
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS
* BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
* 
* Java, the Duke mascot, and all variants of Sun"s Java "steaming coffee
* cup" logo are trademarks of Sun Microsystems. Sun"s, and James Gosling"s,
* pioneering role in inventing and promulgating (and standardizing) the Java 
* language and environment is gratefully acknowledged.
* 
* The pioneering role of Dennis Ritchie and Bjarne Stroustrup, of AT&T, for
* inventing predecessor languages C and C++ is also gratefully acknowledged.
*/

import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.SQLWarning; /**

* Test of loading a driver and connecting to a database. The URL assumes you
* have the M$ Example "Companies" database configured as a System DSN (or user
* DSN for your user) in the ODBC control panel.
*/

public class Main {

 public static void main(String[] av) {
   String dbURL = "jdbc:odbc:Companies";
   try {
     // Load the jdbc-odbc bridge driver
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     // Enable logging
     DriverManager.setLogWriter(new PrintWriter((System.err)));
     System.out.println("Getting Connection");
     Connection conn = DriverManager.getConnection(dbURL, "ian", ""); // user,
                                      // passwd
     // If a SQLWarning object is available, print its
     // warning(s). There may be multiple warnings chained.
     SQLWarning warn = conn.getWarnings();
     while (warn != null) {
       System.out.println("SQLState: " + warn.getSQLState());
       System.out.println("Message:  " + warn.getMessage());
       System.out.println("Vendor:   " + warn.getErrorCode());
       System.out.println("");
       warn = warn.getNextWarning();
     }
     // Do something with the connection here...
     conn.close(); // All done with that DB connection
   } catch (ClassNotFoundException e) {
     System.out.println("Can"t load driver " + e);
   } catch (SQLException e) {
     System.out.println("Database access failed " + e);
   }
 }

}

 </source>