Cannot insert into database using JSP
Hi,
I'm having trouble trying to insert data into a database using JSP.
I can execute select queries using my jsp page so I know my connection to database is working. However, when I try to execute insert statement through jsp the program hangs (it doesn't give me any error messages..it just waits forever).
Also, when I manually type the query into database, it works fine.
Could somebody please tell me what's going on?
Thank you.
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@database.grace.umd.edu:1521:dbclass3","userid","pass");
conn.setAutoCommit(true);
// Create a Statement
Statement stmt = conn.createStatement ();
String query ="insert into files (file_id) values (1)";
// 1 query = "update files set extension='jpeg' where extension='txt'";
stmt.executeUpdate(query);
// 2 stmt.executeUpdate("delete from files where file_id=1");
// 3 stmt.executeQuery ("select * from files");
}catch (Exception ex){
throw ex;
}
In the above code, insert, update, delete query do not work but select query works fine.
