This week's book giveaways are in the Refactoring and Agile forums. We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line! See this thread and this one for details.
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. Thanks sathish
posted 15 years ago
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 Dan