lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shawn Heisey <s...@elyograg.org>
Subject Re: Updating Oracle
Date Wed, 16 Jul 2014 20:46:02 GMT
On 7/16/2014 1:45 PM, Jason Bourne wrote:
> I am new to Solr so I just want to know is something is possible.  I might
> need some help coding later on after taking the tutorials.
>
> I am taking over a program that uses html and java script to dislay metadata
> from solr.  They now would like to update one field.  The solr db gets
> refeshed weekly from an oracle db.  So in order to save the changes the
> oracle db needs to be updated.  But to keep the updated field visible to the
> users I would like to update solr with the changes and then update oracle 
> Can solr fire a "data base trigger" on the field updated to update oracle? 
> What is called in solr and can you point me to an example?
>
> The other option is to add/modify the code to update oracle and solr from
> the application but this would be a lot of work.  If this is the only option
> can you point to an example of updating a field in solr?
>
> What are my options?  Thanks.

It would be better to have systems outside of Solr manage this, make the
change in Oracle and Solr at the same time.

If you wanted to manage it from within Solr, you could write a custom
Update Processor that looks at all of the updates that come into Solr,
decides which of them require changes in Oracle, and makes those
changes.  You would then include that custom update processor in Solr. 
Most likely that would be Java code written against the solr-core API
and condensed down into a jar file.  You would then include that jar in
your classpath and reference the class in an update chain configuration.

https://wiki.apache.org/solr/UpdateRequestProcessor

Thanks,
Shawn


Mime
View raw message