src/main/java/org/embulk/input/MySQLInputPlugin.java in embulk-input-mysql-0.2.0 vs src/main/java/org/embulk/input/MySQLInputPlugin.java in embulk-input-mysql-0.2.1
- old
+ new
@@ -22,10 +22,13 @@
Properties props = new Properties();
props.setProperty("user", task.getUser());
props.setProperty("password", task.getPassword());
- props.setProperty("rewriteBatchedStatements", "true");
+ // convert 0000-00-00 to NULL to avoid this exceptoin:
+ // java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
+ props.setProperty("zeroDateTimeBehavior", "convertToNull");
+
props.setProperty("useCompression", "true");
props.setProperty("connectTimeout", "300000"); // milliseconds
props.setProperty("socketTimeout", "1800000"); // smillieconds