Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: java-user@lucene.apache.org
Received-SPF: pass (asf.osuosl.org: domain of chris.lu@gmail.com designates
 72.14.204.202 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=eVURLnDObP8mHmEqvQVYxCYmNQHWlV4R+71uAozJJfDxh+rZX8LIFyFZ0I4+fMOwYprP54B9Bz+14TtvlRdfunovK30ORPeEZ9MbSJacuIQAvUuPJYOfFAjpYdnNZumRC5svGhBlpRAoIUUPFmdO+u4Ig5FxOcnkKeVMHpbtpuY=
Message-ID: <6e3ae6310510241347u4c44045ev737c62a02fd5adac@mail.gmail.com>
Date: Mon, 24 Oct 2005 13:47:27 -0700
From: Chris Lu <chris.lu@gmail.com>
To: java-user@lucene.apache.org
Subject: Re: lucene and databases
In-Reply-To: <6e3ae6310510241050h5373f77fx81ff125d42cba386@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <435D1A31.4070002@sun.com>
	 <6e3ae6310510241050h5373f77fx81ff125d42cba386@mail.gmail.com>

Also, you can try Compass. I remember it stores the index when you use
hibernate.

Chris Lu
------------------------------
Lucene Full-Text Search on Any Database
http://www.DBSight.net

On 10/24/05, Chris Lu <chris.lu@gmail.com> wrote:
> JDBCDirectory doesn't help you to index content in rdms.
> It just stores the lucene index into rdms. This approach will be
> slower than file system based approach.
>
> For your first question, "Indexing content that is stored in a dbms",
> you can take a look at DBSight. It's a generic tool to easily extract
> content from database and build an index, which seems simple, but
> behind the scene, it does more than that, including, multi-threaded
> extraction and search, multi index support, template-based search
> result, scheduled index updating, web-based control and configuration,
> remote index replication, etc.
>
> Chris Lu
> ------------------------------
> Lucene Full-Text Search on Any Database
> http://www.DBSight.net
>
>
> On 10/24/05, Rick Hillegas <Richard.Hillegas@sun.com> wrote:
> > Thanks to Yonik for replying to my last question about queries and filt=
ers.
> >
> > Now I have another issue. I would appreciate any pointers to attempts t=
o
> > integrate Lucene with databases. There's a tantalizing reference to a
> > class called JDBCDirectory mentioned at
> > http://wiki.apache.org/jakarta-lucene/LatestNews. However, my browser
> > times out trying to access the follow-up link
> > http://ppinew.mnis.com/jdbcdirectory. An email thread
> > (http://www.mail-archive.com/java-user@lucene.apache.org/msg01036.html)
> > makes me hope that this class helps an application index a body of
> > documents stored in a relational database. But this class, perhaps a
> > cousin of FSDirectory and RAMDirectory, doesn't seem to be part of
> > Lucene proper.
> >
> > In any event, I would appreciate pointers to people's experience
> > integrating Lucene with relational databases. I realize this is a very
> > broad question. It sweeps up topics like the following:
> >
> > o Indexing content that is stored in a dbms
> >
> > o Wrapping filters around the results of sql queries
> >
> > o Integrating Lucene query syntax with sql query syntax
> >
> > o Practical tips about when to expose information as a Lucene field vs.
> > when to expose that  information as a column in a relational table
> >
> > Thanks,
> > -Rick
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> > For additional commands, e-mail: java-user-help@lucene.apache.org
> >
> >
>

---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org