Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Missing IN in criteria API SQL(Missing IN in SQL)
Missing IN in criteria API SQL [message #1854801] Mon, 12 September 2022 11:29
in clause is currently offline in clauseFriend
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(?))
SELECT FROM ....item_id IN (select item_id from convert_string_to_array(?))

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

Current Time: Tue Feb 20 23:32:49 GMT 2024

Powered by FUDForum. Page generated in 0.02250 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top