aspose 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


Win a copy of Spring in Action this week in the Spring forum!
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.
 
Consider Paul's rocket mass heater.
 
subject: column names