a strange BUG when using Hql : DataIntegrityViolationExcept

[rockeymen]

Many thanks if who can help to find the reason, it has bothered me for a long time.

I am using hibernate to access mysql.

and using following hql:

select productItem from OrdersProductItem productItem where productItem.orders.id = 11

and an exception popped up:

not-null property references a null or transient value: com.tudou.tudouadsales.plantable.entity.OrdersProd uctItem.orders; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: com.tudou.tudouadsales.plantable.entity.OrdersProd uctItem.orders

the call stack is:

at org.springframework.orm.hibernate3.SessionFactoryU tils.convertHibernateAccessException(SessionFactor yUtils.java:628)
at org.springframework.orm.hibernate3.HibernateAccess or.convertHibernateAccessException(HibernateAccess or.java:412)
at org.springframework.orm.hibernate3.HibernateTempla te.execute(HibernateTemplate.java:378)
at org.springframework.orm.hibernate3.HibernateTempla te.execute(HibernateTemplate.java:338)
at com.tudou.tudouadsales.component.dao.BaseDaoHibern ate.findByQueryUniqueResult(BaseDaoHibernate.java: 347)
at com.tudou.tudouadsales.plantable.dao.impl.OrdersDa oHibernate.getOrdersListByRelatedOrdersId(OrdersDa oHibernate.java:243)
at com.tudou.tudouadsales.plantable.service.impl.Orde rsServiceImpl.CalculateOrders(OrdersServiceImpl.ja va:346)
at com.tudou.tudouadsales.plantable.service.impl.Orde rsServiceImpl.updateOrders(OrdersServiceImpl.java: 467)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)

Here , the define of OrdersProductItem and orders is:

class Orders{
integer id; //not null
...
...
}

in mysql: orders has the column: id

class OrdersProductItem {
@ManyToOne(fetch = FetchType.LAZY)
@Cache(usage = CacheConcurrencyStrategy.READ_WRITE)
@JoinColumn(name="orders_id",nullable=false)
private Orders orders;
}

in mysql: orders_product_item has the column: orders_id

So, what is wrong with the hql code???


thanks a lot!

[DarrylBurke]

Don't double post. Your other thread has been deleted.

db