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),
u
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