yes. i put the &zeroDateTimeBehavior=convertToNull to my url like:
url="jdbc:mysql://localhost/databaseName?zeroDateTimeBehavoir=convertToNull"
ExceptoiN:
May 23, 2011 3:30:22 PM org.apache.solr.handler.dataimport.DataImporter
doFullImport
SEVERE: Full Import failed
org.apache.solr.handler.dataimport.DataImportHandlerException: Error reading
data from database Processing Document # 1
at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.getARow(JdbcDataSource.java:319)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.access$700(JdbcDataSource.java:226)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.next(JdbcDataSource.java:264)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.next(JdbcDataSource.java:258)
at
org.apache.solr.handler.dataimport.EntityProcessorBase.getNext(EntityProcessorBase.java:76)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:233)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:579)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:605)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:260)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:184)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:334)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:392)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:373)
Caused by: java.sql.SQLException: Value 'XXX
2011-01-07
0000-00-00
2011-01-21
0000-00-0030311414501210open2011-01-07 15:10:47
10.1.0.1212011-01-07 15:10:472011-01-07 15:10:47' can not be represented
as java.sql.Date
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ResultSetRow.getDateFast(ResultSetRow.java:140)
at com.mysql.jdbc.BufferRow.getDateFast(BufferRow.java:706)
at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2174)
at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2127)
at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4956)
at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5012)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.getARow(JdbcDataSource.java:284)
... 13 more
XXX are data which nobody should see ;-)
-----
------------------------------- System ----------------------------------------
One Server, 12 GB RAM, 2 Solr Instances, 7 Cores,
1 Core with 31 Million Documents other Cores < 100.000
- Solr1 for Search-Requests - commit every Minute - 5GB Xmx
- Solr2 for Update-Request - delta every Minute - 4GB Xmx
--
View this message in context:
http://lucene.472066.n3.nabble.com/how-to-convert-YYYY-MM-DD-to-YYY-MM-DD-hh-mm-ss-DIH-tp2961481p2975285.html
Sent from the Solr - User mailing list archive at Nabble.com.
