Re: DataImportHandler ignoring most rows

2009-08-19 Thread erikea...@yahoo.com
I switched to the ms driver an now all is well. Must be an incompatibility with the JSQLConnect driver. Sent from my iPhone On Aug 18, 2009, at 11:47 PM, Noble Paul നോബിള്‍ नो ब्ळ् wrote: > this comment says that > 7 > > the query fetched only 7 rows. If possible open a tool and just run

Re: DataImportHandler ignoring most rows

2009-08-19 Thread Lance Norskog
It usually helps to make a database view of your query, and then load the DIH from that view. There are cases where some query syntaxes are mangled on the way to the DB. 2009/8/18 Noble Paul നോബിള്‍ नोब्ळ् > this comment says that > 7 > > the query fetched only 7 rows. If possible open a tool

Re: DataImportHandler ignoring most rows

2009-08-18 Thread Noble Paul നോബിള്‍ नोब्ळ्
this comment says that 7 the query fetched only 7 rows. If possible open a tool and just run the same query and see how many rows are returned On Wed, Aug 19, 2009 at 3:46 AM, Erik Earle wrote: > Using: > - apache-solr-1.3.0 > - java 1.6 > - tomcat 6 > - sql server 2005 w/ JSQLConnect 4.0 driv

Re: DataImportHandler ignoring most rows

2009-08-18 Thread Erik Earle
Upgraded to the tip from svn and still no love. - Original Message From: Erik Earle To: solr-user@lucene.apache.org Sent: Tuesday, August 18, 2009 3:16:47 PM Subject: DataImportHandler ignoring most rows Using: - apache-solr-1.3.0 - java 1.6 - tomcat 6 - sql server 2005 w

DataImportHandler ignoring most rows

2009-08-18 Thread Erik Earle
Using: - apache-solr-1.3.0 - java 1.6 - tomcat 6 - sql server 2005 w/ JSQLConnect 4.0 driver I have a group table with 3007 rows. I have confirmed the key is unique with "select distinct id from group" and it returns 3007. When i re-index using http://host:port/solr/dataimport?command=full-im