Unzip the zip file. get mysql-connector-java-5.1.10-bin.jar and place it under unzipped directory, bug_test.

1. Run table.ddl in mysql database.  The ad table is in InnoDB

2. Run data.sql to populate data in ad table.

3. Run MySQL server with --default-time-zone=GMT option.

4. Open a command prompt. 

5. Edit setEnv.cmd to to set JAVA_HOME

6. run setEnv.cmd in command prompt

7. Edit the connection url in TimeZoneTest.java to match your DB connection parameters,  The line is located in getConnection() method.


8. run compile.cmd to compile TimeZoneTest.java

9. run runTest.cmd to run TimeZoneTest.class

10. Check the print out.

11. The program created timestamp and calendar is located in testDateTimeColumnInRange() method.  The current value assume your backend DB is using GMT