Hi all,

Am getting an exception as shown below, while trying to insert a new row of customer details in a table called CustClientData

PropertyValueException: not-null property references a null or transient value: com.lesconcierges.smartagent.datatransfer.CustClientData.customer

the mapping file i have used is:-

<hibernate-mapping>
<class
name="com.lesconcierges.smartagent.datatransfer.CustClientData"
table="CustClientData"
>

<id
name="customerId"
type="java.lang.Integer"
column="customerID">
<generator class="assigned"/>
</id>

<!-- associations -->
<!-- bi-directional one-to-one association to Customer -->
<one-to-one
name="customer"
class="com.lesconcierges.smartagent.datatransfer.Customer"
outer-join="auto"
constrained="true"
/>

</class>
</hibernate-mapping>

the code which does the insert is :-

Transaction tx1 = session.beginTransaction();
CustClientData custCliData = new CustClientData();
custCliData.setCustomerId(customer.getCustomerId()); // here i used an valid customer id which is present in the customer table
session.save(custCliData);
session.flush();
tx1.commit();

can anyone provide a solution for this..
Expecting a favourable reply
Thanks

when you are saving custCliData, before that set custCliData.setCustomer(CustomerObject). This CustomerObject be selected from the db before you set or else it will create a new CustomerObject row in db.

-Vikash

Hi vikas,

i have also set the customer object in custCliData instead of customerid using a set method called setCustomer(customerOBJ), and also the customer object is a valid one which i fetched from the db.

any other solution you could give please, i have searched many forums reg this...but all have posted some replies based on the mapping xml file, but i could not understand that clearly

Hi vikas,

i have also set the customer object in custCliData instead of customerid using a set method called setCustomer(customerOBJ), and also the customer object is a valid one which i fetched from the db.

any other solution you could give please, i have searched many forums reg this...but all have posted some replies based on the mapping xml file, but i could not understand that clearly

can you check with this mapping ---->


<hibernate-mapping>
<class name="com.lesconcierges.smartagent.datatransfer.CustClientData" table="CustClientData">
<id name="custClientId" type="java.lang.Integer" column="custClientId">
<generator class="increment"/>
</id>

<many-to-one name="customer" column="customerID" cascade="all" class="com.lesconcierges.smartagent.datatransfer.Customer"/>
</class>
</hibernate-mapping>


<hibernate-mapping>
<class name="com.lesconcierges.smartagent.datatransfer.Customer" table="Customer">
<id name="customerID" type="java.lang.Integer" column="customerID">
<generator class="increment"/>
</id>

<many-to-one name="customer" column="customerID" cascade="all" class="com.lesconcierges.smartagent.datatransfer.Customer"/>
</class>
</hibernate-mapping>

Java code

Transaction tx1 = session.beginTransaction();
CustClientData custCliData = new CustClientData();
Customer customer = (Customer)session.createCriteria(Customer.class).add(Expr.eq(customerId, 1/2/3)).uniqueResult();
custCliData.setCustomer(customer); // here set the customer object for custCliData object which is present in the customer table
session.save(customer);
session.save(custCliData);
session.flush();
tx1.commit();

can you check with this mapping ---->


<hibernate-mapping>
<class name="com.lesconcierges.smartagent.datatransfer.CustClientData" table="CustClientData">
<id name="custClientId" type="java.lang.Integer" column="custClientId">
<generator class="increment"/>
</id>
.
.
.

<many-to-one name="customer" column="customerID" cascade="all" class="com.lesconcierges.smartagent.datatransfer.Customer"/>
</class>
</hibernate-mapping>


<hibernate-mapping>
<class name="com.lesconcierges.smartagent.datatransfer.Customer" table="Customer">
<id name="customerID" type="java.lang.Integer" column="customerID">
<generator class="increment"/>
</id>

<property />
.
.
.

</hibernate-mapping>

Java code

Transaction tx1 = session.beginTransaction();
CustClientData custCliData = new CustClientData();
Customer customer = (Customer)session.createCriteria(Customer.class).add(Expr.eq(customerId, 1/2/3)).uniqueResult();
custCliData.setCustomer(customer); // here set the customer object for custCliData object which is present in the customer table
session.save(customer);
session.save(custCliData);
session.flush();
tx1.commit();

Best of luck
Vikash

hi vik,

it should be an one-to-one mapping...but you have mentioned many-to-one, and also did u mentioned any default value for customerID, that value is possible from db

Hi vik,

Finally i solved that issue by just using both set methods that i had setCustomer() and setCustomerID() to insert customer row.

Anyway thanks for your time and effort

Regards,
samy

Hi Sam,

the customerId is auto incremented by hibernate and will be identified as a unique key for customer a primary key.

-Vikash