Re: Unable to import data from database

2009-04-29 Thread Ci-man
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

Re: Unable to import data from database

2009-04-29 Thread Ci-man
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

Re: Unable to import data from database

2009-04-28 Thread Ci-man
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

Unable to import data from database

2009-04-28 Thread Ci-man
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: