Repeated column in mapping for entity:

[Helen Ross]

Hi

Can someone please be able to help me. I have been looking at this for a long time I am not able to see the issue. I am getting "Repeated column in mapping for entity: com.struts2.model.Customer column: CUSTOMER_ID (should be mapped with insert="false" update="false")" but when i add insert="false" and update="false" to my customer.hbm.xml i then get an error message "Unable to instantiate default tuplizer [org.hibernate.tuple.entity.PojoEntityTuplizer]". Everything appears to be set up correctly but I have limited experience using hibernate and struts2. Please let me know if i need to provide more information

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/test</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password">admin</property>
        <property name="hibernate.connection.pool_size">10</property>
        <property name="current_session_context_class">thread</property>
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
 	<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
 	<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
 	<property name="show_sql">false</property>
 	<property name="hbm2ddl.auto">validate</property>
 
        <mapping resource="com/struts2/model/Customer.hbm.xml"/>
 
    </session-factory>
</hibernate-configuration>

Customer.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.struts2.model.Customer" table="customer">
        <id name="customerId" type="long" column="CUSTOMER_ID">
            <generator class="assigned" />
        </id>
        <property name="customerId" column="CUSTOMER_ID" insert="false" update="false"/>
        <property name="username" column="USERNAME" />
        <property name="password" column="PASSWORD" /> 
        <property name="name" column="NAME" /> 
        <property name="county" column="COUNTY" /> 
        <property name="state" column="STATE" /> 
    </class>
</hibernate-mapping>

Customer.java

private Long customerId;
    private String username;
    private String password;
    private String name;
    private String county;
    private String state;

    //getters and setters

[Tim Cooke]

I'm not really an expert on Hibernate. But are you sure you need to define the CUSTOMER_ID column as an id and a property? Perhaps that's what it means when it says "Repeated column in mapping".

Worth a try?

[Helen Ross]

Hi Tim, Thank you for you help but I now encountered another issue and I am not sure if they are related or something completely different when W am trying to execute the code.
When I remove the second reference to Customer_Id i am now getting "Unable to instantiate default tuplizer [org.hibernate.tuple.entity.PojoEntityTuplizer]".

Is there some rule that all the xml files needs to be stored in the same folder? Please let me know if there is more information needed.

Thanks
Shortsmiler

[Tim Cooke]

I think you'd get that error when Hibernate can't find a getter and/or setter for the property name. For example:

<property name="username" column="USERNAME" />
Will be looking for

public void setUsername(String username);
public String getUsername();

Check the syntax of your getters and setters. Also, check the full stack trace of the error as it may tell you which getter/setter it can't find.