JPA

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
Derby	✕	✓	✓
Firebird	✕	✓	✓
INGRES	✓	✕	✕
MariaDB	✓	✕	✕
MySQL	✓	✕	✕
Oracle	✕	✓	✓
Sql Server	✕	✓	✓
SQLite	✓	✕	✕
Sybase	✓	✕	✕

References

Serialize/deserialize java.time with Jackson Usage OrderBy with findAll in Spring Data Never use the TABLE identifier generator Convention for Database Tables Java Persistence/Inheritance EclipseLink Hibernate DBUnit MyBatis Locale

Choosing between java.util.Date or java.sql.Date Integration of MyBatis & JPA in Spring boot Custom Sequence Based ID Generator Auto Increment Supported Database SQLite3 Doesn't Provide a Date Type JPA use hbm.xml & annotations JPA & SQLite3 - Wrong Date How to generate Custom Id JPA Primary Key Prefix Java Date vs Calendar

Create Sequence Supported Database