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
