File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes column names Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "column names" Watch "column names" New topic
Author

column names

shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
hi all,
could someone tell me how to get the column names of a particular table using java.sql APIs.
i know we can use ResultSet and ResultSetMetaData.
but i want to get the result in a single database trip.
in ResultSetMetaData there is a mehotd getColumnName(int column).but i have to use it in a loop to retrieve all the column names. so i have to make many database trips which i dont want to.
i hope i have made my problem clear.
thanx in advance.
shanks.
shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
hi all,
i got the answer before anybody could solve my problem.
i am making only a single databse trip i.e. during my sql query.
then all the information is stored in the resultset.
and when i use resultsetmetadata it gets the information from the resultset. i was under the wrong impression that its going to the database and getting the information.
shanks.
 
 
subject: column names
 
Similar Threads
Recordset Get Fields
Need column name in hibernate
How to get Oracle Table Names
Need table column info and metadata
How to view the Datatypes of the Columns of a Table in SQLSERVER