This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
    Bookmark Topic Watch Topic
  • New Topic

Getting BatchUpdateException while executing multiple Delete queries in Oracle  RSS feed

 
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: 11338
177
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
Boost this thread!