Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
    Bookmark Topic Watch Topic
  • New Topic

Getting BatchUpdateException while executing multiple Delete queries in Oracle

 
Jay B Shukla
Ranch Hand
Posts: 33
1
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi All,

I have requirement to create a new Java Program to delete old records from Oracle 11g database . This is a new Java stand alone application.
I am facing a problem where I am getting below exception while executing this program after certain delete operations.

Process takes very long time at certain sql queries (not consistent to any specific query) before throwing below exception



Can anyone please help me where do i need to look into to resolve this?

Thanks.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Report post to moderator
You'd probably need to post the relevant code for anyone to be able to help you.

Given very little information available, my guess would be that your batches are too big. How many records are you deleting in one batch?
 
Roel De Nijs
Sheriff
Posts: 10662
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please do not create duplicate threads!

This thread is locked and discussion can be continued in this thread.
 
    Bookmark Topic Watch Topic
  • New Topic