[DIH] Example for SQL Server

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[DIH] Example for SQL Server

Adam Estrada-2
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
Reply | Threaded
Open this post in threaded view
|

Re: [DIH] Example for SQL Server

Erick Erickson
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 <[hidden email]
> 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
>
Reply | Threaded
Open this post in threaded view
|

Re: [DIH] Example for SQL Server

savvas.andreas
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 <[hidden email]> 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 <
> [hidden email]
> > 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
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: [DIH] Example for SQL Server

Adam Estrada
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 <
[hidden email]> 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 <[hidden email]> 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 <
> > [hidden email]
> > > 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
> > >
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: [DIH] Example for SQL Server

Adam Estrada
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 <[hidden email]>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 <
> [hidden email]> 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 <[hidden email]>
>> 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 <
>> > [hidden email]
>> > > 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
>> > >
>> >
>>
>
>