Re: RPGLE Stored Procedures and Thread Safety

[Dieter.Bender@xxxxxxxxxxx (Dieter Bender)]

Hi,

the source of information should be the documentation of the JDBC interfaces. 
AFAIK the driver has to manage the thread safety. But if you synchronize your 
application on the Connection, thread safety should not be a problem anyway.

Dieter

On Monday 07 July 2003 17:33, you wrote:
> Hello,
>         I have written an RPGLE program that utilizes a service program
> for calculating the price of a given item. I have written this program so
> that I can use it as a stored procedure, which I plan on calling from
> several multi-threaded applications. In the past I ran into problems with
> stored procedures that returned result sets, and I eventually found out
> via links provided by several nice people on this list that the cursors
> opened in those stored procedures are not thread safe. So, when I started
> developing this new stored procedure I went looking for information on the
> thread-safety of RPGLE stored procedures, and I have not successfully
> found information leading to a conclusion. I checked the usual resources
> (google, ibm.com, Redbooks, mid-range archives, etc.), and ran some tests
> of my own, but I want to be more certain than I am that RPGLE stored
> procedures are thread safe. So, I was wondering if anyone here knew of a
> source of information on this specific subject that I may have missed, or
> knew off-hand if they were thread safe. Thanks in advance!
>
> Dan Feather
> _______________________________________________
> 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.

-- 
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de