Eclipse Community Forums: EclipseLink » Using views in CriteriaQuery

Home » Eclipse Projects » EclipseLink » Using views in CriteriaQuery(CriteriaQuery)

Using views in CriteriaQuery [message #719286]

Fri, 26 August 2011 11:33

Eclipse User

The situation: web form that allows the user to fill out information to be used in a query.

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

[Updated on: Fri, 26 August 2011 11:34] by Moderator

Re: Using views in CriteriaQuery [message #720535 is a reply to message #719286]

Tue, 30 August 2011 15:17

Eclipse User

You can use the CriteriaBuilder.function() API to call a database function.

Critieria only allows querying objects, so there is no way to query a view (or table) unless it is mapped to an object.

(no subject) [message #720544 is a reply to message #719286]

Tue, 30 August 2011 15:17

Eclipse User

You can use the CriteriaBuilder.function() API to call a database function.

Critieria only allows querying objects, so there is no way to query a view (or table) unless it is mapped to an object.

--
James : http://wiki.eclipse.org/EclipseLink : http://en.wikibooks.org/wiki/Java_Persistence : http://java-persistence-performance.blogspot.com/

Previous Topic:	(no subject)
Next Topic:	Different objects in different queries

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 01:40:57 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter