File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Unable to delete record - JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Unable to delete record - JDBC" Watch "Unable to delete record - JDBC" New topic

Unable to delete record - JDBC

Atonu Bhowmik

Joined: Nov 07, 2000
Posts: 9
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.

Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
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.
Atonu Bhowmik

Joined: Nov 07, 2000
Posts: 9
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.
Atonu Bhowmik
I agree. Here's the link:
subject: Unable to delete record - JDBC
It's not a secret anymore!