• 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
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

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: 24314
167
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
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic