*
The moose likes JSF and the fly likes full text with JSF and Mysql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » JSF
Bookmark "full text with JSF and Mysql " Watch "full text with JSF and Mysql " New topic
Author

full text with JSF and Mysql

fabio alonso
Ranch Hand

Joined: May 15, 2010
Posts: 48
Hi Folks,

I need to implement a full text search.

Searching for the GUJ right here, seen as alternatives: hibernate search, lucene, the actual mysql 5.6 (although still in testing, this version supports Norva on InnoDB fulltext)

But there is no conclusion reached. My reality is, JSP, MySQL, JSF

Do you have any suggestions for reading, or something similar article covering this my reality? so I can understand ..

Thankfully
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 15959
    
  19

Lucene is probably the most popular full-text indexing and search system in the Java universe. We use it on the JavaRanch.

Hibernate Search uses the Lucene engine. I've used it with the PostgreSQL database as part of a JPA-architecture webapp.

There's really nothing JSF-specific about any of these search components, though.


Customer surveys are for companies who didn't pay proper attention to begin with.
Brendan Healey
Ranch Hand

Joined: May 12, 2009
Posts: 218
One strategy I've seen mentioned is that you can run InnoDB & MyIsam in some sort of a parallel setup, just
storing the ids & data you need to search on in MyIsam. Very interesting to hear that they've got something
going into 5.6 for InnoDB, it sounds like waiting a bit is going to be easiest. There's also a product called
Sphinx that gets mentioned alongside Lucene for this sort of thing.

Regards,
Brendan.
fabio alonso
Ranch Hand

Joined: May 15, 2010
Posts: 48
Brendan Healey wrote:One strategy I've seen mentioned is that you can run InnoDB & MyIsam in some sort of a parallel setup, just
storing the ids & data you need to search on in MyIsam. Very interesting to hear that they've got something
going into 5.6 for InnoDB, it sounds like waiting a bit is going to be easiest. There's also a product called
Sphinx that gets mentioned alongside Lucene for this sort of thing.

Regards,
Brendan.


So.

In fact, accepts full text mysql 5.6 innodb tables .. but is still in beta testing

Regards,
Juliano
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: full text with JSF and Mysql
 
Similar Threads
Java based search engine for MySQL database
JSF TextArea to highlight the content
JDBC with Full Text Search?
Hibernate with MySQL Full text search
Strange problem with MySQL full text query