I want to delete a record through applet interface using jdbc and oracle8. I am using stored procedure to delete records and which is executing fine in SQL prompt but when the same procedure is attached to java, the java code shows the record is deleted but it is not physically deleted from database. The java code having proper database connection,Callable statement,Connection.Commit(),Connection.setAutocommit(false) method. Please suggest.
When are you committing your transaction? Since autoCommit() is 'false'. I think a commit will NOT happen when you transaction and/or program ends. Please correct me if I am wrong.
------------------ We learn more from our mistake's than from our success's. a.k.a. monty6
Multi Platform Database Developer & DBA on E.S.T.
Joined: Nov 07, 2000
Dear Monty, First of all I will like to thanks for the interest shown on me. But Let me tell u that the autocommit() is set false because the data is commited automatically which i don'nt want, but I have explicitly use commit() method which will make the changes in the database. regards, Atonu Bhowmik