You are viewing a plain text version of this content. The canonical link for it is here.
Posted to java-user@lucene.apache.org by Steven Pannell <st...@zooplus.com> on 2005/10/26 09:05:11 UTC
Database File Store (SQLDirectory?)
Hi,
I'm looking to try and store my index into an oracle database. Has anyone
done this before? I did find something in the archive referring to the
SQLDirectory.java file by Marc Kramis. But there does not seem to be any
download or further references to this implementation. Does anyone have it?
or are there perhaps any other implementations to get me started?
thx.
Steve.
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
Re: Database File Store (SQLDirectory?)
Posted by Volodymyr Bychkoviak <vb...@i-hypergrid.com>.
Hi.
Try to search for JDBCDirectory...
Steven Pannell wrote:
> Hi,
>
> I'm looking to try and store my index into an oracle database. Has anyone
> done this before? I did find something in the archive referring to the
> SQLDirectory.java file by Marc Kramis. But there does not seem to be any
> download or further references to this implementation. Does anyone have it?
> or are there perhaps any other implementations to get me started?
>
> thx.
> Steve.
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
>
>
--
regards,
Volodymyr Bychkoviak
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
Re: Database File Store (SQLDirectory?)
Posted by Rick Hillegas <Ri...@Sun.COM>.
Hi Tobias,
I would be interested in the SQLDirectory class and DDL scripts if you
could send them.
Thanks,
-Rick
Tobias Lütticke wrote:
> Hi,
>
> > SQLDirectory.java file by Marc Kramis. But there does not seem to be
> any
> > download or further references to this implementation. Does anyone
> have it?
> > or are there perhaps any other implementations to get me started?
>
> It took me a while to find it, but I finally discovered it in an old
> mailing list archive (dit not keep the link, though *sigh*).
> Performance is said not be the best and one user claimed to have found
> a bug, but that's all hear-say.
> I did not yet use the SQLDirectory myself.
>
> Anyway, I got another reference. Maybe you want to check out this
> discussion (where I asked a similar question near the end):
> http://discuss.joelonsoftware.com/default.asp?joel.3.230182.22
>
> Checking the index of the book "Lucene in action" I discovered
> "DBDirectory". However, they seem to store the index in a BerkelyDB -
> no idea yet whether that may be tranferred to Oracle (which is my
> preferred target as well). Did not check "Lucene in action" any
> further either.
>
> Coming back to SQLDirectory.java, if you would like to I can send you
> the class and acompanying DDL scripts. Just let me know.
>
> Cheers
> Tobias
>
> Tobias Lütticke
>
>
> ---------------------------------------------------------------------
> 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
Re: Iterate through all entries
Posted by Yonik Seeley <ys...@gmail.com>.
To loop through all documents, simply go from 0 to maxDoc() and check
isDeleted() on each.
-Yonik
Now hiring -- http://forms.cnet.com/slink?231706
On 10/26/05, Dirk Hennig < dhennig@rrzn.uni-hannover.de> wrote:
>
> Hallo,
>
> I want to iterate through all documents in my index (to add some new
> fields).
> What ist the best / fastest way to do this?
>
> Greetings,
> Dirk Hennig
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
>
<http://forms.cnet.com/slink?231706>
Iterate through all entries
Posted by Dirk Hennig <dh...@rrzn.uni-hannover.de>.
Hallo,
I want to iterate through all documents in my index (to add some new
fields).
What ist the best / fastest way to do this?
Greetings,
Dirk Hennig
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
Re: Database File Store (SQLDirectory?)
Posted by Tobias Lütticke <t....@inovex.de>.
Hi,
> SQLDirectory.java file by Marc Kramis. But there does not seem to be any
> download or further references to this implementation. Does anyone have it?
> or are there perhaps any other implementations to get me started?
It took me a while to find it, but I finally discovered it in an old mailing list archive
(dit not keep the link, though *sigh*).
Performance is said not be the best and one user claimed to have found a bug, but that's
all hear-say.
I did not yet use the SQLDirectory myself.
Anyway, I got another reference. Maybe you want to check out this discussion (where I
asked a similar question near the end):
http://discuss.joelonsoftware.com/default.asp?joel.3.230182.22
Checking the index of the book "Lucene in action" I discovered "DBDirectory". However,
they seem to store the index in a BerkelyDB - no idea yet whether that may be tranferred
to Oracle (which is my preferred target as well). Did not check "Lucene in action" any
further either.
Coming back to SQLDirectory.java, if you would like to I can send you the class and
acompanying DDL scripts. Just let me know.
Cheers
Tobias
Tobias Lütticke
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
Re: Database File Store (SQLDirectory?)
Posted by Rick Hillegas <Ri...@Sun.COM>.
Thanks, Tobias. It turns out that email address is dead. I've googled up
another address for him and have posted him a question about the
licensing of this code. When I get an answer, I'll let the list know.
Cheers,
-Rick
Tobias Lütticke wrote:
> Hi,
>
> as follow-up:
>
> google found the post for me:
> http://mail-archives.apache.org/mod_mbox/lucene-java-user/200112.mbox/%3c002f01c17b49$75b50070$1573a8c0@marc%3e
>
>
> The sources are attached.
>
> As for one question I received: I have no idea what licence the code
> is intended to have. I guess it is kind of free since it was posted on
> the mailing list. But that's nothing you want to depend on..
>
> The post originates in 2001, but maybe it's worth to contact the
> author (Marc Kramis). His mail is included in the post.
>
> Cheers
> Tobias
>
> ---------------------------------------------------------------------
> 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
Re: Database File Store (SQLDirectory?)
Posted by Tobias Lütticke <t....@inovex.de>.
Hi,
as follow-up:
google found the post for me:
http://mail-archives.apache.org/mod_mbox/lucene-java-user/200112.mbox/%3c002f01c17b49$75b50070$1573a8c0@marc%3e
The sources are attached.
As for one question I received: I have no idea what licence the code is intended to have.
I guess it is kind of free since it was posted on the mailing list. But that's nothing you
want to depend on..
The post originates in 2001, but maybe it's worth to contact the author (Marc Kramis). His
mail is included in the post.
Cheers
Tobias
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
RE: Database File Store (SQLDirectory?)
Posted by Simon Middleton <si...@prolog.uk.com>.
This works a bit, but I had to tweak it a bit to get it just right.
Regards,
Simon
http://issues.apache.org/jira/browse/LUCENE-150
Hi,
I'm looking to try and store my index into an oracle database. Has
anyone done this before? I did find something in the archive referring
to the SQLDirectory.java file by Marc Kramis. But there does not seem to
be any download or further references to this implementation. Does
anyone have it? or are there perhaps any other implementations to get me
started?
thx.
Steve.
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org