Home -> Usenet -> comp.databases.oracle -> ??? (Statement)setQueryTimeout(int) ???

??? (Statement)setQueryTimeout(int) ???

From: King <king_at_objectpeople.com>
Date: 2000/06/30
Message-ID: <xv575.2050$cc3.54784_at_news.magma.ca>#1/1 






Hi,



Does anyone use JDBC 2.0 Statement api setQueryTimeout(int)? Does it work?
I tried to set the time limits and expected the program throw SQLException.



I inspect the 'statement' object and it's query_timeout was reset (to 1
second)correctly, and I was pretty sure that the query would take more than
one second ( it read 1000 objects from the database, and I even put
Thread.sleep(1000) before the statement.close() call). I wanted to see/catch
the arisen SQLException, but my program always passed without exception
occurred.



I used VA3.0 for jdk1.2 and Oracle8i Enterprise Edition Release 8.1.6 server
with 8.1.5 driver.



TIA



King
Received on Fri Jun 30 2000 - 00:00:00 CEST












Original text of this message