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
Register / Login


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: 32830
    
    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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
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