Retrieval of the column name in Java Mapping

[Former Member]

Hi All

I am presently working on JAVA mapping which retrives the data construct the xml I want to dynamically generate the xml tag name (table column names of the Table) is there any way to do it

Thanks

Jayaraman

[bhavesh_kantilal · Accepted solution]

Hi,

Can you give more details? Maybe with an example?

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh

Thanks for the reply

For Ex in java mapping we will be constructing an xml

<<b>empname</b>>raj<<b>/empname</b>>

what we are expecting is to get the column name directly from the databse table.

Thanks

Jayaraman

[Former Member · Accepted solution]

Hi,

You can get column names from database tables as...

ResultSet resultSet=statement.executeQuery("select * from table");

resultSetMetadata=resultSet.getMetaData();

String col1 = resultSetMetadata.getColumnLabel(1); ---> to get first column name

and use in XML node creation as...

Document document = DocumentHelper.createDocument();

Element root = document.addElement("Root");

Element Node1 = document.addElement(col1);

Regards,

Uma

[Former Member]

txs