Bugs item #655279, was opened at 2002-12-17 18:59
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=655279&group_id=22866
Category: JBossCMP
Group: v3.2
Status: Open
Resolution: None
Priority: 5
Submitted By: Mikko Koponen (mtkopone)
Assigned to: Nobody/Anonymous (nobody)
Summary: "IS NULL" problem with EJBQL
Initial Comment:
OS: Linux with JDK 1.4.1
I've encountered a problem with the "IS (NOT) NULL"
expression in ejbql and jbossql when attempting to find
entities using dynamic queries.
Example EJBQL query:
SELECT OBJECT(a)
FROM A a
WHERE
a.b.c IS [NOT] NULL
Problem:
If b is a CMR field and c is a CMP field, the generated
SQL does not include the table name of the b-entity in
the SQL FROM clause, even though it's alias is used in
the SQL WHERE clause. This results in an
SQLException.
I've included a tiny patch the worked fine for me, but
since I have no experience with jjt someone should
probably check that it doesn't break anything major.
mikko koponen
Krocus Communications, Finland
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=655279&group_id=22866
-------------------------------------------------------
This sf.net email is sponsored by:
With Great Power, Comes Great Responsibility
Learn to use your power at OSDN's High Performance Computing Channel
http://hpc.devchannel.org/
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
