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