Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsUsing views in CriteriaQuery
https://www.eclipse.org/forums/index.php/mv/msg/236971/719286/#msg_719286
Technologies: EclipseLink, H2, Glassfish
Problem: I have gotten nearly everything to work exactly as I want with the CriteriaQuery. The one problem I have remaining is that I want the user to also be allowed to type in a keyword and use the H2 'FT_SEARCH_DATA()' fulltext search function. I couldn't figure out how to use functions in the where portion of the CriteriaQuery, so I have created a view to do essentially the same thing as that function.
I am still having trouble figuring out how to include that view as a joined table in the CriteriaQuery. Has anyone done anything like this before? Can it be done?
Thanks,
Chris
]]>Chris Oman2011-08-26T15:33:27-00:00Re: Using views in CriteriaQuery
https://www.eclipse.org/forums/index.php/mv/msg/236971/720535/#msg_720535
Critieria only allows querying objects, so there is no way to query a view (or table) unless it is mapped to an object.
]]>James Sutherland2011-08-30T19:17:36-00:00(no subject)
https://www.eclipse.org/forums/index.php/mv/msg/236971/720544/#msg_720544
Critieria only allows querying objects, so there is no way to query a view (or table) unless it is mapped to an object.