Re: ??? (Statement)setQueryTimeout(int) ???

Thanks Joe,
I also tried Sybase (5.0) Jconnect2 and DB2 (6.1) JDBC Bridge 1.2. Neither works.
Other thoughts?...
King

"Joseph Weinstein" <joe_at_weblogic.com> wrote in message news:395CFDB6.B97E6D61_at_weblogic.com...
> King wrote:
> >
> > 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.
>
> Hi. I believe that Oracle's wire-level client-DBMS protocol is currently
 incapable
> of interupting a query, once sent, so there is no way for their driver to
 implement
> this JDBC function. You should certainly confirm this with Oracle, but
 this is my
> understanding.
>
> Joe Weinstein at BEA
>
> >
> > 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
>
> --
>
> PS: Folks: BEA WebLogic is in S.F., and now has some entry-level positions
 for
> people who want to work with Java and E-Commerce infrastructure products.
 Send
> resumes to joe_at_beasys.com
> --------------------------------------------------------------------------