Jeremiah Jahn wrote:
Thoughts on this one? This follows the examples given in the replies exactly.
if (currentIteration %2 == 0){ insertPreparedStatement.setTimestamp(5,new Timestamp(new Date().getTime())); } else { insertPreparedStatement.setNull(5,Types.TIMESTAMP); <-----problem code }
java.sql.BatchUpdateException: An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'null'. at org.apache.derby.impl.jdbc.EmbedStatement.executeBatch(EmbedStatement.java)
I think there are some bugs with batch processing. I think someone noticed them on the list very early but the bug never made it to Jira.
Dan.
