How can I use XML column in Jasper iReport?

I have one database(MySQL) where data type of one column is XML. Like the table name is 'class_5_student' and two columns is there- 
> std_roll_num [INT]
> std_dtl [XML]
for example 
std_roll_num std_dtl
1 <std_1>
2 <std_2>
3 <std_3>

I know how to connect XML datasource and fetch data from XML file. Is it possible to get data from above table and generate report like -

Name Roll Age
Tom 1 10
Sam 2 11
Lisa 3 10

Every time I connect this DB, I always get XML column as string.

Please help.




soumyadeeplodh's picture
Joined: Jun 16 2015 - 11:20pm
Last seen: 5 years 2 months ago

0 Answers:

No answers yet