Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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
Hi,
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:
DELETE FROM RESOURCE WHERE RESOURCE_ID IN (list_of_resourceIds).

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
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Amit,
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
  •  
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic