Hello all, I have a little problem with DIH and DateFormatTransformer.
My column in the DB contains an Oracle TIMESTAMP; the corresponding field is of type date in the Solr schema; I specified a DateFormatTransformer for the entity; the field definition is as follow: <field column="WHATEVER" name="whatever" dateTimeFormat="yyyy-MM-dd'T'hh:mm:ss'+'SSSS"/> but I keep getting a ClassCastException... WARNING: transformer threw error java.lang.ClassCastException: java.sql.Date at org.apache.solr.handler.dataimport.DateFormatTransformer.transformRow(DateFormatTransformer.java:69) at org.apache.solr.handler.dataimport.EntityProcessorBase.applyTransformer(EntityProcessorBase.java:186) at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:80) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:285) 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) 17:15:59,964 ERROR [STDERR] Mar 30, 2009 5:15:59 PM org.apache.solr.handler.dataimport.DocBuilder buildDocument SEVERE: Exception while processing: downloadable document : SolrInputDocumnt[{}] org.apache.solr.handler.dataimport.DataImportHandlerException: java.lang.ClassCastException: java.sql.Date at org.apache.solr.handler.dataimport.EntityProcessorBase.applyTransformer(EntityProcessorBase.java:206) at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:80) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:285) 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) Caused by: java.lang.ClassCastException: java.sql.Date at org.apache.solr.handler.dataimport.DateFormatTransformer.transformRow(DateFormatTransformer.java:69) at org.apache.solr.handler.dataimport.EntityProcessorBase.applyTransformer(EntityProcessorBase.java:186) ... 7 more Any idea? How can I fix this? Thanks a lot! Giovanni