Re: jdbc libary list setup?

 > Is there a way to use a different library list for a different
environment (i.e. test, production, etc)?
I think so.

In your application, when toggling between test/production, you may use two
sets of library lists to connect (and disconnect).

Bruce



----- Original Message -----
From: "Eyers, Daniel" <daniel.eyers@honeywell.com>
To: <java400-l@midrange.com>
Sent: Monday, April 15, 2002 12:04 PM
Subject: RE: jdbc libary list setup?


> Is there a way to use a different library list for a different environment
(i.e. test, production, etc)?
>
> dan
>
>
> -----Original Message-----
> From: Bruce Jin [mailto:JIN007M@hotmail.com]
> Sent: Monday, April 15, 2002 4:57 PM
> To: java400-l@midrange.com
> Subject: Re: jdbc libary list setup?
>
>
> You add library list in connection like this
>
>  try {
>       conn = DriverManager.getConnection(
>
"jdbc:as400://box003;naming=SYSTEM;libraries=BRUCELIB:ABCLIB","JIN",
> "PASSWORD");
>  } catch(SQLException sale) {
>    printSQLError("getConnection", sale);
>   }
>
> Then use file name without qualifier when accessing file.
>
> Bruce
>
>
> ----- Original Message -----
> From: "Hatzenbeler, Tim" <thatzenbeler@clinitech.net>
> To: <java400-l@midrange.com>
> Sent: Monday, April 15, 2002 10:25 AM
> Subject: jdbc libary list setup?
>
>
> > 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 hava graphical sql client, that will load the available tables, to let
> the
> > user pick them, but it only show the tables from the default system
> library
> > list, is there any way, on the url connection or somewhere else, that I
> can
> > tell it what library(s) to use?  Similar to the way ODBC work...
> >
> > Thanks, tim
> >
> > _______________________________________________
> > 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.
> _______________________________________________
> 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.
>
>