posted 22 years ago
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.