RE: jdbc libary list setup?

["Eyers, Daniel" <daniel.eyers@xxxxxxxxxxxxx>]

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.