File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes ResultSetMetaData, Alias Columnnames Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ResultSetMetaData, Alias Columnnames" Watch "ResultSetMetaData, Alias Columnnames" New topic

ResultSetMetaData, Alias Columnnames

Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
hello folks
I have an application which utilizes a query to take data from a database table & write to an XML file and vice-versa. I have a problem in solving the alias name in queries.
e.g Select EmpID as EmployeeID from Employee.. Where EmpID is the original Column name in Table, and when i have the result set metadata, i am not able to get the Original Column name EmpID? is there any other way to get it? or it is b'cos of the JDBC driver?
i have tried using:
rsmd.getColumnLabel(int position) ==> gives EmployeeID rsmd.getColumnName(int position) ==> gives EmployeeID and not EmpID
Kindly help.
Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
When you alias the column, your giving it a new name to the result set.
You can use the metadata to get to the actual column name
ResultSetMetaData rsmd1 = rs.getMetaData();
String colname = rsmd1.getColumnName(i);
The i is the index for the column
Good Luck
Don't get me started about those stupid light bulbs.
subject: ResultSetMetaData, Alias Columnnames
Similar Threads
How to update using Hibernate
Oracle Cursor
Quick question on hierarchical Entity Relationships....
Selecting all columns but one
hibernate 1-many insertion