A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Joined: Nov 03, 2004
Jul 23, 2006 21:44:00
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?
I agree. Here's the link:
JDBC to DB2 Mainframe - query timeout
setQuerytimeout in CallableStatement not working. Kindly please help
Why Statemet interface is not Deprecated ?
how to get the next sequence number ..
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015