Association mapping

[Jack Scott]

I've looked through the current topics, but I haven't found an answer. So, here is another question on how to get Hibernate3 association mapping to work. Please let me know if you see why I get the following error: Association references unmapped class: ListValueDTO.

Thanks


I get the following error message in the server.log file:

2006-03-13 21:10:14,526 DEBUG [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/Program Files/jboss-4.0.3SP1/
server/default/deploy/jaw.ear
2006-03-13 21:10:14,526 DEBUG [org.jboss.deployment.scanner.URLDeploymentScanner] Watch URL for: file:/C:/Program Files/
jboss-4.0.3SP1/server/default/deploy/jaw.ear -> file:/C:/Program Files/jboss-4.0.3SP1/server/default/deploy/jaw.ear
2006-03-13 21:10:14,526 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:

--- MBeans waiting for other MBeans ---
ObjectName: jboss.har:service=Hibernate
State: FAILED
Reason: org.hibernate.MappingException: Association references unmapped class: ListValueDTO
I Depend On:
jboss.jca:service=RARDeployer
jboss.jca:service=LocalTxCM,name=JBossAtWorkDS

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.har:service=Hibernate
State: FAILED
Reason: org.hibernate.MappingException: Association references unmapped class: ListValueDTO
I Depend On:
jboss.jca:service=RARDeployer
jboss.jca:service=LocalTxCM,name=JBossAtWorkDS

I have two classes, below, that get data from two tables created with the following statements:

 
                CREATE TABLE COIN (
                COIN_ID BIGINT identity,
                COIN_TYPE VARCHAR(50),
                MINT_YEAR VARCHAR(4),
                MINT VARCHAR(5),
                VARIATION VARCHAR(50),
PRIMARY KEY (COIN_ID),
UNIQUE (COIN_ID));
 
                CREATE TABLE LISTVALUE (
        LISTVALUE_ID BIGINT identity,
        COIN_ID BIGINT,
                LIST_YEAR VARCHAR(4),
                LIST_CONDITION VARCHAR(8),
        LIST_PRICE DOUBLE,
                LIST_SOURCE VARCHAR(30),
PRIMARY KEY (LISTVALUE_ID),
FOREIGN KEY (COIN_ID) REFERENCES COIN(COIN_ID));

Here are the class files:

 
package com.jbossatwork.dto;
 
import java.io.*;
import java.util.*;
 
/**
 * @hibernate.class
 *  table="COIN"
 */
public class CoinDTO implements Serializable
{
    private int coinId;
    private String coinType;
    private String mintYear;
    private String mint;
    private String variation;
    private Set listValues = new HashSet(0);
 
    public CoinDTO()
    {
        this.coinId = -1;
        this.coinType = "";
        this.mintYear = "";
        this.mint = "";
        this.variation = "";
  //this.listValues = null;
    }
 
    public CoinDTO(String coinType, String coinYear, String mint, String variation)
    {
  this.coinId = -1;
        this.coinType = "";
        this.mintYear = "";
        this.mint = "";
        this.variation = "";
  //this.listValues = null;
    }
 
    public CoinDTO(int coinId)
    {
        this.coinId = -1;
        this.coinType = "";
        this.mintYear = "";
        this.mint = "";
        this.variation = "";
        //this.listValues = null;
    }
 
    /**
     * @hibernate.id
     *    generator-class="native"
     *    column="COIN_ID"
     */
    public int getCoinId()
    {
        return coinId;
    }
 
    public void setCoinId(int coinId)
    {
        this.coinId = coinId;
    }
 
    /**
     * @hibernate.property
     *    column="COIN_TYPE"
     */
    public String getCoinType()
    {
        return coinType;
    }
 
    public void setCoinType(String coinType)
    {
        this.coinType = coinType;
    }
 
    /**
     * @hibernate.property
     *    column="MINT_YEAR"
     */
    public String getMintYear()
    {
        return mintYear;
    }
 
    public void setMintYear(String mintYear)
    {
        this.mintYear = mintYear;
    }
 
    /**
     * @hibernate.property
     *    column="MINT"
     */
    public String getMint()
    {
        return mint;
    }
 
    public void setMint(String mint)
    {
        this.mint = mint;
    }
 
    /**
     * @hibernate.property
     *    column="VARIATION"
     */
    public String getVariation()
    {
        return variation;
    }
 
    public void setVariation(String variation)
    {
        this.variation = variation;
    }
 
/**
 * @hibernate.set name="listValues"
 * @hibernate.collection-key column="COIN_ID"
 * @hibernate.collection-one-to-many class="ListValueDTO"
*/

public Set getListValues()
{
return listValues;
}
 
public void setListValues(Set listValues)
{
this.listValues = listValues;
}
}

and the second class:

 
package com.jbossatwork.dto;
 
import java.io.*;
import java.util.*;
 
/**
 * @hibernate.class
 *    table="LISTVALUE"
 */
public class ListValueDTO implements Serializable
{
    private int listValueId;
    private int coinId;
    private String listYear;
    private String listCondition;
    private double listPrice;
    private String listSource;
    private CoinDTO coinDTO;
 
    public ListValueDTO()
    {
        this.listValueId = -1;
        this.coinId = -1;
  this.listYear = "";
  this.listCondition = "";
        this.listPrice = 0.00;
        this.listSource = "";
    }
 
    public ListValueDTO(int coinId)
    {
        this.listValueId = -1;
        this.coinId = -1;
  this.listYear = "";
  this.listCondition = "";
        this.listPrice = 0.00;
        this.listSource = "";
    }
 
    public ListValueDTO(int listValueId, int coinId, double listPrice)
    {
        this.listValueId = -1;
        this.coinId = -1;
  this.listYear = "";
  this.listCondition = "";
        this.listPrice = 0.00;
        this.listSource = "";
    }
 
 
    /**
     * @hibernate.id
     *    generator-class="native"
     *    column="LISTVALUE_ID"
     */
    public int getListValueId()
    {
        return listValueId;
    }
 
    public void setListValueId(int listValueId)
    {
        this.listValueId = listValueId;
    }
 
    /**
     * @hibernate.property
     *    column="COIN_ID"
     */
    public int getCoinId()
    {
        return coinId;
    }
 
    public void setCoinId(int coinId)
    {
        this.coinId = coinId;
    }
 
    /**
     * @hibernate.property
     *    column="LIST_YEAR"
     */
    public String getListYear()
    {
        return listYear;
    }
 
    public void setListYear(String listYear)
    {
        this.listYear = listYear;
    }
 
    /**
     * @hibernate.property
     *    column="LIST_CONDITION"
     */
    public String getListCondition()
    {
        return listCondition;
    }
 
    public void setListCondition(String listCondition)
    {
        this.listCondition = listCondition;
    }
 
    /**
     * @hibernate.property
     *    column="LIST_PRICE"
     */
    public double getListPrice()
    {
        return listPrice;
    }
 
    public void setListPrice(double listPrice)
    {
        this.listPrice = listPrice;
    }
 
    /**
     * @hibernate.property
     *    column="LIST_SOURCE"
     */
    public String getListSource()
    {
        return listSource;
    }
 
    public void setListSource(String listSource)
    {
        this.listSource = listSource;
    }
 
     /**
     * @hibernate.many-to-one class="CoinDTO"
     */
    public CoinDTO getCoinDTO()
    {
        return coinDTO;
    }
 
    public void setCoinDTO(CoinDTO coinDTO)
    {
        this.coinDTO = coinDTO;
    }
}

Finally, here are the two .hbm files:

 
First, CoinDTO.hbm.xml
 
<?xml version="1.0" encoding="UTF-8"?>
 
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
    <class
        name="com.jbossatwork.dto.CoinDTO"
        table="COIN">
 
        <id
            name="coinId"
            column="COIN_ID"
            type="int">
            <generator class="native"/>
        </id>
 
        <property
            name="coinType"
            type="java.lang.String"
            update="true"
            insert="true"
            column="COIN_TYPE"/>
 
        <property
            name="mintYear"
            type="java.lang.String"
            update="true"
            insert="true"
            column="MINT_YEAR"/>
 
        <property
            name="mint"
            type="java.lang.String"
            update="true"
            insert="true"
            column="MINT"/>
 
        <property
            name="variation"
            type="java.lang.String"
            update="true"
            insert="true"
            column="VARIATION"/>
 
        <set
            name="listValues"
            lazy="false"
            cascade="none"
            sort="unsorted">
 
            <key column="COIN_ID"/>
            <one-to-many class="ListValueDTO"/>
        </set>
 
    </class>
 
</hibernate-mapping>

and the second file, ListValueDTO.hbm.xml:

 
<?xml version="1.0" encoding="UTF-8"?>
 
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
    <class
        name="com.jbossatwork.dto.ListValueDTO"
        table="LISTVALUE">
 
        <id
            name="listValueId"
            column="LISTVALUE_ID"
            type="int">
            <generator class="native"></generator>
        </id>
 
        <property
            name="coinId"
            type="int"
            update="true"
            insert="true"
            column="COIN_ID"/>
 
        <property
            name="listYear"
            type="java.lang.String"
            update="true"
            insert="true"
            column="LIST_YEAR"/>
 
        <property
            name="listCondition"
            type="java.lang.String"
            update="true"
            insert="true"
            column="LIST_CONDITION"/>
 
        <property
            name="listPrice"
            type="double"
            update="true"
            insert="true"
            column="LIST_PRICE"/>
 
        <property
            name="listSource"
            type="java.lang.String"
            update="true"
            insert="true"
            column="LIST_SOURCE"/>
 
        <many-to-one
            name="coinDTO"
            class="CoinDTO"
            cascade="none"
            outer-join="auto"
            update="true"
            insert="true"
            column="coinDTO"/>
 
    </class>
 
</hibernate-mapping>

[ March 14, 2006: Message edited by: Jack Scott ]

[Added code tage - Paul Sturrock]
[ March 27, 2006: Message edited by: Paul Sturrock ]

[Mark Spritzler]

Are both mapping files getting generated?

Mark

[Jack Scott]

Mark, Yes both mapping files are in my posting: CoinDTO.hbm.xml and ListValueDTO.hbm.xml. The ListValueDTO.hbm.xml file doesn't appear to be valid for some reason. Could there be a problem with the foreign key setup in the Hypersonic database I'm using? Please see the two table create scripts at the beginning of my submittal.
[ March 15, 2006: Message edited by: Jack Scott ]

[Avinash Rawana]

You are deploying with a HAR correct?

I would unzip the HAR and get the directory structure to make sure everything is in the right place.

-Avinash

[Steve Canny]

You need to use a fully qualified class name in the class attribute of the <many-to-one> and <set> tags. Just add the package prefix and it should work.

[Arun Kumar]

This is bang on target.