Content
Comments (0)
Java with jdbc
while(rs.next()) {
System.out.println(rs.getString(1));
//java.sql.SQLException: Value '00:00:00 can not be represented
}
Solution : set zeroDateTimeBehavior=convertTo in JDBC URL parameter like this:
dataSource.setURL
("jdbc:mysql://localhost/databaseName?zeroDateTimeBehavior=convertToNull");