Check this link out....I am trying to do the same http://marc.theaimsgroup.com/?l=lucene-user&m=100556272928584&w=2
I am using Apache Derby and trying to integrate that with lucene.... Its tough to find a very very simple example for this online. goodluck On 9/29/05, Erik Hatcher <[EMAIL PROTECTED]> wrote: > > > On Sep 29, 2005, at 8:46 AM, Eugeny N Dzhurinsky wrote: > > On Thu, Sep 29, 2005 at 08:39:53AM -0400, George Abraham wrote: > > > >> Eugene, > >> You could grab all the fields for a record in a SQL database, mash > >> it all > >> together and transfer it into one indexing field in Lucene. Use some > >> scripting tools (or even JDBC and Java) to do this. However if you > >> are > >> asking if Lucene can go and look over a SQL database and return > >> results, > >> that would not work. Lucene has to index the database fields > >> first. The > >> indexing would happen with the first two sentences of my post. > >> > > > > Integersting. We have some kind of set of privileges, required to > > access the > > object (let's say rows in table(s)), I thought if it is possible to > > use > > kind of "injection" of access control statement to SQL query for > > extraction > > of only allowed data... But if Lucene needs to index anything, how > > could I > > define the access privileges for data? > > There are many options available. One such technique I described in > "Lucene in Action" ... a SecurityFilter. This simple example scheme > assumes each document has an "owner" and only owners are allowed to > see their documents and no others. By applying a SecurityFilter on a > search, the results are constrained appropriately. This scheme is > intentionally simplistic to show the possibilities. More commonly > would be a situation with users and groups that need to be > dynamically configurable - a Filter could still do this sort of > thing, but how documents are associated with groups would need to be > thoroughly conceived. > > Erik > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >