Mapping to an xml typed column (PostgreSQL) on an EJB3 entity in JBoss 5.1
posted 6 years ago
I am having fits trying to get a table with an xml typed column in PostgreSQL to update. The Entity is coded as follows:
All of the queries used to select from the relevant table work without a problem. However, when I go to insert/update an entity I get a message stating that the a string (what is coming from the entity) cannot be cast to xml (what is expected on the database. I know this is an issue with the underlying JPA implementation (whatever version of Hibernate is in JBoss 5.1 in this case). However, I am looking for a way, preferably at the JPA declaration level, to convince mapping to cast to the xml type (all that is needed is a CAST(string as xml). I just can't seem to find the magic incantation that does this.