The Ultimate Guide to High Availability with MariaDB

millisecond part is trimmed away when saving Java Date obj by hibernate

Hi,

I recently upgraded my MySQL DB to MariaDB for millisecond support. I can see the millisecond part in my upgraded database. And I tested the millisecond support by inserting a row to a table of my db. It functions well. But when I use hibernate to save a java.util.Date obj into database, millisecond part is trimmed and in MariaDB date obj is saved as: 2012-02-13 18:40:55.000. Do I need to set up something to activate millisecond support? Or I need to config hibernate for millisecond support?

Thanks a lot!

Answer Answered by Vladislav Vaintroub in this comment.

In case official Connector/J still does not support fractional seconds, and you're comfortable with compiling connector from source, we have a repository based on Connector/J 5.1.15 with microsecond support.

http://bazaar.launchpad.net/~maria-captains/maria/connectorj-5.1.5-micro/

(don't be confused by "5.1.5", it is a wrong label, repo is a based on 5.1.15)

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.