Found the problem.
It is with Microsoft jdbc drivers (jdbc 2.0).
With the latest download Microsoft provides two .jar files:
sqljdbc.jar
sqljdbc4.jar
I had copied both into the lib directory. By doing so it used the older
drivers (sqljdbc.jar) which do not work with jvm1.6. You get this kind of
Thanks.
I found the interactive debugger .
solr/admin/dataimport.jsp
and I am seeing exceptions in Java that I can dig into
--
View this message in context:
http://www.nabble.com/Unable-to-import-data-from-database-tp23283852p23295859.html
Sent from the Solr - User mailing list archive at Nabb
Thanks for your question.
Yes all the fields are defined in the schema; I am using the default schema
and mapping between the DB fields and schema fields.
My biggest problem is that it appears that no records are being pulled as
"Total Rows Fetched" always zero.
Did you define all the fields
I am using MS SQL server and want to index a table.
I setup my data-config like this:
I am unable to load data from database. I always receive 0 document fetched: