Robert, It seems that way. It's just that I tried to find something that does that and just couldn't, so I've decided to write something myself.
I will certainly take a look now at compass framework's solution. Amir On 1/11/06, Robert Engels <[EMAIL PROTECTED]> wrote: > > You are better off using the one that has already been contributed then. > It > uses JDBC and breaks the file into blocks. Much more efficient. Sorry to > say > but your solution/code is inferior to what already exists. > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Amir Kibbar > Sent: Wednesday, January 11, 2006 1:37 PM > To: java-dev@lucene.apache.org; [EMAIL PROTECTED] > Subject: Re: [jira] Created: (LUCENE-487) Database as a lucene index > target > > > Robert, > > My solution is the latter. If it is possible to do it using blob seek, I > will attempt to do it next. > > Amir > > On 1/11/06, Robert Engels <[EMAIL PROTECTED]> wrote: > > > > Since no code has been posted, I'll just ask the question... > > > > Does your implementation use the Blob "seek" functions when reading and > > writing, or does it read/write the blob in its entirety. > > > > If it is the latter, your solution is only acceptable for the smallest > of > > Lucene indexes. If it is the former, it would be interesting to see the > > results using various db & drivers, as many JDBC blob impls do not > support > > this functionality, and read/write the blob completely behind the > scenes. > > > > -----Original Message----- > > From: Amir Kibbar (JIRA) [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, January 11, 2006 12:35 PM > > To: java-dev@lucene.apache.org > > Subject: [jira] Created: (LUCENE-487) Database as a lucene index target > > > > > > Database as a lucene index target > > --------------------------------- > > > > Key: LUCENE-487 > > URL: http://issues.apache.org/jira/browse/LUCENE-487 > > Project: Lucene - Java > > Type: New Feature > > Components: Store > > Versions: 1.9 > > Environment: MySql (version 4.1 an up), Oracle (version 8.1.7 and up) > > Reporter: Amir Kibbar > > Priority: Minor > > > > > > I've written an extension for the Directory object called DBDirectory, > > that allows you to read and write a Lucene index to a database instead > of > a > > file system. > > > > This is done using blobs. Each blob represents a "file". Also, each blob > > has a name which is equivalent to the filename and a prefix, which is > > equivalent to a directory on a file system. This allows you to create > > multiple Lucene indexes in a single database schema. > > > > The solution uses two tables: > > LUCENE_INDEX - which holds the index files as blobs > > LUCENE_LOCK - holds the different locks > > > > Attached is my proposed solution. This solution is still very basic, but > > it does the job. > > The solution supports Oracle and mysql > > > > To use this solution: > > > > 1. Place the files: > > - DBDirectory in src/java/org/apache/lucene/store > > - TestDBIndex in src/test/org/apache/lucene/index > > - objects-mysql.sql in src/db > > - objects-oracle.sql in src/db > > > > 2. Edit the parameters for the database connection in TestDBIndex > > > > 3. Create the database tables using the objects-mysql.sql script > (assuming > > you're using mysql) > > > > 4. Build Lucene > > > > 5. Run TestDBIndex with the database driver in the classpath > > > > I've tested the solution on mysql, but it *should* work on Oracle, I > will > > test that in a few days. > > > > Amir > > > > -- > > This message is automatically generated by JIRA. > > - > > If you think it was sent incorrectly contact one of the administrators: > > http://issues.apache.org/jira/secure/Administrators.jspa > > - > > For more information on JIRA, see: > > http://www.atlassian.com/software/jira > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
