I guess this can go in the FAQ section of DIH
On Wed, Apr 29, 2009 at 9:47 PM, Erick Erickson wrote:
> Thanks for letting us all know the resolution, that may save some other
> poor soul from frustration
>
> Best
> Erick
>
> On Wed, Apr 29, 2009 at 9:31 AM, Ci-man wrote:
>
>>
>> Found the pr
Thanks for letting us all know the resolution, that may save some other
poor soul from frustration
Best
Erick
On Wed, Apr 29, 2009 at 9:31 AM, Ci-man wrote:
>
> Found the problem.
> It is with Microsoft jdbc drivers (jdbc 2.0).
>
> With the latest download Microsoft provides two .jar files:
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
forgot to mention DIH has a debug mode
2009/4/29 Noble Paul നോബിള് नोब्ळ् :
> just put it on debugger and you will know if the query is indeed
> fetching any rows
>
> On Wed, Apr 29, 2009 at 2:59 AM, Ci-man wrote:
>>
>> Thanks for your question.
>> Yes all the fields are defined in the schema;
just put it on debugger and you will know if the query is indeed
fetching any rows
On Wed, Apr 29, 2009 at 2:59 AM, Ci-man wrote:
>
> 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.
>
>
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
Did you define all the fields that you used in schema.xml?
Ci-man wrote:
>
> I am using MS SQL server and want to index a table.
> I setup my data-config like this:
>
>
> autoCommit="true"
> driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>
