× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Thread safe stored procedure
  • From: "Fred Kulack" <kulack@xxxxxxxxxx>
  • Date: Fri, 13 Jul 2001 10:52:01 -0500
  • Importance: Normal


On 07/13/2001 at 10:04:45 AM, owner-java400-l@midrange.com wrote:
The use of connection pools should enable a thread safe use of stored
procedure calls.
I was wondering if there was a way to ensure this safety at the stored
procedure level.
I remember having heard something like that for SQL stored procedure.
Does this exist for RPG LE stored procedures?
--- end of excerpt ---

Most of your thread safety concerns when calling stored procedures
via Java/JDBC are taken care of in a fashion unrelated to connection pools.
1) Each JDBC connection creates a seperate backend agent that
serves as the context for your connection, and it runs your stored
procedure.
The backend agent job is single threaded and since its a seperate
job from your multi-threaded application, you shouldn't have
thread safety concerns here.

2) The Java connection and statement objects are thread safe,
and access to the connection is serialized.

So, regardless of how may threads are calling a stored
procedure using N connections in the application job,
Calls will be serialized by the connection object so
two calls against the same connection will occur
serially.

One thing that seems to be a possible problem that isn't
really thread safety as such....
If your stored procedure retains state between one call
and the next, you could (by sharing a connections between
threads), allow the state for one thread to be used by
another. In many cases, this is ok, in some it is not.

Did you have other thread safety concerns?


"The stuff we call "software" is not like anything that human society
  is used to thinking about. Software is something like a machine, and
  something like mathematics, and something like language, and
  something like thought, and art, and information...
  but software is not in fact any of those other things."
Bruce Sterling - The Hacker Crackdown

Fred A. Kulack  -  AS/400e  Java and Java DB2 access, Jdbc, JTA, etc...
IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
mailto:kulack@us.ibm.com   Personal: mailto:kulack@bresnanlink.net
AOL Instant Messenger: Home:FKulack  Work:FKulackWrk

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.