File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help needed: using setQueryTimeout() on prepared statement

 
S Bhanu
Greenhorn
Posts: 15
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hey,

does anybody know what error code is thrown?

Thanks,
Bhanu
 
Campbell Ritchie
Sheriff
Pie
Posts: 47216
52
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Your error code will vary from database to database; there should be a list of error codes in the database documentation.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic