Re: How to set the library using JDBC in a servlet

[Christian_Glodt@xxxxxx]

Hi,

> We are attempting to write a servlet (our first) that accesses data in an
> AS/400 table using JDBC.  How do we set the library where the table is
> found?

I'd like to add to Shawn's (very interesting) reply that it is also
possible to specify a library to use in the jdbc url.
So you could just try this:

connection = DriverManager.getConnection ("jdbc:db2://myas400/mylib");

It Works For Me(tm), although I'm not sure if you can specify more
than one library this way (by the way, this was also in the comments
included with Shawn's code). Please note that I use the native JDBC
driver, and that the url will most likely be different for the
toolbox JDBC driver.

Regards,

Christian Glodt



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