Trying to set query timeout for PreparedStatement object

[Susan Smith]

Hi,

I'm trying to set query timeout for a PreparedStatement object (below is the code snippet).
I set the query timeout to "1" second just for testing first. But I notice the query takes longer than 1 second but it is successfully executed. No SQLException is thrown. I'm confused why this doesn't work. Can someone please advise?

PreparedStatement pstmt = connection.prepareStatement(.....);
pstmt.setQueryTimeout(1);
pstmt.setInt(1, ...);
pstmt.setString(2, ...);
pstmt.setString(3, ...);		
System.out.println("Try to execute prepared statement:" + new java.util.Date());
pstmt.execute();
System.out.println("Done executing prepared statement for historical:" + new java.util.Date());
rs = pstmt.getResultSet();

Thanks in advance for all the help.

[Susan Smith]

Hi,

Sorry to bother you guys again.
Just want to follow up if anyone knows some pointers to my question.

Thanks again in advance for the help.
Let me know if I can provide more information.

[Rich Remington]

I just read that the timing (when the timeout exception is thrown) is not very precise and may take a few seconds to actually materialize. Your query may have completed before then.

Here is a reference URL for your reading pleasure -> http://forums.oracle.com/forums/thread.jspa?threadID=550257

HTH

Susan Smith wrote:Hi,

Sorry to bother you guys again.

...

[Rob Spoor]

No idea why I haven't moved this thread before, but it clearly belongs in our JDBC forum. Finally moving it.

[Balu Sadhasivam]

No idea why I haven't moved this thread before, but it clearly belongs in our JDBC forum. Finally moving it.

yeah certainly would have triggered better responses in JDBC.