[JIRA] Created: (CAY-819) Support for per-adapter customization of EJBQL translator

From: Andrus Adamchik (JIRA) ("Andrus)
Date: Sun Jul 01 2007 - 06:59:27 EDT

  • Next message: Andrus Adamchik (JIRA): "[JIRA] Created: (CAY-820) EJBQL resolution: OpenBase limitations"

    Support for per-adapter customization of EJBQL translator
    ---------------------------------------------------------

                     Key: CAY-819
                     URL: https://issues.apache.org/cayenne/browse/CAY-819
                 Project: Cayenne
              Issue Type: Task
              Components: Cayenne Core Library
        Affects Versions: 3.0
                Reporter: Andrus Adamchik
                Assignee: Andrus Adamchik
                 Fix For: 3.0

    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" 

    -- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

    This archive was generated by hypermail 2.0.0 : Sun Jul 01 2007 - 06:59:51 EDT