You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Adam Estrada <es...@gmail.com> on 2010/12/14 23:32:52 UTC
[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?
Thanks,
Adam
Re: [DIH] Example for SQL Server
Posted by Adam Estrada <es...@gmail.com>.
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
<http://www.chrisumbel.com/article/lucene_solr_sql_server>Adam
On Wed, Dec 15, 2010 at 8:43 AM, Adam Estrada <es...@gmail.com>wrote:
> 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.moysidis@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.html and
>> 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 <er...@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.groups@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
>> > >
>> >
>>
>
>
Re: [DIH] Example for SQL Server
Posted by Adam Estrada <es...@gmail.com>.
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.moysidis@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 <er...@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.groups@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
> > >
> >
>
Re: [DIH] Example for SQL Server
Posted by Savvas-Andreas Moysidis <sa...@googlemail.com>.
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.html and
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 <er...@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.groups@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
> >
>
Re: [DIH] Example for SQL Server
Posted by Erick Erickson <er...@gmail.com>.
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.groups@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
>