Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Does setQueryTimeout() work on Oracle Thin Driver (8.1.6)

Re: Does setQueryTimeout() work on Oracle Thin Driver (8.1.6)

From: Pratap Das <reply_das_at_yahoo.com>
Date: 27 Jun 2001 11:13:49 -0700
Message-ID: <9db15e14.0106271013.179cc258@posting.google.com>

dbianchi_at_square.nl wrote in message news:<9hbt5n$dbb3e$8_at_ID-18487.news.dfncis.de>...
> In comp.lang.java.databases Pratap Das <reply_das_at_yahoo.com> wrote:
> > to put some time limit on this query. I intended to use the
> > setQueryTimeout() to do this but apparently it is not working.
>
> AFAIK setQueryTimeout() work only for "direct" query (SELECT), SP are
> executed inside the database and are not affected by this parameter.
>
> Davide

So, is it safe to assume that in case of SP there is *no way* to stop a runaway query from the JDBC side?
Thanks,
--Das Received on Wed Jun 27 2001 - 13:13:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US