• Post Reply Bookmark Topic Watch Topic
  • New Topic

Delete records problem-Weblogic timeout

amit taneja
Ranch Hand
Posts: 813
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a delete problem in my java application. In my application at one place it have to delete multiple rows from a table which has 5 child tables.
The format of the DELETE statement is as follows:

The list of list_of_resourceIds size is 200 in number. We are using JDBC to do this. The records in the related child tables are deleting.
But, its taking more time(more than 3 minutes) which is longer than our weblogic time out. So the server is timing out.
Sometimes it’s taking up to 8 minutes also.

also we are have checked that Validation of referential constraints in child table is not causing problem from our DBA TEAM

The interesting thing to note here is the same group delete works very fast(normal behavior) most of the times.
Only sometimes it’s taking more time and hence my weblogic is timing out.

I looked into the code but couldn’t found any problem there. Because most of the times it’s finishing less than a minute.

Please suggest me a solution for this problem
Jeanne Boyarsky
author & internet detective
Posts: 36032
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you able to reproduce when it takes longer? Ideas are:
  • contention on the database
  • a transaction having a lock on the row you want to delete
  • a significantly larger number of child records to delete
    my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
    the new thread boost feature brings a LOT of attention to your favorite threads
    • Post Reply Bookmark Topic Watch Topic
    • New Topic
    Boost this thread!