[OPENJPA-1999] Optional support for non-sequential positional parameters

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.1, 2.2.0
• Component/s: competitive, jpa, query, usability
• Assignee: Richard G. Curtis
• Reporter: David Blevins
• Created: 13/May/11 17:14
• Updated: 02/Feb/12 17:09
• Resolved: 13/Jul/11 16:16

Description

Optional support for less strict following of positional parameters. e.g.

Query query = entityManager.createQuery("SELECT m from Movie as m WHERE m.title = ?2 AND m.year = ?4");
query.setParameter(2, "Foo");
query.setParameter(4, 2011);
return query.getResultList();

Previous OpenJPA releases support this as do current EclipseLink and Hibernate versions. For the migration and upgrade scenarios and the development scenario – can be a pain to have to always update positional parameters while tweaking queries – this could make a compelling optional feature.

Issue Links

• relates to: OPENJPA-1992 java.lang.ArrayIndexOutOfBoundsException if positional parameter are not started from 1
• relates to: OPENJPA-2029 Add PreparedQuery tests for non-sequential positional parameters support