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 the following in our
> %TOMCAT_HOME%\solr\conf\data-config.xml:
> <dataConfig>
>
> <dataSource type="JdbcDataSource"
> name="mssqlDatasource"
> driver="net.sourceforge.jtds.jdbc.Driver"
> url="jdbc:jtds:sqlserver://{server.name
> }:{server.port}/{dbInstanceName};instance=SQLEXPRESS"
> convertType="true"
> user="{user.name}"
> password="{user.password}"/>
> <document>
> <entity name="id"
> dataSource="mssqlDatasource"
> query="your query here" />
> </document>
> </dataConfig>
>
> We downloaded a JDBC driver from here http://jtds.sourceforge.net/faq.htmland
> found it to be a quite stable driver.
>
> And the only thing we really had to do was drop that library in
> %TOMCAT_HOME%\lib directory (for Tomcat 6+).
>
> Hope that helps.
> -- Savvas.
>
> On 14 December 2010 22:46, Erick Erickson <erickerick...@gmail.com> wrote:
>
> > 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
> > <solr_home>/example/example-DIH/solr/db/conf/db-data-config.xml?
> >
> > Also, there's a magic URL for debugging DIH at:
> > .../solr/admin/dataimport.jsp
> >
> > If none of that is useful, could you post your attempt and maybe someone
> > can
> > offer some hints?
> >
> > Best
> > Erick
> >
> > On Tue, Dec 14, 2010 at 5:32 PM, Adam Estrada <
> > estrada.adam.gro...@gmail.com
> > > wrote:
> >
> > > 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?
> > >
> > > Thanks,
> > > Adam
> > >
> >
>
