obtain column names in oracle via jdbc
From: <a7244270_at_my-deja.com>
Date: 2000/08/07
Message-ID: <8mnc45$oto$1_at_nnrp1.deja.com>#1/1
Date: 2000/08/07
Message-ID: <8mnc45$oto$1_at_nnrp1.deja.com>#1/1
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;
Statement stmt = connection.createStatement();
String command = "describe xyz";
connection = pool.get();
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 CEST