Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does setQueryTimeout() work on Oracle Thin Driver (8.1.6)
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