What query capabilities does TopLink support?
In addition to EJB QL and SQL, TopLink’s rich expression framework allows almost any query to be specified in terms of the object model. These expressions are then dynamically turned into the appropriate SQL at runtime. When you define a descriptor with the TopLink Workbench, you can use the Queries tab to specify EJB QL and SQL queries and finders to use for database access. The Queries tab contains two additional tabs: Named Queries and Custom SQL. For 2.0 CMP projects, the ejb-jar.xml file stores query lists. You can define the queries in the file and then read them into the TopLink Workbench, or define them on the Queries tab and write them to the file. • Do TopLink queries support EJBQL? A ReadAllQuery and ReadObjectQuery have the method setEJBQLString(String EJBQLString), which you can use to set the selection criteria of the query to a String containing EJB QL. The TopLink Workbench also supports EJB QL queries. • What capabilities do TopLink’s expressions support? TopLink’s ric