Hi There,
I am under a deliverable deadline and I am having problems with my one to many mappings.

I have a parent table order with key orderid and purchaseditems table with foreign key orderid.

Problem: When I try to query the Order table, it fetches the associated purchaseditems once, in the process also updates the orderid in purchaseditems table with 0.
Hence the consecutive queries dont work.
Given below are the mappings please suggest what should I do.
Any help would be highly appreciated.
Thanks

-----------------------------------------------------

Mapping for Order class
-----------------------------------------------------

-------------------------------------------------------------
Class definition of Order
-------------------------------------------------------------


------------------------------------------------------------------------
class definition of Purchaseditems
------------------------------------------------------------------------

---------------------------------------------------------------------
Mapping of PurchasedItems
--------------------------------------------------------------------

Use the Hibernate log and your debugger. There doesn't seem to be anything especially bad about your mappings.

P.S. I can tell that this is not the actual code you are using.

Thanks a lot Gavin for the prompt response.
Why would you say its not the code, I am using?

When I run the code, no exceptions are being thrown.
Why would it update the child table?.
It prints the details of the purchaseditems table. It shows the itemid fine but shows orderid as 0 though the actual value would be like 10 or 15.
I dont know why that is happening.

Following is the code segment for the calling controller.
SessionFactory sessionFac=cfg.buildSessionFactory();
Session sess=sessionFac.openSession();

Transaction tx=null;
tx=sess.beginTransaction();
//Debug.print(strquery);
List list=sess.find("from Order as ord where ord.orderid=15");
if(!list.isEmpty())
{
Iterator iter=list.iterator();
while(iter.hasNext())
{
Order order=(Order)iter.next();
HashSet set=new HashSet(order.getPurchaseditems());
Iterator it=set.iterator();
while(it.hasNext())
{
PurchasedItems puritems=(PurchasedItems)it.next();
System.out.println("itemid"+puritems.getItemid());--->This is fine.
System.out.println("orderid"+puritems.getOrderid());-->Prints 0
}

}
}
tx.commit();
sess.close();
sessionFac.close();

Because its too simple and it doesn't compile.

Especially, where are the instance variable definitions?? Are you sure one of them is not accidently static or something?


I am confident that you will be able to resolve this easily by using your debugger and watching the Hibernate log.

Put a breakpoint in the setter for orderid, for example. (Put the Hibernate src in your sourcepath.)

Thanks a lot Gavin.
I didnt give the entire code just the snapshot of it, just to make things easier for the viewer.

I highly appreciate your help.