JDO QL is a simple yet powerful query language

It is declarative and should be intuitive to Java programmers with knowledge of SQL. The query language support:

• multi-criterion filters with parenthesis, and, or, not,
• inheritance is managed,
• navigation through collections and references,
• results can be pure Java objects or projections,
• support for aggregations and related functions (sum, count…),
• XIC is compliant with the upcoming JDOQL 2 standard.

XIC defines several ways to load result sets:

• one by one,
• everything at once,
• using client or database cursor,
• database cursors can span multiple sessions,
• set range and set limit are supported.

XIC also support query filters expressed as direct SQL-92 statements. This allows using statements optimized by a DBA. For the same reason LiDO also supports mapping of the result set coming from a call of a stored procedures. In both cases the result set must contain at least the columns forming the primary key, so that LiDO can later load objects as necessary.

• Instant Mapping
• JDO QL
• Flexible Mapping Options