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

[Karl Koster]

I am having fits trying to get a table with an xml typed column in PostgreSQL to update. The Entity is coded as follows:

   
@Entity
@Table(name = "object_table", schema = "risk")
@SequenceGenerator(name = "os.id", sequenceName = "risk.seq_object_table", allocationSize = 1)
@SqlResultSetMappings( {
		@SqlResultSetMapping(name = "os.state.all", entities = { @EntityResult(entityClass = BasicObjectState.class) }),
		@SqlResultSetMapping(name = "os.names.all", columns = { @ColumnResult(name = "name") }) })
@NamedQueries( {
		@NamedQuery(name = "os.state.everything", query = "select os from BasicObjectState as os"),
		@NamedQuery(name = "os.state.byid", query = "select os from BasicObjectState as os where os.id = :id"),
		@NamedQuery(name = "os.state.byname", query = "select os from BasicObjectState as os where os.type.name = :tname and os.name = :sname"),
		@NamedQuery(name = "os.state.bypattern", query = "select os from BasicObjectState as os where os.type.name = :tname and os.name like :sname"),
		@NamedQuery(name = "os.state.bytype", query = "select os from BasicObjectState as os where os.type.name = :tname"),
		@NamedQuery(name = "os.state.remove.bypattern", query = "delete from BasicObjectState as os where os.type.name = :tname and os.name like :sname") })
@NamedNativeQueries( {
		@NamedNativeQuery(name = "os.state.xml-bool", query = "select o.* from risk.object_table o inner join risk.object_type ot on o.object_type = ot.id where ot.name = :type and array_length(xpath(:xpath, o.xml), 1) > 0", resultSetMapping = "os.state.all"),
		@NamedNativeQuery(name = "os.state.xml-like", query = "select o.* from risk.object_table o inner join risk.object_type ot on o.object_type = ot.id where ot.name = :type and cast((xpath(:xpath, o.xml))[1] as varchar) like :xlike", resultSetMapping = "os.state.all"),
		@NamedNativeQuery(name = "os.state.xml-list", query = "select o.* from risk.object_table o inner join risk.object_type ot on o.object_type = ot.id where ot.name = :type and :value = ANY(cast(xpath(:xpath, o.xml) as varchar[]))", resultSetMapping = "os.state.all"),
		@NamedNativeQuery(name = "os.insert.update", query = "call risk.insert_update_object_table(:id, :type, :name, :xml)", hints = { @QueryHint(name = "org.hibernate.callable", value = "true") }) })
public class BasicObjectState implements ObjectState, Serializable {
	private static final long serialVersionUID = 1L;

	private transient int hash;

	private Long id;

	private ObjectTypeState type;

	private String name;

	private String xml;

	private int version;

	public BasicObjectState() {
	}

	protected BasicObjectState(Long id, ObjectTypeState type, String name,
			String xml, int version) {
		this.id = id;
		this.type = type;
		this.name = name;
		this.xml = xml;
		this.version = version;
	}

	@Override
	public int hashCode() {

		if (this.hash == 0) {
			this.hash = getClass().hashCode()
					^ (this.id != null ? this.id.hashCode() : 0) ^ this.version
					^ this.name.hashCode();
		}

		return this.hash;
	}

	@Override
	public boolean equals(Object obj) {

		if (this == obj) {
			return true;
		}

		if (obj == null || !(obj instanceof ObjectState)) {
			return false;
		}

		ObjectState os = (ObjectState) obj;

		if (this.id != null) {
			return this.id.equals(os.getId());
		}

		return this.type.equals(os.getType())
				&& this.version == os.getVersion();
	}

	public int compareTo(ObjectState os) {
		int result = getType().getName().compareTo(os.getType().getName());

		if (result == 0) {
			result = this.name.compareTo(os.getName());
		}

		return result;
	}

	@Override
	public String toString() {
		StringBuilder sb = new StringBuilder();
		sb.append(this.id);
		sb.append('/');
		sb.append(this.type);
		sb.append('/');
		sb.append(this.name);
		sb.append('/');
		sb.append(this.version);
		sb.append('/');
		sb.append(this.xml);
		return sb.toString();
	}

	@Override
	public Object clone() {
		return new BasicObjectState(this.id, this.type, this.name, this.xml,
				this.version);
	}

	@Id
	@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "os.id")
	@Column(name = "id")
	public Long getId() {
		return this.id;
	}

	protected void setId(Long id) {
		this.id = id;
	}

	@ManyToOne(targetEntity = BasicObjectTypeState.class, optional = false)
	@JoinColumn(name = "object_type")
	public ObjectTypeState getType() {
		return this.type;
	}

	public void setType(ObjectTypeState type) {
		this.type = type;
	}

	@Basic
	@Column(name = "name")
	public String getName() {
		return this.name;
	}

	public void setName(String name) {
		this.name = name;
	}

	@Basic
	@Column(name = "xml", columnDefinition = "xml")
	public String getXML() {
		return this.xml;
	}

	public void setXML(String xml) {
		this.xml = xml;
	}

	@Version
	@Column(name = "version")
	public int getVersion() {
		return this.version;
	}

	protected void setVersion(int version) {
		this.version = version;
	}

}

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]

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.