Solr has the DataImportHandler framework that allows a straightforward configuration to control indexing from any relational database (with JDBC support). See http://wiki.apache.org/solr/DataImportHandler for details.

If you did go the Java route (though not recommended at this point), using the SolrJ library you won't ever see XML (nor would there even be XML involved if configured for the binary protocol).

        Erik

On Jan 28, 2010, at 2:47 AM, Manish Gulati wrote:

I am planning to use Solr to power search on the site. Our db is mysql and we need to index some tables in the schema into Solr. Based on my initial research it appears that I need to write a java program that will create xml documents (say mydocs.xml) with add command and then use this command to index it in Solr java -jar post.jar mydocs.xml.

Kindly let me know if this is fine or some other sophiscticated solution exist for mysql synching.

--
Manish

Reply via email to