![](https://secure.gravatar.com/avatar/1193e282a8c5ecef261087cbcc6e1961.jpg?s=120&d=mm&r=g)
28 Mar
2016
28 Mar
'16
11:05 a.m.
Recently I changed servers, my old server was running MySQL and my Java code worked perfectly. My new server is apparently running Ver 15 5.5.44-MariaDB, for Linux (x86 64) The following code works and has worked perfectly well for the past 4 years java.sql.Timestamp transactionTimestamp = new java.sql.Timestamp(System.currentTimeMillis()); PreparedStatement pstmt ... pstmt.setTimestamp(4, transactionTimestamp); pstmt.executeUpdate(); // EPIC FAIL, writes all 0s to the database I'm currently using mysql-connector-java-5.1.22-bin.jar in WEB-INF/lib Can anyone throw any light on this please? Many thanks Lyallex