Hello Shalin,
thank you for your reply.
Unfortunately I have to perform some kind of transformation otherwise the
exception is:
org.apache.solr.common.SolrException: Invalid Date
String:'2008-07-12T22:00:26+0200'
at org.apache.solr.schema.DateField.parseMath(DateField.java:167)
at org.apache.solr.schema.DateField.toInternal(DateField.java:138)
at org.apache.solr.schema.FieldType.createField(FieldType.java:179)
at org.apache.solr.schema.SchemaField.createField(SchemaField.java:93)
at
org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:243)
at
org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:58)
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)
Any idea?
Thanks,
Giovanni
On Mon, Mar 30, 2009 at 6:52 PM, Shalin Shekhar Mangar <
shalinman...@gmail.com> wrote:
> On Mon, Mar 30, 2009 at 8:52 PM, Giovanni De Stefano <
> giovanni.destef...@gmail.com> wrote:
>
> > 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
>
>
> The jdbc equivalent of an Oracle timestamp is java.sql.Date which is a
> sub-class of java.util.Date. DateFormatTransformer is used to convert
> strings to a date object. Therefore, if your solr field is of date type,
> you
> don't need to use DateFormatTransformer at all.
>
>
> --
> Regards,
> Shalin Shekhar Mangar.
>
