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: 'AAAP1EA
mber 23, 2006 7:23 AM
To: java-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));
27;t use Oracle anywhere at the moment.
> 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:5
use Oracle anywhere at the moment.
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
44:58 AM
Subject: Re: 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 Documen
Hi Doug:
I'll create a Jira account today and extract my code from the
lucene-2.0.0 tree.
Then I'll upload to Jira to get more feedback.
May be the first optimization for the TODO list will be replace the
insert/delete/update Data Cartridge entry points for a new code which
put the modificatio
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 potenti
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 c
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: java-us
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, Field.Store.Y
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 upda
11 matches
Mail list logo
