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: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Mikko Koponen (mtkopone)
>Assigned to: Alexey Loubyansky (loubyansky)
>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
----------------------------------------------------------------------
>Comment By: Alexey Loubyansky (loubyansky)
Date: 2002-12-18 09:14
Message:
Logged In: YES
user_id=543482
This is fixed in JBoss-3.0 / 3.2 / 4.0.
sorry, couldn't find your patch to check.
Thanks,
alex
----------------------------------------------------------------------
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
