[OPENJPA-1738] Prepared SQL query does not handle collection-valued parameter of persistence-capable objects

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0, 2.0.1, 2.1.0
• Fix Version/s: 2.1.0
• Component/s: performance
• Assignee: Catalina Wei
• Reporter: Catalina Wei
• Created: 21/Jul/10 18:52
• Updated: 31/Jan/12 02:24
• Resolved: 24/Jul/10 16:04

Description

Patrick Linskey wrote:
I just ran into what I believe is a bug with the prepared SQL code. In PreparedQueryImpl.reparameterize(), we have the following code:

> if (ImplHelper.isManageable(val))

{ > setPersistenceCapableParameter(result, val, indices, broker); > }

else if (val instanceof Collection)

{ > setCollectionValuedParameter(result, (Collection)val, indices, > key); > }

This does not work if the parameter is a collection of persistence-capable objects, as setCollectionValuedParameter assumes that the values are not PCs.

Issue Links

• relates to: OPENJPA-2118 Prepared SQL query does not handle collection-valued parameter where collection is empty