View source for EJB QL

{{Short description|Query language for Enterprise Java Beans}}

'''EJB QL''' or '''EJB-QL''' is a portable [[Database|database]] [[Query language|query language]] for Enterprise Java Beans. It was used in Java EE applications. Compared to [[SQL]], however, it is less complex but less powerful as well.<ref>See the Introduction (p. 4) of »''expert one-on-one: J2EE Design and Development''«, (c) 2002 wrox press.</ref>

==History==
The language has been inspired, especially EJB3-QL, by the native [[Software:Hibernate (framework)#Hibernate Query Language (HQL)|Hibernate Query Language]].<ref>[http://docs.jboss.org/hibernate/stable/entitymanager/reference/en/html/queryhql.html Chapter 7. EJB-QL: The Object Query Language]</ref>

In EJB3 It has been mostly replaced by the [[Java Persistence Query Language]].

==Differences==
EJB QL is a database query language similar to SQL. The used queries are somewhat different from relational SQL, as it uses a so-called "abstract schema" of the enterprise beans instead of the relational model. In other words, EJB QL queries do not use tables and their components, but enterprise beans, their persistent state, and their relationships. The result of an SQL query is a set of rows with a fixed number of columns. The result of an EJB QL query is either a single object, a collection of entity objects of a given type, or a collection of values retrieved from CMP fields. One has to understand the data model of enterprise beans in order to write effective queries.<ref>{{cite web|url=http://java.sun.com/developer/EJTechTips/2003/tt0929.html |archiveurl=https://web.archive.org/web/20080513195535/http://java.sun.com/developer/EJTechTips/2003/tt0929.html |archivedate=2008-05-13|title=ADVANCED EJB QL: SQL vs. EJB QL: Relational and Object Query Languages}}</ref>

==References==
{{Reflist}}

{{DEFAULTSORT:Ejb Ql}}
[[Category:Information science]]
[[Category:Query languages]]

{{Sourceattribution|EJB QL}}