|
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 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.