Hi,
I am using mysql 5.x for my development.I wanted to have the attribute list(key-value pair) for one of table column(E.g Table Name: Subscriber Column Name: META_DATA) So i decided to use the varchar(500) as a data type and store the data in xml format(e.g <key>Department</key><value>10</value>).But in the middleware i am using hibernate to access my database.
So will hibernate have the api's to process(insert,update,select) the xml data,will it supports mysql extractValue and updateXML functions?.
Is there any other better way i can achive this using mysql and hibernate?