Hibernate

Replacements

java.util.Date     => java.time.Instant
java.sql.Timestamp => java.time.Instant
java.sql.Date      => java.time.LocalDate
java.sql.Time      => java.time.LocalTime

The Instant class represents a moment on the timeline in UTC with a resolution of nanoseconds (up to nine (9) digits of a decimal fraction).All three java.time.Local… classes are all lacking any concept of time zone or offset-from-UTC.

Challenges

Database	Auto Increment	Sequence	Usable
DB2/LUW	✓	✓	✓
DB2/z	✓	✓	✓
PostgreSQL	✓	✓	✓
Derby	✕	✓	✓
Firebird	✕	✓	✓
H2	✓	✓	✓
HyperSQL	✓	✓	✓
INGRES	✓	✕	✕
Informix	✓	✓	✓
MariaDB	✓	✕	✕
MySQL	✓	✕	✕
Oracle	✕	✓	✓
Sql Server	✕	✓	✓
SQLite	✓	✕	✕
Sybase	✓	✕	✕
Sybase Anywhere	✓	✓	✓

References

Choosing between java.util.Date or java.sql.Date An Overview of Identifiers in Hibernate Immutable and NaturalId Annotations Custom Id Generator using Hibernate Convention for Database Tables Java Persistence/Inheritance How to generate Custom Id NaturalId Example Tutorial Natural IDs in Spring Boot EclipseLink

Never use the TABLE identifier generator Custom Sequence Based ID Generator Create Sequence Supported Database Auto Increment Supported Database JPA Primary Key Prefix DBUnit Locale