Java tutorial
/* Defining the Table: Oracle 9i The following defines a table based on Oracle 9i: create table DataFiles ( id INT PRIMARY KEY, fileName VARCHAR(20), fileBody CLOB ); Defining the Table: MySQL The following defines a table based on MySQL: create table DataFiles ( id INT PRIMARY KEY, fileName VARCHAR(20), fileBody TEXT ); */ import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class DeleteClobFromServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { Connection conn = null; PreparedStatement pstmt = null; String id = "0001"; ServletOutputStream out = response.getOutputStream(); response.setContentType("text/html"); out.println("<html><head><title>Delete CLOB Record</title></head>"); try { conn = getHSQLConnection(); pstmt = conn.prepareStatement("delete from DataFiles where id = ?"); pstmt.setString(1, id); pstmt.executeUpdate(); out.println("<body><h4>deleted CLOB record with id=" + id + "</h4></body></html>"); } catch (Exception e) { out.println("<body><h1>Error=" + e.getMessage() + "</h1></body></html>"); } finally { try { pstmt.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } private static Connection getHSQLConnection() throws Exception { Class.forName("org.hsqldb.jdbcDriver"); System.out.println("Driver Loaded."); String url = "jdbc:hsqldb:data/tutorial"; return DriverManager.getConnection(url, "sa", ""); } public static Connection getMySqlConnection() throws Exception { String driver = "org.gjt.mm.mysql.Driver"; String url = "jdbc:mysql://localhost/demo2s"; String username = "oost"; String password = "oost"; Class.forName(driver); Connection conn = DriverManager.getConnection(url, username, password); return conn; } public static Connection getOracleConnection() throws Exception { String driver = "oracle.jdbc.driver.OracleDriver"; String url = "jdbc:oracle:thin:@localhost:1521:databaseName"; String username = "username"; String password = "password"; Class.forName(driver); // load Oracle driver Connection conn = DriverManager.getConnection(url, username, password); return conn; } }