Local Solr - Error creating document with DIH

2008-12-29 Thread MapYours

I have my data import handler set up correctly it connects and streams
results returned from the database (sqlserver 2005) using JTDS driver.

However, no documents are indexed:
Dec 29, 2008 2:03:07 PM org.apache.solr.handler.dataimport.SolrWriter upload
WARNING: Error creating document :
SolrInputDocumnt[{incident_num=incident_num(1.0)={08518194 },
incident_date=incident_date(1.0)={2008-12-29 00:00:00.0},
location=location(1.0)={4300BLK SW 173RD AVE 
}, lat=lat(1.0)={45.4882}, lng=lng(1.0)={-122.85455}}]
java.lang.ClassCastException: java.lang.Double cannot be cast to
java.lang.String
at
com.pjaol.search.solr.update.LocalUpdaterProcessor.processAdd(LocalUpdateProcessorFactory.java:136)
at
org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:69)
at
org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImportHandler.java:288)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:319)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:178)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:136)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:334)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:386)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:377)

Here is my schema:

   
   
   
   

   
   
   

 

 
 incident_num

 
 location

-- 
View this message in context: 
http://www.nabble.com/Local-Solr---Error-creating-document-with-DIH-tp21211133p21211133.html
Sent from the Solr - User mailing list archive at Nabble.com.



Re: Local Solr - Error creating document with DIH

2008-12-30 Thread MapYours

Thanks,
That worked perfectly.


Noble Paul നോബിള്‍ नोब्ळ् wrote:
> 
> apparently the local solr expects everything as string. I guess we
> must raise an issue with them.
> meanwhile you can convert those double fields to String using
> TemplateTransformer
> 
> 
>   
> 
> 
> 
> On Tue, Dec 30, 2008 at 5:49 AM, MapYours  wrote:
>>
>> I have my data import handler set up correctly it connects and streams
>> results returned from the database (sqlserver 2005) using JTDS driver.
>>
>> However, no documents are indexed:
>> Dec 29, 2008 2:03:07 PM org.apache.solr.handler.dataimport.SolrWriter
>> upload
>> WARNING: Error creating document :
>> SolrInputDocumnt[{incident_num=incident_num(1.0)={08518194 },
>> incident_date=incident_date(1.0)={2008-12-29 00:00:00.0},
>> location=location(1.0)={4300BLK SW 173RD AVE
>> }, lat=lat(1.0)={45.4882}, lng=lng(1.0)={-122.85455}}]
>> java.lang.ClassCastException: java.lang.Double cannot be cast to
>> java.lang.String
>>at
>> com.pjaol.search.solr.update.LocalUpdaterProcessor.processAdd(LocalUpdateProcessorFactory.java:136)
>>at
>> org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:69)
>>at
>> org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImportHandler.java:288)
>>at
>> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:319)
>>at
>> org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:178)
>>at
>> org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:136)
>>at
>> org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:334)
>>at
>> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:386)
>>at
>> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:377)
>>
>> Here is my schema:
>> 
>>   
>>   
>>   
>>
>> 
>>   
>>   
>>
>>> stored="true"/>
>>  
>>
>>  
>>  incident_num
>>
>>  
>>  location
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Local-Solr---Error-creating-document-with-DIH-tp21211133p21211133.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
> 
> 
> 
> -- 
> --Noble Paul
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Local-Solr---Error-creating-document-with-DIH-tp21211133p21220673.html
Sent from the Solr - User mailing list archive at Nabble.com.