mysql datetime 对于hbm,MySQL DATETIME精度（joda-time，Hibernate，org.jadira.usertype，hbm2ddl）...

In my hibernate-4 entity, I am mapping a joda-time DateTime property using the recommended jadira usertypes:

@Entity

@Table(name="timing")

public class TimingEntity {

...

@Basic(optional=false)

@Column(name="moment")

@Type(type="org.jadira.usertype.dateandtime.joda.PersistentDateTime")

public DateTime getMoment() {

...

My database is MySQL. With hibernate property hbm2ddl.auto set to create value, I have the following column generated in my timing table:

CREATE TABLE `timing` (

...

`moment` DATETIME NOT NULL,

...

)

The generated CREATE TABLE contains the DATETIME column. The DATETIME in MySQL has only seconds precision, without fractional part. In order to enable fractional part, up to microseconds, MySQL 5.6.4 and higher enables DATETIME(precision) columns, for example DATETIME(3) to have milliseconds precision.

My question is -- is there way to specify precision for my temporal fields generated with hbm2ddl? At least, is this a matter of jadira usertypes, or java.sql, or jdbc driver machinery?

P.S. When I manually modify the DB table to have the exact column precision I want, say, DATETIME(3), everything works OK - joda DateTimes are written and read from the DB with milliseconds precision.

解决方案

Use can use @Column#columnDefinition property for it

@Basic(optional=false)

@Column(name="moment" columnDefinition="DATETIME(3) NOT NULL")

@Type(type="org.jadira.usertype.dateandtime.joda.PersistentDateTime")

public DateTime getMoment()

{

...

Also you can try @Column#precision property, but in documentation is written that this working only for decimals.