This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Murach's Python Programming and have Michael Urban and Joel Murach on-line!
See this thread for details.
Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Mapping to an xml typed column (PostgreSQL) on an EJB3 entity in JBoss 5.1  RSS feed

 
Karl Koster
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Any constructive help would be appreciated.

Thanks
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36396
453
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Karl,
Welcome to JavaRanch!

We have a forum just for ORM and JPA. I'll move this for you. The software helpfully links the original to the moved copy.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!