Re: Weird Stored Procedure Problem

["Dave Wall" <dawall@xxxxxxxxxx>]

My first guess is something is still locked when you do the second call.
Set property errors=full on the URL and try it again.  This property will
dump out more error information.

David Wall
AS/400 Toolbox for Java


Andrew Rodwell <arodwell@kdpsoftware.co.uk>@midrange.com on 04/10/2001
11:31:23 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   java400-L@midrange.com
cc:
Subject:  Weird Stored Procedure Problem





Hi y'all,

Running stored procedures, from a servlet under websphere. Runs fine the
first time, times out the second time.

Running the same stored procedure in a java app running on the AS/400, runs
first time, second time just sits there.

Running stored procedure from interactive SQL, runs fine.

Anybody seen this before and can give me a quick answer?

It defiantly seems to be a java problem although I suppose I could try
writing a quick RPG to test it.

Running on V4R4 OS/400 using toolbox driver.

Chin Chin

Andrew




+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---