Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Timeout  RSS feed

 
Tmmet Johnson
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I used java.sql.Statement's setQueryTimeout() in Oracle,DB2 and Sybase.

The setQueryTimeout() works fine only for stored procedures.But, for executeUpdate(),executeBatch() and executeQuery() works sometimes.But,does not timeout other times.


Could anyone please let me know

1. Why it works for stored procedures?
2. Why setQueryTimeOut() does not work as expected for executeUpdate,executeBatch() and executeQuery() ALWAYS?

Thanks,
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!