• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

full text with JSF and Mysql

 
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Saloon Keeper
Posts: 27762
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 48
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
reply
    Bookmark Topic Watch Topic
  • New Topic