JarCastingThreeTen JPA 
JPA attribute converters for JSR-310 (Java 8) dates and times.
This project was stop gap measure until JPA_SPEC-63 was fixed in JPA 2.2. However JSR-310 support in JPA is not ready for prime time. The project serves the following purposes:
- provide JSR-310 support for users on JPA 2.1
- provide support for additional JSR-310 data types not specified by JPA 2.2
- provide workarounds for driver bugs and missing driver features
- provide workarounds for JPA implementation bugs
We take inspiration from the JDBC 4.2 and currently support the following conversions:
| ANSI SQL | Java SE 8 |
|---|---|
| DATE | LocalDate |
| TIME | LocalTime |
| TIMESTAMP | LocalDateTime |
| TIMESTAMP WITH TIMEZONE | OffsetTime (*) |
| TIMESTAMP WITH TIMEZONE | ZonedDateTime (*) |
| INTERVAL YEAR TO MONTH | Period (*) |
| INTERVAL DAY TO SECOND | Duration (*) |
(*) requires special extensions, see below
Not supported is converting TIME WITH TIMEZONE to OffsetTime because it seems not very useful.
This project requires Java SE 8 (for the date and time classes) and JPA 2.1 (for the attribute converters). Java SE 9 is supported as well.
This project is very similar to montanajava/jpaattributeconverters or perceptron8/datetime-jpa and can be used in much the same way.
Usage
<dependency>
<groupId>com.github.marschall</groupId>
<artifactId>threeten-jpa</artifactId>
<version>1.12</version>
</dependency>
<persistence-unit>
…
<class>com.github.marschall.threeten.jpa.LocalTimeConverter</class>
<class>com.github.marschall.threeten.jpa.LocalDateConverter</class>
<class>com.github.marschall.threeten.jpa.LocalDateTimeConverter</class>
…
</persistence-unit>
@Entity
public class SampleEntity {
@Column
private LocalDate localDate;
@Column
private LocalTime localTime;
@Column
private LocalDateTime localDateTime;
}
All the converters have set Converter#autoApply() to true so they're automatically applied to all entities in the same persistence unit.
Converters
You can find a complete list of all converters in the Javadoc
- threeten-jpa
- threeten-jpa-jdbc42-hibernate
- threeten-jpa-oracle-hibernate
- threeten-jpa-oracle-eclipselink
- threeten-jpa-h2-eclipselink
- threeten-jpa-mssql-eclipselink
- threeten-jpa-mssql-hibernate
- threeten-jpa-zoned-hibernate
Time Zone Support
Time Zone Support is documented on the wiki.
Interval Support
Oracle Interval Support is documented on the wiki.
Hibernate 5.x
If you are on Hibernate 5.x and JDBC driver properly supports JDBC 4.2 we strongly recommend using the UserTypes from the threeten-jpa-jdbc42-hibernate subproject.
If your driver does not support JDBC 4.2 the hibernate-java8 module introduced in Hibernate 5.0.0 (no longer needed for Hibernate 5.2.0) provides functionality that is equivalent to threeten-jpa and we recommend you use the Hibernate support instead.
Project Structure
The project includes the following submodule:
threeten-jpacontains portable converters.threeten-jpa-oracle-eclipselinkcontains extensions that work only with Oracle in combination with EclipseLink to mapTIMESTAMP WITH TIMEZONEtoZonedDateTimeorOffsetDateTime.threeten-jpa-h2-eclipselinkcontains extensions that work only with H2 in combination with EclipseLink to mapTIMESTAMP WITH TIMEZONEtoOffsetDateTime.threeten-jpa-mssql-eclipselinkcontains extensions that work only with an old SQL Server driver in combination with EclipseLink to mapDATETIMEOFFSETtoOffsetDateTime.threeten-jpa-mssql-hibernatecontains extensions that work only with an old SQL Server driver SQL Server in combination with Hibernate to mapDATETIMEOFFSETtoOffsetDateTime.threeten-jpa-oracle-hibernatecontains extensions that work only with Oracle in combination with Hibernate to mapTIMESTAMP WITH TIMEZONEtoZonedDateTimetoOffsetDateTime.threeten-jpa-jdbc42-hibernatecontains extensions that work with any JDBC 4.2 compliant driver in combination with Hibernate. They mapTIMESTAMP WITH TIMEZONEtoZonedDateTimeorOffsetDateTimeTIMESTAMP [ WITHOUT TIME ZONE ]toLocalDateTimeTIMEtoLocalTimethreeten-jpa-oracle-implcontains the type conversion code from Oracle types to Java 8 types.threeten-jpa-zoned-hibernatecontains composite user types to supportZonedDateTime.
Tested with following JPA providers:
- EclipseLink
- Hibernate
Tested with the following databases:
- Derby
- Firebird
- H2
- HSQL
- MariaDB
- MySQL
- Oracle
- PostgreS
- SQL Server
DB2 is currently not supported as IBM does not ship a JDBC 4.2 driver.
License
This project is licensed under the MIT license.