Awesome, thanks!!!!!!! I first thought it could be "blob-field" related.
Have a nice day Sebastian Noble Paul നോബിള് नोब्ळ्-2 wrote: > > you may need to change the mysql connection parameters so that it does > not throw error for null date > > "jdbc:mysql://localhost/test?zeroDateTimeBehavior=convertToNull" > > On Thu, May 7, 2009 at 1:39 PM, gateway0 <reiterwo...@yahoo.de> wrote: >> >> Hi, >> >> when I do a full import I get the following error : >> >> "Caused by: java.sql.SQLException: Cannot convert value '0000-00-00 >> 00:00:00' from column 10 to TIMESTAMP. >> 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.getTimestampFast(ResultSetRow.java:1321) >> at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) >> at >> com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) >> at >> com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) >> at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4901) >> at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4951) >> at >> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.getARow(JdbcDataSource.java:220) >> ... 11 more >> Caused by: java.sql.SQLException: Value '[...@14f9f4a' can not be >> represented >> as java.sql.Timestamp >> 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.getTimestampFast(ResultSetRow.java:1027) >> ... 17 more" >> >> But I thought the Timestamp is generated automatically and has nothing to >> do >> with my mysql database? >> >> best regards, Sebastian >> -- >> View this message in context: >> http://www.nabble.com/Dataimporthandler---Timestamp-Error---tp23422139p23422139.html >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> > > > > -- > ----------------------------------------------------- > Noble Paul | Principal Engineer| AOL | http://aol.com > > -- View this message in context: http://www.nabble.com/Dataimporthandler---Timestamp-Error---tp23422139p23424354.html Sent from the Solr - User mailing list archive at Nabble.com.
