Re: [DIH] Example for SQL Server

I got it to work! This is an excellent article for importing SQL Server data in to your index. http://www.chrisumbel.com/article/lucene_solr_sql_server Adam On Wed, Dec 15, 2010 at 8:43 AM, Adam Estrada wrote: > Thanks All, > > Testing h

Re: [DIH] Example for SQL Server

Thanks All, Testing here shortly and will report back asap. w/r, Adam On Wed, Dec 15, 2010 at 4:10 AM, Savvas-Andreas Moysidis < savvas.andreas.moysi...@googlemail.com> wrote: > Hi Adam, > > we are using DIH to index off an SQL Server database(the freeby SQLExpress > one.. ;) ). We have defined

Re: [DIH] Example for SQL Server

Hi Adam, we are using DIH to index off an SQL Server database(the freeby SQLExpress one.. ;) ). We have defined the following in our %TOMCAT_HOME%\solr\conf\data-config.xml: We downloaded a JDBC driver from here http://jtds.sourceforge.net/faq.html and found it to be a quite stab

Re: [DIH] Example for SQL Server

The config isn't really any different for various sql instances, about the only difference is the driver. Have you seen the example in the distribution somewhere like /example/example-DIH/solr/db/conf/db-data-config.xml? Also, there's a magic URL for debugging DIH at: .../solr/admin/dataimport.jsp

[DIH] Example for SQL Server

Does anyone have an example config.xml file I can take a look at for SQL Server? I need to index a lot of data from a DB and can't seem to figure out the right syntax so any help would be greatly appreciated. What is the correct /jar file to use and where do I put it in order for it to work? Thank