RE: 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 ]
That did it!!  - thank you.

I do have another question,  When I do this, it only pulls the table name,
how would I also pull the library name, so I can qualify my tables?

    ResultSet tables = metadata.getTables(              // Get the tables
info
                                          null,
                                          null,
                                          null,
                                          tableTypes);

      String tableName;                           // Stores a table name
      DefaultMutableTreeNode tableNode;           // Stores a tree node for
a table
      while(tables.next())                              // For each table
      {
        tableName = tables.getString("TABLE_NAME");     // get the table
name
        tableNode = new DefaultMutableTreeNode(tableName);
.....

Thanks again,  tim

> -----Original Message-----
> From: Bruce Jin [SMTP:JIN007M@hotmail.com]
> Sent: Monday, April 15, 2002 1: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.