Hi,

I am trying to use a dataImportHandler to import data from an oracle DB.  It
works for non-date fields but is throwing an exception once I included the
MODIFIEDDATE field (oracle.timestamp field).  Can anyone see what I'm doing
wrong here?  Thanks.



schema.xml
   <field name="catModifiedDate" type="date" indexed="true" stored="true" /> 

db-data-config.xml

<entity name="category" datasource="jdbc" 
                        query="SELECT ID,PARENTID,ICONID,SORTORDER,MODIFIEDDATE 
FROM CATEGORY">

                        
                        <field column="ID" name="masterId" />
                        <field column="PARENTID" name="catParentId" />
                        <field column="ICONID" name="catIconId" />
                        <field column="SORTORDER" name="catSortOrder" />
                        <field column="MODIFIEDDATE" name="catModifiedDate"/>


WARNING: Error creating document :
SolrInputDocument[{catModifiedDate=catModifiedDate(1.0)={oracle.sql.TIMESTAMP@1e58565},
masterId=masterId(1.0)={124}, catParentId=catParentId(1.0)={118},
catIconId=catIconId(1.0)={304856}}]
org.apache.solr.common.SolrException: ERROR: [doc=124] Error adding field
'catModifiedDate'='oracle.sql.TIMESTAMP@1e58565'
        at
org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:324)
        at
org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:60)
        at
org.apache.solr.update.processor.LogUpdateProcessor.processAdd(LogUpdateProcessorFactory.java:115)
        at 
org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:73)
        at
org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImportHandler.java:293)
        at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:636)
        at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:268)
        at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:187)
        at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:359)
        at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:427)
        at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:408)
Caused by: org.apache.solr.common.SolrException: Invalid Date
String:'oracle.sql.TIMESTAMP@1e58565'
        at org.apache.solr.schema.DateField.parseMath(DateField.java:165)
        at org.apache.solr.schema.TrieField.createField(TrieField.java:421)
        at 
org.apache.solr.schema.TrieDateField.createField(TrieDateField.java:120)
        at org.apache.solr.schema.SchemaField.createField(SchemaField.java:104)
        at
org.apache.solr.update.DocumentBuilder.addField(DocumentBuilder.java:203)
        at
org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:281)

--
View this message in context: 
http://lucene.472066.n3.nabble.com/SolrException-Invalid-Date-String-oracle-sql-TIMESTAMP-tp3654419p3654419.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to