This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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: 38509
    
  23
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