users@glassfish.java.net

Re: Columns with NULL value and EJB3 queries containing ORDERBY clause.

From: <glassfish_at_javadesktop.org>
Date: Mon, 14 Apr 2008 03:01:54 PDT

Hello,

this is one of the queries I´m using:

createQuery(SELECT a FROM AlarmaH a WHERE a.user = ?1 or a.user = ?2 ORDER BY a.user.name ASC).setParameter(...)

and I think that the problem might be in the definition of the @Column with the "nullable=false" in the entity User, because this entity is used in a Database column in a different entity (called AlarmaH) which contains some NULL values.

Is this correct?
I´m doing something wrong?
May it be a glassfish or TopLink bug?

Thank you very much for your time and help,,

David
[Message sent by forum member 'dvacasp' (dvacasp)]

http://forums.java.net/jive/thread.jspa?messageID=269026