From the monthly archives: April 2009

Code example: Java enum

By On 08/04/2009 · Leave a Comment

For no properties:

public enum Day { SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY }

For properties:

public enum Planet { MERCURY (3.303e+23, 2.4397e6), VENUS (4.869e+24, 6.0518e6), EARTH (5.976e+24, 6.37814e6), MARS (6.421e+23, 3.3972e6), JUPITER (1.9e+27, 7.1492e7), SATURN (5.688e+26, 6.0268e7), URANUS (8.686e+25, 2.5559e7), NEPTUNE (1.024e+26, 2.4746e7); private final double mass; // in kilograms private final double [...]

Continue Reading →

SQLException for zero DATETIME or TIMESTAMP column? Use zeroDateTimeBehavior

By On 03/04/2009 · Leave a Comment

from http://ondra.zizka.cz/stranky/programovani/java/index.texy

When working with MySQL over JDBC and the driver encounters a zero DATE, TIME, or DATETIME value (that is, e.g, ‚0000–00–00‘ for DATE), an exception is thrown:

java.sql.SQLException: Cannot convert value ’0000-00-00 00:00:00′ from column 4 to TIMESTAMP.

In this case, using SQL commands like

SET GLOBAL sql_mode = ‘NO_ZERO_DATE’;

does [...]

Continue Reading →