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