Re: set timeout on the sql execute

So you're probably using a java.sql.CallableStatement then. What
implementation are you using? You might need to read the JavaDocs on
it to see if it gives you any clues.

I'm not sure what it could be. The general JavaDoc for
java.sql.CallableStatement or java.sql.Statement don't specify it does
*not* work on a stored procedure so I assume it should, but I've never
tried.

--
James R. Perkins



On Thu, Apr 15, 2010 at 06:46, Lim Hock-Chai
<Lim.Hock-Chai@xxxxxxxxxxxxxxx> wrote:

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.