Writing your portable queries, for select and finder methodsEJB-QL for the MovieBeanUsing an optional WHERE clauseNavigating to another related beanSelecting a value rather than the whole beanEJB-QL SELECTEJB-QL SELECT — when to use Object ( )What does it MEAN to return an abstract schema type?SELECT and FROM are mandatory!IdentifiersThe WHERE clauseThe WHERE clauseThe problem with using Collection typesCollections don’t bark()!The IN operator lets you say “For an individual element IN the Collection...”The BETWEEN expressionThe other “IN”The IS EMPTY comparison expressionThe IS NOT EMPTY comparison expressionThe LIKE expressionThe NOT LIKE expressionRelationship assignmentsIf the multiplicity of the relationship field is ONE, it’s a MOVE If the multiplicity is MANY, it’s a COPY