aspose file tools*
The moose likes JDBC 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


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Unable to delete record - JDBC" Watch "Unable to delete record - JDBC" New topic
Author

Unable to delete record - JDBC

Atonu Bhowmik
Greenhorn

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
Greenhorn

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.
regards,
Atonu Bhowmik
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable to delete record - JDBC