File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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: 32675
    
    4
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://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Help needed: using setQueryTimeout() on prepared statement
 
Similar Threads
Timeout in Stored Procedure
SQL Injection
PreparedStatement's - how do you use them CORRECTLY?
Can't read string with quotes around it in my bean method - Please help?????
Query Timeout