Re: Thread safe stored procedure

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