How can I use XML column in Jasper iReport?

0
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>
<name>Tom</name>
<age>10</age>
<roll>1</roll>
</std_1>
2 <std_2>
<name>Sam</name>
<age>11</age>
<roll>2</roll>
</std_2>
3 <std_3>
<name>Lisa</name>
<age>10</age>
<roll>3</roll>
</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: 3 years 10 months ago

0 Answers:

No answers yet
Feedback