Re: SQL & Library lists

There is an article in the iSeries magazine (Jan 2002) that describes using
JDBC DataSource objects instead of the "normal" JDBC connections using the
DataManager class.  These DataSource objects allow you to set a library list
for the connection.  They are apparently faster than "traditional" JDBC
connections also.  The article starts on page 57 and I'm going to look into
the DataSource objects for JDBC connections.

Mike

----- Original Message -----
From: "Price, Chris" <chris_price@nsb.co.uk>
To: <java400-l@midrange.com>
Sent: Monday, February 04, 2002 10:10 AM
Subject: SQL & Library lists


> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> I've created an SQL stored procedure, which I'm calling from a Java
Servlet
> via the Toolbox.
>
> Originally the SP used a hard coded library (schema) name, and extracted
the
> data fine. However I've now removed the hard coding, as I want the SP to
use
> the library list to pick of the files. Now I get an error:
> "java.sql.SQLException: [SQL0204] MYFILE in QPGMR type *FILE not found."
>
> This is not surprising as we don't have a QPGMR library. I guess it is
using
> the User Name as a default schema name. How can I get it to use the
library
> list?
>
> Chris.
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>