I don't think I'll have a good single table example, as I use Lucene as
core part of my project (it's at my "micro-kernel" project
infra-structure - that is multi-database driven).
What I could point you is that I use OJB and/or Hibernate for
persistence, and between my application and OJB/Hibernate I have a layer
for persistence (like a Broker layer) that detects (from some
configuration tables) what objects need to be indexed during
insert/update/delete operations, and uses the indexes for search when
selecting data from database.
Everything needed to be indexed, I must put the primary key of the table
- always - for referencing when loading data from database. So, the
operation isn't transparent, but is almost easy.
BUT, it will require you work with an database abstraction or broker
layer - some extra effort sometimes not applyable to simpler projects (I
really don't mind how complex is your app, neither if this extra cost
could be viable).
Maybe I could create an independent infra-structure for this model of
work, that is applyable to generic projects (with some functions and
triggers doing hard job) but I'll not have time to contribute this
before second quarter of 2006. Sorry.
Edson Richter
Mag Gam escreveu:
Edison:
Yes I have been **trying** to get Lucene to work, and it seems a lot
more programming is needed.
As usual, do you have a good example for a single table?
On 10/15/05, Edson Carlos Ericksson Richter
<[EMAIL PROTECTED]> wrote:
I have being using Apache Lucene for a while. Works like a charm, but
need some extra programming to work.
Richter
Mag Gam escreveu:
Is there any news about full text indexing for Derby? We have been
looking at daffodil db, but we would really like to use apache-derby.
begin:vcard
fn:Edson Carlos Ericksson Richter
n:Richter;Edson
org;quoted-printable:MGR Inform=C3=A1tica Ltda;Desenvolvimento
adr:Cristo Redentor;;Assis Brasil, 3257, Sala 409;Porto Alegre;RS;91010007;Brasil
email;internet:[EMAIL PROTECTED]
title:Diretor de Sistemas
tel;work:(51)3347-0446
tel;cell:(51)9259-2993
x-mozilla-html:FALSE
url:http://www.mgrinformatica.com.br
version:2.1
end:vcard
