• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Unable to delete record - JDBC

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.


------------------
 
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
No matter how many women are assigned to the project, a pregnancy takes nine months. Much longer than this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic