try { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); conn = DriverManager.getConnection( "jdbc:oracle:oci8:@dssw2k01", "scott", "tiger"); } catch (SQLException e) { System.err.println(e.getMessage()); e.printStackTrace(); }
if (conn != null) try { conn.close(); } catch (SQLException ignore) { } super.finalize();
new TestBlobSetNull().process();
int rows = 0; FileInputStream fin = null; ResultSet rslt = null; Statement stmt = null; PreparedStatement pstmt = null; Blob photo = null; long person_id = 0; try { conn.setAutoCommit(false); // get Tim's person_id stmt = conn.createStatement(); rslt = stmt.executeQuery( "select person_id " + "from person " + "where last_name = 'O''Reilly' " + "and first_name = 'Tim'"); while (rslt.next()) { rows++; person_id = rslt.getLong(1); } if (rows > 1) { System.err.println("Too many rows!"); System.exit(1); } else if (rows == 0) { System.err.println("Not found!"); System.exit(1); } rslt.close(); rslt = null; stmt.close(); stmt = null; // set up the update statement pstmt = conn.prepareStatement( "update person_information " + "set photo = empty_blob() " + "where person_id = ?"); pstmt.setLong(1, person_id); rows = pstmt.executeUpdate(); System.out.println(rows + " rows updated"); conn.commit(); pstmt.close(); pstmt = null; } catch (SQLException e) { System.err.println("SQL Error: " + e.getMessage()); } finally { if (rslt != null) try { rslt.close(); } catch (SQLException ignore) { } if (stmt != null) try { stmt.close(); } catch (SQLException ignore) { } if (pstmt != null) try { pstmt.close(); } catch (SQLException ignore) { } }