Hello,

I am trying to make a search inside the database either by using HQL or else Criteria. I already used Criteria, however I do not know how to use it for this kind of search.

What I am trying to do is search some text inside all the fields of all the tables inside my database! Is this even possible?

I will be very greatfull for any sugestions.

thanks and regards,
sim085

Perhaps you need to add Compass framework to your mix
http://www.compassframework.org/display/SITE/Home

Thanks :)

that sounds very intresting :)
I will have a look at it and try to see how to implement it, since it seems to be what I am searching for since at the end what I want to do is search a peace of text in my data modle (all fields inside all tables inside my database).

thanks again.
kcorp.

However the examples I downloaded show I need to create other config files.

Is there any tutorial to say how I can re-use the hibernate .hbm files?

Please remeber that altough I have many tables, I only want to retrieve one object from the database.

example:

I have Student and Classes. If I search for class room "10B" then the return should be A List of Students that have a lesson in classrom "10B" and not an actuall list of Class objects.

regards,
kcorp

I am not Compass expert but I am sure that it is possible. Perhaps you need to do something creative with search results representation.

Or you can use Lucene directly and build your simplified version of ORM search. It is not that hard actually, grab Lucene in Action book, it will help you get familiar with Lucene quickly