Re: retrieve table all table names from a collection using JT400

Leave the variable "types" as null. The types are named something
other than "TABLE" when using the jt400 driver.

-Sarah Poger Gladstone



On 12/14/05, Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx> wrote:
> Ohh
> no i copied it wrong i want all tables, the statement
> i have is
> String types[] = {"TABLE"};
>
> ResultSet rs =
> connection.getMetaData().getTables(null,null,"",
> types);
>
> Ashish
>
> --- Bruce Jin <brucej@xxxxxxxxxxxxxxxxxxxx> wrote:
>
> > ==>
> > connection.getMetaData().getTables(null,null,"A",
> > types);
> >
> > Do you have a  table name "A". Do you want to
> > specify "A*"?
> >
> >
> >
> > Ashish Kulkarni wrote:
> >
> > >Hi
> > >I am trying to retrieve all the table names from a
> > >collection or library,
> > >
> > >Here is what i am doing
> >
> >Class.forName("com.ibm.as400.access.AS400JDBCDriver");
> > >DriverManager.getConnection("
> >
> >jdbc:as400:IP/CXASHTEST;user=user;password=pass;naming=SQL;date
> > >format=iso;time format=hms;prompt=false");
> > >
> > >String types[] = {"TABLE"};
> > >
> > >ResultSet rs =
> > >connection.getMetaData().getTables(null,null,"A",
> > >types);
> >
> >PrintDatabaseMetaDataAndResultset.printMetaDataAndRs(rs,true);
> > >while(rs.next())
> > > {
> > >     list.add(rs.getString("TABLE_NAME"));
> > > }
> > >     rs.close();
> > >
> > >But i am getting list size as '0'
> > >What am i doing wrong
> > >
> > >Ashish
> > >
> > >__________________________________________________
> > >Do You Yahoo!?
> > >Tired of spam?  Yahoo! Mail has the best spam
> > protection around
> > >http://mail.yahoo.com
> > >
> > >
> >
> > --
> > This is the Java Programming on and around the
> > iSeries / AS400 (JAVA400-L) mailing list
> > To post a message email: JAVA400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit:
> > http://lists.midrange.com/mailman/listinfo/java400-l
> > or email: JAVA400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the
> > archives
> > at http://archive.midrange.com/java400-l.
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>