[OPENEJB-1539] IllegalArgumentException when input parameters for select is more than input parameters in EJB QL query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0
• Fix Version/s: 4.0
• Component/s: container system
• Assignee: Unassigned
• Reporter: Hong Fang Han
• Created: 04/May/11 03:28
• Updated: 05/May/11 02:10
• Resolved: 05/May/11 02:10

Description

Following example shows the scenario that input parameters of select (which is three) is more than input paramters in EJB QL query (which is two).

<query>
<description></description>
<query-method>
<method-name>findBooks</method-name>
<method-params>
<method-param>java.lang.String</method-param>
<method-param>java.lang.String</method-param>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>SELECT object(c) from BookBean c WHERE c.title = ?2 AND c.author = ?3</ejb-ql>
</query>

This is a valid scenario according to ejb3.1 spec section 9.2.6.4.

Currently,

Class JpaCmpEngine ... {

private List<Object> executeSelectQuery(Query query, Object[] args)

{ ... query.setParameter(i + 1, arg) // this will throw java.lang.IllegalArgumentException when i+1 = 1 since ?1 does exist in EJB QL }