jpa - Telosys Timestamp Generation Date problem (missing nanosecond precision)

Question

Telosys generates timestamp columns like that:

@Temporal(TemporalType.TIMESTAMP)
@Column(name="AKT_TS")
private Date aktTs;

Unfortunately Date does only have millisecond precision, not nanosecond (but the DB has of course). Example:

• Date (Java): 2020-12-03T16:28:58.302+0000
• DB: 2020-12-03 17:28:58.302339

Is there an easy way to force telosys to generate LocalDateTime (or java.sql.Timestamp), so that the whole precision can be used?

Answer 1

In the model entity file use the 'timestamp' type with '@SqlType'

'@SqlType' switches to 'java.sql.*' types (Time, Timestamp, Blob, etc) if possible

Example :

Entity file :

 fieldName : timestamp { @SqlType } ;

Generated code :

  @Column(name="fieldName")
  private Timestamp  fieldName    ;