[OLINGO-1228] JPA Parameterization issue

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: odata2-jpa
• Assignee: Unassigned
• Reporter: Archana Rai
• Created: 01/Feb/18 05:44
• Updated: 02/Aug/19 05:31
• Resolved: 01/Feb/18 06:05

Description

Put request with two parameters failing for JPA

http://localhost:8081/RFQ/Appointments(RequestForQuotationGuid='7f260ade-65e0-471a-b2ce-75e1b745bd54',AppointmentId=3)

 With the below exception:

<innererror>java.lang.IllegalArgumentException:An exception occurred while creating a query in EntityManager:

Exception Description: Error compiling the query [SELECT E1 FROM Appointment E1 WHERE E1.requestForQuotationGuid LIKE ?1 ESCAPE '\' AND E1.appointmentId = ?1], line 1, column 105: invalid multiple use of parameter [1] assuming different parameter types [java.lang.String] and [java.lang.Integer]

Parameter 1 in SQL is also used for the second value.