Re: auto trigger the delta import to update index in solr if any update in sql database

2013-02-06 Thread Rohan Thakur
> > --JP > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/auto-trigger-the-delta-import-to-update-index-in-solr-if-any-update-in-sql-database-tp4038525p4038715.html > Sent from the Solr - User mailing list archive at Nabble.com. >

Re: auto trigger the delta import to update index in solr if any update in sql database

2013-02-05 Thread jp
The following link provides on using external activator for tracking DB changes http://ajitananthram.wordpress.com/2012/05/26/auditing-external-activator/ --JP -- View this message in context: http://lucene.472066.n3.nabble.com/auto-trigger-the-delta-import-to-update-index-in-solr-if-any

Re: auto trigger the delta import to update index in solr if any update in sql database

2013-02-05 Thread Rohan Thakur
r in soft commit mode > > --JP > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/auto-trigger-the-delta-import-to-update-index-in-solr-if-any-update-in-sql-database-tp4038525p4038554.html > Sent from the Solr - User mailing list archive at Nabble.com. >

Re: auto trigger the delta import to update index in solr if any update in sql database

2013-02-05 Thread jp
You could use SQL service Broker External Activation service to monitor the changes and post the changes into the Solr Index using update request handler in soft commit mode --JP -- View this message in context: http://lucene.472066.n3.nabble.com/auto-trigger-the-delta-import-to-update-index

Re: auto trigger the delta import to update index in solr if any update in sql database

2013-02-05 Thread Alexandre Rafalovitch
If your field changes that often, you probably do not want to reindex Solr to match. You will loose all caches on every commit. Maybe you are looking at something like ExternalFileField but backed by a database? http://sujitpal.blogspot.ca/2011/05/custom-sorting-in-solr-using-external.html Regard

Re: auto trigger the delta import to update index in solr if any update in sql database

2013-02-05 Thread Rohan Thakur
that is gud but it will not take care of the field that is dynamical changing like and want to do realtime update for that fieldits not possible to set cron to cal DIH every second... On Tue, Feb 5, 2013 at 5:19 PM, Alexandre Rafalovitch wrote: > If you have your deltaQuery setup in DIH, that

Re: auto trigger the delta import to update index in solr if any update in sql database

2013-02-05 Thread Alexandre Rafalovitch
If you have your deltaQuery setup in DIH, that should check for updates. Then you just ping DIH Url periodically to get it to check. Regards, Alex. Personal blog: http://blog.outerthoughts.com/ LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch - Time is the quality of nature that keeps

auto trigger the delta import to update index in solr if any update in sql database

2013-02-05 Thread Rohan Thakur
hi everyone is their any way in which we can auto trigger the delta import to update index in solr if their any update in sql database. thanks regards Rohan