You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@lucene.apache.org by Doug Ford <DF...@nu.edu> on 2015/06/25 20:27:00 UTC

Problems with managed schema

Hello -

I have set up a Solr 5.1 engine that is able to retrieve data from a MS SQL database.

But when I run the data import process it comes back as:

Requests: 1 (1/s), Fetched: 1,113 (1,113/s), Skipped: 0, Processed: 0 (0/s)



The Fetched is correct, but the Processed is a problem.

I am using the managed-schema process.

My db-data-config file is simply:

<dataConfig>
    <dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
               url="jdbc:sqlserver://myserver;databaseName=myDB"
               user="user"
               password="password"
               name="newtest" />
    <document name="faculty">
        <entity name="faculty" pk="record" dataSource="newtest"
        query = "
               select record, firstname, lastname, facultyID
               from faculty">

        <field column="record" name="record" />
        <field column="firstname" name="firstname" />
        <field column="lastname" name="lastname" />
        <field column="facultyID" name="facultyID" />
        </entity>
    </document>
</dataConfig>



Any and all suggestions are appreciated.

Thanks