File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Getting Column index Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Getting Column index" Watch "Getting Column index" New topic

Getting Column index

Seema Hanji
Ranch Hand

Joined: Jan 29, 2001
Posts: 37
Hi All,
Is it possible to get column index from ResultSetMetaData ? I didn't see any methods for that...
Roy Ben Ami
Ranch Hand

Joined: Jan 13, 2002
Posts: 732
what do u mean the coloumn index?
u mean u supply the name and u get the index number??
it usually works the other way around.
u have all the coloumns and u want to know their names.
Seema Hanji
Ranch Hand

Joined: Jan 29, 2001
Posts: 37
In my code, I need to call metadata.getColumnDisplaySize(i);
This method takes column index, at this point I know column name not the index. So can I pass columnname and get column index from metadata ?
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
Not that I am aware of.

So much trouble in the world -- Bob Marley
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at .
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please re-register and select a new name which meets the requirements.
I agree. Here's the link:
subject: Getting Column index
It's not a secret anymore!