Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
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
Marshal
Posts: 34371
345
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic