Eclipse Community Forums: EclipseLink » JAPA search query on DB

Help

Home

Home » Eclipse Projects » EclipseLink » JAPA search query on DB

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

JAPA search query on DB [message #493652]

Tue, 27 October 2009 13:33

Enrico

Messages: 82
Registered: July 2009

Member

Dear All,

I would like to implement a query that search on a set of table for all
records that have some keyword on their field.
This query must implement the "simple search" function by keywords on a
website (I mean...user insert a keyword in the search box and all the
entities in the Db with a coloumn hat contains that keywords must return).

I would like to know what is the best way to implement the search on a
webisite db (or a subset of tables) or if there is already some
eclipselink facility to get that.

BR,
Enrico

Report message to a moderator

Re: JAPA search query on DB [message #494174 is a reply to message #493652]

Thu, 29 October 2009 13:23

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

Are you trying to query a single class, or multiple classes?

If you are trying to query multiple class, you may need to query them one by one based on your model.

One possibility may be to use EclipseLink's interface descriptor support if all of your class share a common interface. Then you could perform a single conceptual query, and EclipseLink would query each table. JPA does not support interfaces, so you would need to define the interface descriptors using a SessionCustomizer and the EclipseLink descriptor code API.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	Mapping of Collection of Base class objects
Next Topic:	Cache coordination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 20:28:36 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter