Hi,
I am using Hibernate. I am trying to solve the below problem using Hibernate query.

i have two fields one id, and xml data.
i want to solve the problem using hibernate query.

i have a xml like this

<ISSUES Data_26="" Data_27="-1" Data_28="-1" Data_29="-1" Data_31="-1" Data_32="-1" Data_33="-1" Data_34="29"/> .

This record is stored in database.

My question is
1.how can i retrive each node.
2.display all the record data_26's and its value
eg search xml data: data_27 means

the output is
==================
id xmldata
==================
1 -1
---------------------------------

which is the best java xml parser is suitable and solve this.

Thanks