C M P   2 . 0  

Overriding the EJB QL to SQL Mapping 

The EJB QL to SQL mapping can be overridden in the jbosscmp jdbc.xml file. The finder or 

ejbSelect is still required to have an EJB QL declaration in the ejb jar.xml file, but the ejb ql 

element can be left empty. Currently the SQL can be overridden with JBossQL, which 

removes som of the restricutions of EJB QL and adds support for a ORDER BY clause, 

DynamicQL, which allows for the runtime declaration and execution of EJB QL and 

JBossQL queries, DeclaredSQL, which supports the declaration of the exact SQL for a 

query, or a BMP style custom ejbFind method, which allows the programmer to code the 

query by hand.  All of these overrides are discussed in Chapter 5 of the JBossCMP 

Documentation. 

97