Re: Oracle and Lucene Integration

2006-11-23 Thread Marcelo Ochoa
. You probably don't want that rowid field tokenized, by the way. Otis - Original Message From: Marcelo Ochoa [EMAIL PROTECTED] To: java-user@lucene.apache.org Sent: Wednesday, November 22, 2006 8:44:58 AM Subject: Re: Oracle and Lucene Integration Hi Mark: Very interesting. So how does

Re: Oracle and Lucene Integration

2006-11-23 Thread Erick Erickson
that rowid field tokenized, by the way. Otis - Original Message From: Marcelo Ochoa [EMAIL PROTECTED] To: java-user@lucene.apache.org Sent: Wednesday, November 22, 2006 8:44:58 AM Subject: Re: Oracle and Lucene Integration Hi Mark: Very interesting. So how does this solution

RE: Oracle and Lucene Integration

2006-11-23 Thread Vladimir Olenin
-user@lucene.apache.org Subject: Re: Oracle and Lucene Integration Otis: I am new to Lucene API and searching technologies :) doc.add(new Field(rowid, rowid, Field.Store.YES, Field.Index.UN_TOKENIZED)); Done!!. Also the Oracle ROWID

Re: Oracle and Lucene Integration

2006-11-23 Thread Marcelo Ochoa
Hi Vladimir: I don't think you can define rowid on 'insert' operations (ie, when a new entry in the table is created) - it's a 'hidden'/automatic field Oracle maintains itself... The rowid is available on the Data Cartridge API, see this output from tests: Insert. newval: 'chau' rowid:

Re: Oracle and Lucene Integration

2006-11-22 Thread mark harwood
Very interesting. So how does this solution manage mapping Oracle primary keys to and from Lucene doc ids? Another benefits of using the Data Cartridge API is that if the table T1 has insert, update or delete rows operations a corresponding Java method will be called to automatically update

Re: Oracle and Lucene Integration

2006-11-22 Thread Marcelo Ochoa
Hi Mark: Very interesting. So how does this solution manage mapping Oracle primary keys to and from Lucene doc ids? I am storing the rowid value as a Document field, here a code sniped Document doc = new Document(); doc.add(new Field(rowid, rowid,

RE: Oracle and Lucene Integration

2006-11-22 Thread Vladimir Olenin
Hi, Marcelo, Yes, putting it in the public space would be great. I personally would be very interested to have a look. Can it be posted on the 'lucene' website? Vlad -Original Message- From: Marcelo Ochoa [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 22, 2006 8:10 AM To:

Re: Oracle and Lucene Integration

2006-11-22 Thread Marcelo Ochoa
Hi Vladimir: Well, I finishing with the implementation of the ancillary operator score() and the contains function ready to use outside the SQL where expression, for example: select score(1),colx,coly from t1 where contains(f2,'test',1)=1 select contains(f2,'test') from t1 Then I'll move the

Re: Oracle and Lucene Integration

2006-11-22 Thread Doug Cutting
Marcelo Ochoa wrote: Then I'll move the code outside the lucene-2.0 code tree to be packed as subdirectory of the contrib area, for example. Other alternative is to make an small zip file and send it to the list as attach as a preliminary (alpha-alpha version ;) This sounds like great

Re: Oracle and Lucene Integration

2006-11-22 Thread Otis Gospodnetic
: Oracle and Lucene Integration Hi Mark: Very interesting. So how does this solution manage mapping Oracle primary keys to and from Lucene doc ids? I am storing the rowid value as a Document field, here a code sniped Document doc = new Document(); doc.add(new