Francis, I think both of these are on the Solr Wiki. You'll have to figure out how to export from DB yourself, and you'll probably write a script/tool to read the export and rewrite it in the csv format.
Otis -- Sematext -- http://sematext.com/ -- Lucene - Solr - Nutch ----- Original Message ---- > From: Francis Yakin <fya...@liquid.com> > To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org> > Sent: Thursday, July 2, 2009 12:26:14 AM > Subject: RE: Is there any other way to load the index beside using "http" > connection? > > > How you import the documents as csv data/file from Oracle Database to Sol > master( they are two different machines)? > > And you have the doc for using EmbeddedSolrServer? > > Thanks Otis! > > Francis > > -----Original Message----- > From: Otis Gospodnetic [mailto:otis_gospodne...@yahoo.com] > Sent: Wednesday, July 01, 2009 8:01 PM > To: solr-user@lucene.apache.org > Subject: Re: Is there any other way to load the index beside using "http" > connection? > > > Francis, > > There are a number of things you can do to make indexing over HTTP faster. > You can also import documents as csv data/file. > Finally, you can use EmbeddedSolrServer. > > Otis > -- > Sematext -- http://sematext.com/ -- Lucene - Solr - Nutch > > > > ----- Original Message ---- > > From: Francis Yakin > > To: "solr-user@lucene.apache.org" > > Sent: Wednesday, July 1, 2009 6:07:12 PM > > Subject: Is there any other way to load the index beside using "http" > connection? > > > > > > We have several thousands of xml files in database that we load it to solr > > master > > The Database uses "http" connection and transfer those files to solr > > master. > > Solr then translate xml files to their lindex. > > > > We are experiencing issue with close/open connection in the firewall and > > very > > very slow. > > > > Is there any other way to load the data/index from Database to solr master > > beside using http connection, so it means we just scp/ftp the xml file from > > Database system to solr master and let solr convert those to lucene > > indexes? > > > > Any input or help will be much appreciated. > > > > > > Thanks > > > > Francis
