Re: Getting Column Names From A Table

[Oystein Grovlen - Sun Norway]

Sisilla wrote:

I have been trying to use the following code to retrieve the column names of
a derby database table called "Client". conn is a legitimate Connection
Object. For some reason, rsColumns.next() never evaluates to true, so the
while loop never executes.

                                                DatabaseMetaData meta =
conn.getMetaData();
                        ResultSet rsColumns = meta.getColumns(null, null, 
"Client", null);
                                                String columns = "Column
Names: ";

Try using all upper case for the table name (i.e., "CLIENT").

--
Øystein