aspose file tools*
The moose likes JDBC and the fly likes Help needed: using setQueryTimeout() on prepared statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Help needed: using setQueryTimeout() on prepared statement" Watch "Help needed: using setQueryTimeout() on prepared statement" New topic
Author

Help needed: using setQueryTimeout() on prepared statement

S Bhanu
Greenhorn

Joined: Feb 28, 2005
Posts: 15
Hi,

I am using setQueryTimeout() on prepared statement while calling a stored procedure using jdbc.
I am unable to see this working.

I did some googling and found out that this method is not yet supported. I would appreciate if anybody has used this and is willing to share the code.

As per jdbc documentation this function should throw SQLException.
Do anybody know what is the error code I should expect in case call times out.

Thanks,
Bhanu
S Bhanu
Greenhorn

Joined: Feb 28, 2005
Posts: 15
hey,

does anybody know what error code is thrown?

Thanks,
Bhanu
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39773
    
  28
Your error code will vary from database to database; there should be a list of error codes in the database documentation.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Help needed: using setQueryTimeout() on prepared statement