M Navasca

Hey that worked! I can't believe it was something so trivial.

thanks

Using Hibernate 3

I have a problem validating a mapping file that contains <join> and <set> elements.

Java classes:

public class Agent { private Long id; private lastName; private firstName; private String agentNumber; private Date startDate; private Date endDate; private Set<RetailProperty> retailProperties // getters and setters for each property }

public class RetailProperty { private Long agentId; private String propertyCode; private double propertyValue; // getters and setters for each property }


DB Tables (Postgresql 8.2):

tbl_agents agentid (serial) - pk lastname (varchar 20) firstname (varchar 20) agentnumber (varchar 20) tbl_agenthistories agentid (int) - fk to tbl_agents.agentid startdate (date) enddate(date) tbl_retailproperties agentid (int) - fk to tbl_agents.agentid propertycode (varchar 50) value (numeric)

* tbl_agents and tbl_agenthistories are 1-to-1
* tbl_agents and tbl_retailproperties are 1-to-n
* I have no control over the db schema (ie. I cannot change it)


Agent.hbm.xml:

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name = "Agent" table = "tbl_agents"> <id name = "id" type = "long" column = "agentid"> <generator class = "sequence"> <param name = "sequence">tbl_agent_agentid_seq</param> </generator> </id> <property name = "lastName" type = "string" column = "lastname"/> <property name = "firstName" type = "string" column = "firstname"/> <property name = "agentNumber" type = "string" column = "agentnumber"/> <join table = "tbl_agenthistories" fetch = "join"> <key column = "agentid"/> <property name = "startDate" type = "date" column = "startdate"/> <property name = "endDate" type = "date" column = "enddate"/> </join> <set name = "retailProperties" table = "tbl_retailproperties"> <key column = "agentid"/> <one-to-many class = "RetailProperty"/> </set> </class> </hibernate-mapping>

RetailProperty.hbm.xml:

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name = "RetailProperty" table = "tbl_retailproperties"> <id name = "agentId" type = "long" column = "agentid"> <generator class = "assigned"/> </id> <property name = "propertyCode" type = "string" column = "propertycode"/> <property name = "propertyValue" type = "double" column = "value"/> </class> </hibernate-mapping>

RetailProperty.hbm.xml validates. But when I try to validate Agent.hbm.xml I get this:

Referenced entity at "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd". The content of element type "class" must match "(meta*,subselect?,cache?,synchronize*,comment?,tuplizer*, (id|composite-id),discriminator?,natural-id?,(version|timestamp)?, (property|many-to-one|one-to-one|component|dynamic-component| properties|any|map|set|list|bag|idbag|array|primitive-array)*, ((join*,subclass*)|joined-subclass*|union-subclass*),loader?, sql-insert?,sql-update?,sql-delete?,filter*,resultset*,(query|sql-query)*)".

Which usually means to me that something is wrong with the mapping file. Is there anything in my mapping files that I'm missing?

Note that when I comment out either the <set> or <join> element in Agent.hbm.xml it validates.