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 നോബിള് नो ब्ळ् <noble.p...@corp.aol.com> wrote: > this comment says that > <str name="Total Rows Fetched">7</str> > > 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<erikea...@yahoo.com> > wrote: >> 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-import >> I only get 7 records indexed. Any insight into what is going on >> would be really great. >> >> A partial response: >> <lst name="statusMessages"> >> <str name="Total Requests made to DataSource">1</str> >> <str name="Total Rows Fetched">7</str> >> <str name="Total Documents Skipped">0</str> >> >> >> I have other entities that index all the rows without issue. >> >> There are no errors in the logs. >> >> I am not using any Transformers (and most of my config is not >> changed from install) >> >> My schema.xml contains: >> >> <uniqueKey>key</uniqueKey> >> >> and field defs (not a full list of fields): >> <field name="key" type="string" indexed="true" stored="true" >> required="true" /> >> <field name="class" type="string" indexed="true" stored="true" >> required="true" /> >> <field name="id" type="string" indexed="true" stored="true" /> >> <field name="description" type="text" indexed="true" >> stored="true" /> >> <field name="created" type="date" indexed="true" stored="true" /> >> <field name="updated" type="date" indexed="true" stored="true" /> >> >> data-config.xml >> ################ >> <dataConfig> >> <!-- jdbc:JSQLConnect://se-eriearle-lt1/database=SocialSite2/ >> user=SocialSite2/logfile=DB_TRACE.log --> >> <dataSource type="JdbcDataSource" >> driver="com.jnetdirect.jsql.JSQLDriver" >> url="jdbc:JSQLConnect://se-eriearle-lt1/database=SocialSite2/ >> user=SocialSite2" >> user="SocialSite2" >> password="SocialSite2" /> >> >> <document> >> >> .... >> >> <entity name="Group" pk="key" >> query="select 'group.'+id as 'key', 'group' as 'class', >> name, handle, description, created, updated from group order by >> created asc"> >> </entity> >> >> <entity name="Message" pk="key" >> query="<...redacted...>"> >> </entity> >> >> </document> >> </dataConfig> >> >> >> >> > > > > -- > ----------------------------------------------------- > Noble Paul | Principal Engineer| AOL | http://aol.com