File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unable to delete record - JDBC

 
Atonu Bhowmik
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 161
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Atonu Bhowmik
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic