hi,

i'm implementing Hibernate Search in my application, i want know Some thing about Class Level Search. I saw the tutorials it gives the property/field name that equal to "someText", is ok. i want to search "someText" in the complete class without mention the filed/property name.




This can be done the key word " like " in the dblevel. Some one help to guide me.

Thanks.

As far as I know this is not currently possible, you should list all field names.
Is this an important feature you need for some good reason?

We could add the feature, but you should persuade Emmanuel (proj lead) about the usefulness of this.

I'm not sure how you could build such a query using SQL, could you show that?
It would be really slow for sure.

Hi s.grinovero thanks for your kind replay,

Here, We're developing a generic component for search with multiple tables. In our case, we want to
search a text in all the tables and returns a list of record that matches the given text. This text may also present
in more than one table. So the returned list should hold the record(of different table) containing text whereever it
matches.

Also, i want to know what is the difference between normal database indexing and lucene + Hibernate Search.

Hi, what dobes is suggesting in this other thread is a good solution for your case I think: http://forum.hibernate.org/viewtopic.php?t=992537&start=0&postdays=0&postorder=asc&highlight=

your second question is much more complex; a very good insight you can read in the book; basically the difference is that Lucene is not a DB, so you can change whatever DB you want (supported by hibernate, this a lot) and it is a very specialized and flexible library.
Also Hibernate and other similar tools don't support "proprietary extensions" to SQL to use full text functions such as the ones you find in MySQL or Oracle DBs, meaning you can't use the fulltext functions from you OO designed software.