Eclipse Community Forums: EclipseLink » Missing IN in criteria API SQL

Help

Home

Home » Eclipse Projects » EclipseLink » Missing IN in criteria API SQL(Missing IN in SQL)

Show: Today's Messages :: Show Polls :: Message Navigator

Missing IN in criteria API SQL [message #1854801]

Mon, 12 September 2022 11:29

in clause

Messages: 1
Registered: September 2022

Junior Member

I'm trying to call a PL/SQL DB function that returns table(item_id) from string in criteria API query within ".in" function but getting a SQL which does not contains "IN" clause and it is formed as "equal" sentence.

This is java code:
from.get("itemId").in(cb.function("select item_id from convert_string_to_array", List.class, cb.literal("1,2,3")));

prepared SQL:
SELECT FROM ....(item_id = select item_id from convert_string_to_array(?))
expecting:
SELECT FROM ....item_id IN (select item_id from convert_string_to_array(?))

Report message to a moderator

Previous Topic:	Split module conflict between eclipse and jakarta.jakartaee.api
Next Topic:	@ManagedInterface to eclipselink specific code

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 09 01:44:24 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter