Details
-
Task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
3.0
-
None
Description
One the important features of EJBQL query is that, just like SelectQuery its synatx is DB-independent . Therefore we need a mechanism to customize translation per DbAdapter. The first case that came up where we will need it:
- Null handling. Most databases support null comparison (although the result is often different):
SELECT * FROM ARTIST WHERE ARTIST_NAME = NULL (notice "= NULL" instead of "IS NULL)
FrontBase throws an exception. So one alternative syntax we can use for this query on FrontBase is "SELECT * FROM ARTIST WHERE FALSE"
