Re: How to set up Library list for servlet on AS400?

On 03/13/2001 at 06:02:44 PM, owner-java400-l@midrange.com wrote:
I need my library list set so that when I run stored procedures they pick
up the right library list (with about 22 libraries in, representing a
complicated BPCS environment). Will the technique suggested help with this,
or can you only specify one library with it?
Thanks a lot for all your help.
--- end of excerpt ---
Ah. Well, then you DO NOT want to set the JNI load library list
or the library list within your websphere application server job.

When you run stored procedures, you do it via the JDBC connection
and the stored procedure runs in the backend DB agent job.

Remember, this library list stuff is very AS/400 specific,
so you're getting out of the portable SQL world.

You'll need to do two things.
0) Use SYSTEM naming on your JDBC connections. (Be careful
   if the JDBC connection is pooled, this could effect
   other users of it in a negative way.)
1) set the library list in the backend agent job.

   Easiest way to do this is to call a stored procedure
   that updates the library list (you can call QCMD and
   simply do a CL command as if its a stored procedure).

   Otherwise, update the job description associated with
   the user profile that you use to make the JDBC connection.
   The library list settings should be pulled from that
   for any new backend agent jobs used to service the JDBC
   connections.

Here's a brief description (although I find this sort
of hard to read).
http://www.as400.ibm.com/developer/jdbc/Faqs/JDBCFAQ.html#B7


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