;>System.out.println(sql);
>>ResultSet rs = conn.createStatement().executeQuery(sql);
>>while (rs.next()) {
>>Document d = new Document();
>>d.add(new Field("id", rs.getString(&qu
d = new Document();
>d.add(new Field("id", rs.getString("id"),
> Field.Store.YES,
> Field.Index.NO));
>d.add(new Field("content", rs.getString("content"),
> Field.Store.YES,
> Field.Index.TOKENIZED));
>
content"),
Field.Store.YES,
Field.Index.TOKENIZED));
writer.addDocument(d);
}
System.out.println("indexing finished ...");
}
best regards
cem
--
View this message in context:
http://www.nabble.co
AIL PROTECTED]
> > Sent: Tuesday, March 04, 2008 1:33 PM
> > To: java-user@lucene.apache.org
> > Subject: Why indexing database is necessary? (RE: indexing database)
> >
> > Could anyone provide any insight on why someone would use nutch/lucene
> > or any other
y the links, not the actual content.
> > So a search engine works only in the index space, whereas a database
> > query engine would have to work in both index and content space...
> >
> >
> > ND
> >
> >
> >
> > -----Original Message-
> > From: W
: java-user@lucene.apache.org
> Subject: RE: Why indexing database is necessary? (RE: indexing database)
>
> Don't forget the number 1 reason: speed. For certain types of queries a
> search engine can return results orders of magnitude faster than a
> database.
> I&#
#x27; which are
probably the ones you would want anyways.
- will
-Original Message-
From: Duan, Nick [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 2:29 PM
To: java-user@lucene.apache.org
Subject: RE: Why indexing database is necessary? (RE: indexing database)
Hmm, I guess t
ginal Message-
From: Will Johnson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 2:18 PM
To: java-user@lucene.apache.org
Subject: RE: Why indexing database is necessary? (RE: indexing database)
Don't forget the number 1 reason: speed. For certain types of queries a
search engine
t to say that a
search engine is always better, just the it often times is for when the
inputs and outputs are carefully defined.
- will
-Original Message-
From: Darren Hartford [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 1:52 PM
To: java-user@lucene.apache.org
Subject: RE: Why in
k [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 04, 2008 1:33 PM
> To: java-user@lucene.apache.org
> Subject: Why indexing database is necessary? (RE: indexing database)
>
> Could anyone provide any insight on why someone would use nutch/lucene
> or any other search engines to in
e database content using search
engines, what would be the best approach other than de-normalizing the
database?
Thanks a lot in advance!
ND
-Original Message-
From: payo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 12:36 PM
To: [EMAIL PROTECTED]
Subject: indexing database
hi to
You'll get no hits since there is no document in the index that has both
fields.
On 2/26/07, Mohammad Norouzi <[EMAIL PROTECTED]> wrote:
Thank you very much Erick.
Really I didnt know about this. I've just thought we can not add two
different documents.
now my question is, if I index the data i
Thank you very much Erick.
Really I didnt know about this. I've just thought we can not add two
different documents.
now my question is, if I index the data in the way you said and now I have a
query say, "(table1_name:john) AND (table2_address:Adam street)"
using MultiFieldQueryParser, what is th
No, that's not what I was talking about. Remember that there's no
requirement in Lucene that each document have the same fields. So, you have
something like...
Document doc = new Document()
doc.add("table1_id", id);
doc.add("table1_name", name);
IndexWriter.add(doc);
Document doc = new Document
Hi Erick
thank you and sorry for taking long my reply. I am involving in a project.
I was thinking of your idea about storing all tables in the same field. it
seems to me a good idea, but some vague issues.
first, how to create a lucene's document. did you mean, storing all tables
by joining all
OK, I was off on a tangent. We've had several discussions where people were
effectively trying to replace a RDBMS with Lucene and finding out it that
RDBMSs are very good at what they do ...
But in general, I'd probably approach it by doing the RDBMS work first and
indexing the result. I think th
Thanks Erick
but we have to because we need to execute very big queries that create
traffik network and are very very slow. but with lucene we do it in some
milliseconds. and now we indexed our needed information by joining tables.
it works fine, besides, it returns the exact result as we can get
don't do either one Search this mail archive for discussions of
databases, there are several long threads discussing this along with various
options on how to make this work. See particularly a mail entitled
*Oracle/Lucene
integration -status- *and any discussions participated in by Marcelo O
Hello
In our application we have to index the database tables, there is two way to
make this
1- index each table in a separate directory and then keep all relation in
order to get right result. in this method, we should use filters to overcome
the problem of searching on another search result.
2.
On Sonntag 18 Dezember 2005 08:16, [EMAIL PROTECTED] wrote:
> hi..
> I would like to know how to index database tables using Lucene.
As this question comes up regularly, I have added a new FAQ item:
http://wiki.apache.org/jakarta-lucene/LuceneFAQ#head-109358021acbfc89456e446740dc2bbf9049950f
Reg
hi..
I would like to know how to index database tables using Lucene.
I am novice in using Lucene and appreciate generous help and thorough
guidelines as how and where to start in order to make Lucen index database
tables and perform searching.
Regards
Shreeya
hi..
I would like to know how to index database tables using Lucene.
I am novice in using Lucene and appreciate generous help and thorough
guidelines as how and where to start in order to make Lucen index database
tables and perform searching.
Regards
Shreeya
22 matches
Mail list logo
