??? What do you say ? You can get null values rows in EJB-QL testing by IS NULL.
For example the EJB-QL query | * @ejb.finder | * view-type="remote" | * signature="java.util.Collection findCustomers(Pharma_EJB.interfaces.Pharma_Customer customer)" | * query="SELECT DISTINCT OBJECT(c) FROM Pharma_User c WHERE c.customer IS NULL OR c.customer=?1" | generates the following SQL | Executing SQL: SELECT DSITINCT t0_c.IND_ID FROM TD_USER t0_c, TD_CUSTOMER t1_c_customer WHERE (t0_c.CLI_ID IS NULL) OR ((t1_c_customer.CLI_ID=?) AND t0_c.CLI_ID=t1_c_customerCLI_ID) | Where is the problem ? The spec says explicitly that the null values do not participate in the relation, so you must test it with IS NULL explicitly (snippet from the spec): anonymous wrote : | Path expression navigability is composed using ?inner join? semantics. That is, if the value of a non-terminal | cmr-field in the path expression is null, the path is considered to have no value, and does not participate | in the determination of the result. | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3836249#3836249 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3836249 ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
