Re: SQL & Library lists

Hi,

you don't need this overkill, have a look to the driver properties, you can
specify the libl with the URL.
If you use the DataSource class you have to configure the LDAP stuff, or you
will run into problems with java standards; I would not recommend to create
any AS400 objects in a java application.

Dieter

Am Montag, 4. Februar 2002 16:35 schrieben Sie:
> 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.
>
> _______________________________________________
> 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.

--
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de