RE: jdbc libary list setup?

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

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 ]
Nevermind... You already answered the question for me, with your previous
post...  The NAMING function fixed it...  Thanks again for all the help..

tim

> -----Original Message-----
> From: Hatzenbeler, Tim [SMTP:thatzenbeler@clinitech.net]
> Sent: Monday, April 15, 2002 11:55 AM
> To:   'java400-l@midrange.com'
> Subject:      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.
> _______________________________________________
> 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.