RE: Weird Stored Procedure Problem

[Andrew Rodwell <arodwell@xxxxxxxxxxxxxxxxx>]

Title: RE: Weird Stored Procedure Problem

David,

Looking at the databse server I found out it was a commitment control problem.
Uncommited updates from previous runs.

Thanks for the input.

Regards

Andrew Rodwell
Technical Manager
arodwell@kdpsoftware.co.uk

-----Original Message-----
From: Dave Wall [mailto:dawall@us.ibm.com]
Sent: 10 April 2001 20:14
To: JAVA400-L@midrange.com
Subject: Re: Weird Stored Procedure Problem

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
+---