Re: SolrException: Invalid Date String:'oracle.sql.TIMESTAMP

2012-01-12 Thread yunfei wu
I guess you probably run into the issue between different date value format in your oracle db and in solr field. Solr only expects XML date value in UTC format - http://lucene.apache.org/solr/api/org/apache/solr/schema/DateField.html. You might need to consider DateFormatTransformer - http://wiki.

RE: SolrException: Invalid Date String:'oracle.sql.TIMESTAMP

2012-01-12 Thread Colin Bennett
/DataImportHandler#DateFormatTransformer Colin. -Original Message- From: Joey Grimm [mailto:jgr...@rim.com] Sent: Thursday, January 12, 2012 1:05 PM To: solr-user@lucene.apache.org Subject: SolrException: Invalid Date String:'oracle.sql.TIMESTAMP Hi, I am trying to use a dataImportHandl

SolrException: Invalid Date String:'oracle.sql.TIMESTAMP

2012-01-12 Thread Joey Grimm
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 db-data-config.xml