The cancel() is not working either.
I changed the program to run the callablestatment in a different thread
and interupt it if it is taking too long. Once the thread is
interupted, it then call the callableStatement.cancel(). The cancel()
throw a generic sql error (HY0000). In the finally block, the program
did callableStatment.close() it hangs unless I manully end the job that
is running the RPG stored procedure.
Another, the client has no way out.
"Murali Rao" <Murali.Rao@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:<mailman.22673.1271340390.2580.java400-l@xxxxxxxxxxxx>...
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.
----------
midrange.com
