Wildfly 23: Cannot mix positional and named parameters errors in JPA queries

Arkady Zelekman

unread,

Mar 17, 2021, 6:48:55 AM3/17/21

to WildFly

We upgraded our Wildfly version from 11 to 23.

We have A LOT of JPA queries in our code which mixes positional and named parameters and it was fine in Wildfly 11.

Example of query:

SELECT o.id FROM com.allot.nms.configuration.device.ejb.DeviceEntity o WHERE o.id <> ?1 AND (o.deviceNet.netAddress in (:netAdrrList) OR o.uiName = ?2) AND o.administrator <> 3:

Now I am getting error about this in Wildfly 23. Do we have a way to get rid off this error without rewriting our code ?

Thanks,

Arkady

Scott Marlow

unread,

Mar 17, 2021, 9:06:01 AM3/17/21

to WildFly

https://github.com/hibernate/hibernate-orm/blob/5.3/migration-guide.adoc#changes-to-positional-query-parameter-handling may help you in the short term.

Arkady Zelekman

unread,

Mar 18, 2021, 2:40:31 AM3/18/21

to WildFly

Thank very much. We decided to fix our queries.

Reply all

Reply to author

Forward