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]
