RE: set timeout on the sql execute

It is also same here. I put this time out call to this sql statement which calls stored procedure on iseries, which is not working at all..



-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Lim Hock-Chai
Sent: 15 April 2010 14:46
To: java400-l@xxxxxxxxxxxx
Subject: Re: set timeout on the sql execute

That is what the developer has tried and it did not work. Now that I got a chance to look at the code, he is actually trying to set time out on a sql stored-procedure call. This particular stored-procedure is written in RPG. I wonder if that is why the setQueryTimeout is not working.



"James Perkins" <jrperkinsjr@xxxxxxxxx> wrote in message news:<mailman.22583.1271285617.2580.java400-l@xxxxxxxxxxxx>...

Lim,
The java.sql.Statement interface has a setQueryTimeout(int seconds)
method. Is that what you're looking for?
--
James R. Perkins



On Wed, Apr 14, 2010 at 14:44, hockchai Lim
<lim.hock-chai@xxxxxxxxxxxxxxx> wrote:

is there a way to set a timeout on the sql execute?


--
This is the Java Programming on and around the iSeries / AS400

(JAVA400-L) mailing list

To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/java400-l.

--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.



Consider the environment and think before you print this email.

Registered Address: Fortis House Tollgate Eastleigh Hampshire SO53 3YA Registered Number: 354568 England
Authorised and regulated by the Financial Services Authority

This e-mail together with any attachments are intended for the addressee only and may be private and confidential. If you are not the intended recipient, or the person responsible for delivering it to the intended recipient, you must not open any attachments, or copy, disclose, distribute, retain or use this e-mail, including any attachments, in any way whatsoever; please return it to us immediately using the reply facility on e-mail.

Consider the environment and think before you print this email.