Re: RPGLE Stored Procedures and Thread Safety

Hi,

there is no need for this, the JDBC Environment is not Multithreaded and 
things get worse with this Compile option. The access to procedures is 
synchronized on the modules and it doesn't work safe for exported variables.

Dieter

On Monday 07 July 2003 20:33, you wrote:
> Is your RPG procedure defined with THREAD(*SERIALIZE)??
>
> Here's an excerpt from the ILE RPG reference manual:
>
>     The THREAD(*SERIALIZE) keyword indicates that the ILE RPG module
>     created may run in a multithreaded environment, safely.
>
> Here's a link to the full text:
> http://publib.boulder.ibm.com/iseries/v5r2/ic2924/books/c092508419.htm#HDRH
>THREAD
>
> On Mon, 7 Jul 2003 dfeather@xxxxxxxxxxxxxxx wrote:
> >         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!
>
> _______________________________________________
> 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