Get SqlWarning Statement object : SQL Warning « Database SQL JDBC « Java






Get SqlWarning Statement object

  
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLWarning;
import java.sql.Statement;

public class SqlWarning {
  public static void main(String[] args) {
    try {
      Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

      String jdbcUrl = "jdbc:oracle:thin:@localhost:1521:ORCL";
      Connection conn = DriverManager.getConnection(jdbcUrl, "yourName", "mypwd");

      Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
      SQLWarning sw = null;

      ResultSet rs = stmt.executeQuery("Select * from employees");
      sw = stmt.getWarnings();
      System.out.println(sw.getMessage());

      while (rs.next()) {
        System.out.println("Employee name: " + rs.getString(2));
      }
      rs.previous();
      rs.updateString("name", "Jon");

    } catch (SQLException se) {
      System.out.println("SQLException occurred: " + se.getMessage());

    } catch (Exception e) {
      e.printStackTrace();

    }
  }
}

   
  








Related examples in the same category

1.Get Next SQL Warning()
2.Raising Custom Sql Warning
3.Determining If a SQL Warning Occurred