× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.