[OPENJPA-1750] Prepared query with enum parameter fails when query is cached

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.0.0
• Component/s: query
• Assignee: Unassigned
• Reporter: Heikki Turakainen
• Created: 29/Jul/10 09:00
• Updated: 06/Dec/10 21:58

Description

A prepared query with an enum parameter fails when exactly the same query is executed again. In other words, it works once, when the query is not cached yet.

The exception: org.springframework.dao.InvalidDataAccessApiUsageException: The specified parameter of type " ... " is not a valid query parameter.

An example query string is:
select distinct a from MyClass a where a.state in (:STATE)
where the STATE is a list of enums.

There is a temporary workaround to bypass the cache with
query.setHint(QueryHints.HINT_IGNORE_PREPARED_QUERY, queryString);

Issue Links

• relates to: OPENJPA-1903 Some queries only work the first time they are executed