obtain column names in oracle via jdbc

Hi,

I am trying to find out what the columns in a given table are.

For some reason, the Oracle jdbc driver keeps telling me

> Exception java.sql.SQLException: ORA-00900: invalid SQL statement

which is obviously not true.

Does anyone out there have any clue how can I do this ?

Alfonso.

java.sql.Connection connection = pool.get(); ResultSet rs = null;
connection = pool.get();

Statement stmt = connection.createStatement();

String command = "describe xyz";
rs = stmt.executeQuery( command );
if ( rs.next() )
{

    System.out.println("Col #1: " + rs.getString(1)); }
pool.release(connection);

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 07 2000 - 00:00:00 CDT