Hello Mahesh! I cannot check at the moment but I guess that "EXTRANET_MISC"."ORDERSTARTER_ART"."ART_NR" has a "not null" constraint. (If it does not it should have :-)) I suspect the error is not even related to your code since the code you have shown does not attempt to update the data. But it is possible that a query forces a flush of the entitymanager. Regards Felix View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4046667#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...