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.
Joined: May 10, 2001
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.