Mega Code Archive

 

Categories / Java / Database SQL JDBC

 

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