Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: java-user@lucene.apache.org
Received-SPF: pass (herse.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C7009E.F60ED103"
Subject: injecting fields looked up from DB at the runtime - Solr/Lucene
 question
Date: Sun, 5 Nov 2006 00:55:13 -0500
Message-ID: <373399D6389D8C42B4EAD9BE2B6B5C5F070D152D@tormail01.cihi.ca>
Thread-Topic: injecting fields looked up from DB at the runtime - Solr/Lucene
 question
Thread-Index: AccAnvXannAfypbSQNGrFmzf8kJ9PQ==
From: "Vladimir Olenin" <VOlenin@cihi.ca>
To: <java-user@lucene.apache.org>

------_=_NextPart_001_01C7009E.F60ED103
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi,

I wonder if the below is the correct way of doing things...

- when the Hits objects are returned from IndexSearcher (as a result of =
some search), 'inject' 'info' fields into the 'Hit' objects at runtime =
by looking the values up in the DB. The main purpose is to avoid storing =
'info' fields in the index as 'stored' fields.
  * in other words, I want to keep in Lucene index ONLY 'indexed' fields =
and keep all 'stored' fields (some of which might be big BLOB entries) =
in relational DB. I do want however to provide 'generic' transparent =
access to these stored fields through Lucene APIs (one of the rational =
is to be able to use some frameworks around, like Solr, transparently, =
no matter which fields are stored in index and which are stored in the =
DB).

I wonder if adding 'Fields' to the returned Document object (linked with =
Hit object) will do the trick for me? In other words, will the below =
work?

Hits hits =3D indexSearcher.search(luceneQuery);
HitsIterator iter =3D (HitsIterator)hits.iterator();
Hit hit =3D (Hit)iter.next();
Document doc =3D hit.getDocument();
String docId =3D doc.getField("docId");
doc.addField(getFieldBy("someStoredDBField", docId));

Would this disturb the index in any way? Would this be reflected in all =
other objects in the returned Hits set (eg, will =
'hit.get("someStoredDBField")' return the value looked up in the DB?)

Thanks.

Vlad

------_=_NextPart_001_01C7009E.F60ED103--