Hi Rodrigo, the data will only show in SOLR if the index is built after the data has been committed to the database it reads the data from. If the data does not show up in the index there could be several reasons why that is:
a) different database b) permissions prevent that the data is visible (I think this unlikly as it does not seem from your description that it is restricted to certain tables/columns that are not seen at all) c) the data inserts and updates have not been committed when the data is being requested by SolrJ d) SolrJ requests the data before the new data has been inserted/updated and committed (well c) and d) are quite similar but in essence could be different) It might be difficult to start SolrJ with a cron job if the database is updated at irregular times. Better might be to trigger the indexer (the SolrJ job that updates the SOLR index) either: - from the database: you would have to check how the indexer is started and this script you would have to call from the database via trigger or callback or similar. Depends obviously on the possibilities your db offers and might also be not the best if there are several db instances and no defined master. - via polling: an often running cron that checks whether new data has been imported, and if so starts the indexer. Hope this was of some help. If not you might have to provide more details on how the indexer is started, at the moment. Cheers, Chantal Am 31.07.2012 um 04:18 schrieb Rodrigo P. Bregalanti: > Hello, > > I am working on a Data warehouse project, which is making huge modifications > at the database level directly. It is working fine, and everything is going > on, but there is a third party application reading data from one of this > databases. This application is using Solrj (with embedded server) and it is > resulting in a big issue: the new data inserted directly into the database > is not being showed by this application. > > I have researched a lot around that, but didn't find any way to make this > new data available to this particular third party application. > > Is that something possible to do? Have someone faced this kind of issue > before? > > Please let me know if I should put some additional detail. > > Thanks in advance. > > Best regards. > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Rebuild-index-after-database-change-tp3998257.html > Sent from the Solr - User mailing list archive at Nabble.com.
