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
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