Hibernate Metadata Search

[Daniel Jabonete]

Greetings!

I would like to kindly ask if we could search the database for a text/string regardless of tables.

Something like searching for a string, then it would return the tables where it found a matched, for a database.

Traversing to all tables, table columns and rows of the database.

Is there something like that?

Thanks very much!

Daniel Suarez Jabonete

[Emmanuel Bernard]

Yes, this is doable in the sense that Lucene is an unstructured index and that Hibernate Search let's you query on all classes or specific classes depending on what you ask for:

  luceneQuery = queryParser.parse("description:hibernate");
org.hibernate.Query query = fullTextSession.createFullTextQuery(luceneQuery);
//returns all entities having a property description containing 'hibernate'
List<?> results = query.list();   
 
org.hibernate.Query query = fullTextSession.createFullTextQuery(luceneQuery, DVD.class, Book.class);
//returns all books and DVDs having a property description containing 'hibernate'
List<?> results = query.list();   
 
org.hibernate.Query query = fullTextSession.createFullTextQuery(luceneQuery, DVD.class);
//returns all DVDs having a property description containing 'hibernate'
@SuppressWarnings("unchecked")
List<DVD> results = query.list();   
 

[Daniel Jabonete]

awesome!

Thanks very much!