This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes JDBC with Full Text Search? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC with Full Text Search?" Watch "JDBC with Full Text Search?" New topic
Author

JDBC with Full Text Search?

Leonardo Carreira
Ranch Hand

Joined: Apr 07, 2009
Posts: 489

Hi Friends..

i have a question..
i use Swing application + JDBC + MySQL v5.0.81..

is it possible to put Full Text Search for my application?..
if its possible, what is the best tool that i have to use?
How about Sphinx?..
or is there any Full Text Search tool which could be ran with jdbc together?..

Thanks in advance

Sorry, perhaps my english language isn't too good.. Prepare for SCJP 6, Please God help me.. ☼
References : [Java.Boot] [JavaChamp] [JavaPrepare]
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41582
    
  54
That depends on what, exactly, you mean by "full text search". SQL can find any text within varchar fields using the "... like '%searchstring%' ... " syntax.


Ping & DNS - my free Android networking tools app
Leonardo Carreira
Ranch Hand

Joined: Apr 07, 2009
Posts: 489

Thanks @Ulf for your reply..

sincerely, i really doubt.. when is the best way to use Full Text Search?..
if i use Full Text Search like Sphinx, is performance of my query is better than before?..

Thanks..
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41582
    
  54
So you have text search now? How does it work, and why do you want to change it? Just for performance reasons?
Leonardo Carreira
Ranch Hand

Joined: Apr 07, 2009
Posts: 489

i just want to try to know comparison both of them..


Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41582
    
  54
How can we compare two things if we only know one of them?
Leonardo Carreira
Ranch Hand

Joined: Apr 07, 2009
Posts: 489

yeah.. exactly we can't compare both of them..

okay, i will keep using PreparedStatement..
Thanks in advance...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC with Full Text Search?