Re: Lucene vs SQL database

2005-09-30 Thread Eugeny N Dzhurinsky
On Fri, Sep 30, 2005 at 12:22:53PM -0400, Erik Hatcher wrote: > > That is exactly correct. The source code to the SecurityFilter is > found in the .zip file you can download from http:// > www.lucenebook.com - and it wouldn't hurt our feelings one bit if you > bought the book too :) Nice, I

Re: Lucene vs SQL database

2005-09-30 Thread Erik Hatcher
On Sep 30, 2005, at 5:45 AM, Eugeny N Dzhurinsky wrote: On Thu, Sep 29, 2005 at 08:56:50AM -0400, Erik Hatcher wrote: 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 te

Re: Lucene vs SQL database

2005-09-30 Thread mark harwood
See the code here for an example: http://issues.apache.org/jira/browse/LUCENE-434 This demonstrates: * embedding and running Lucene queries directly in Derby or HSQLDB databases * alternatively, using an RDBMS-provided result set (from potentially any database) to filter an externally run Lucene

Re: Lucene vs SQL database

2005-09-30 Thread Eugeny N Dzhurinsky
On Thu, Sep 29, 2005 at 08:56:50AM -0400, Erik Hatcher wrote: > >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 SecurityFilt

Re: Lucene vs SQL database

2005-09-29 Thread Chris Lu
We have a product, DBSight, just to extract database content and render search results. Many features can be found on the website. Chris Lucene RAD on Any Databases http://www.dbsight.net On 9/29/05, Eugeny N Dzhurinsky <[EMAIL PROTECTED]> wrote: > Is there any way to use

Re: Lucene vs SQL database

2005-09-29 Thread Eugeny N Dzhurinsky
On Thu, Sep 29, 2005 at 09:29:56AM -0400, Mag Gam wrote: > Check this link outI 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 f

Re: Lucene vs SQL database

2005-09-29 Thread Mag Gam
Check this link outI 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 PRO

Re: Lucene vs SQL database

2005-09-29 Thread Erik Hatcher
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

Re: Lucene vs SQL database

2005-09-29 Thread Eugeny N Dzhurinsky
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 > ask

Re: Lucene vs SQL database

2005-09-29 Thread Nader Henein
You can use something like hibernate to load the database tables into java objects and then load them into Lucene Documents, fast and dirty will take you a few hours to code, but if you're going the distance a couple of days should do the trick. Nader Henein George Abraham wrote: Eugene, Yo

Re: Lucene vs SQL database

2005-09-29 Thread George Abraham
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

Lucene vs SQL database

2005-09-29 Thread Eugeny N Dzhurinsky
Is there any way to use the contents of the SQL database as source for Lucene search engine? Is there any example applications or workarounds to do that? -- Eugene N Dzhurinsky - To unsubscribe, e-mail: [EMAIL PROTECTED] For add