For instance, JPA will map the LocalDate property into a blob instead of the java.sql.Date object. I have found. REF CURSOR Types and Result Sets Mapping TYPE curtype1 IS REF CURSOR RETURN emp%rowtype; FUNCTION get1 RETURN curtype1; public oracle.jdbc.rowset.OracleWebRowSet get1WebRowSet() throws java.sql.SQLException; public java.sql.ResultSet get1() throws java.sql.SQLException; The package java.sql contains a number of data types for compatibility with SQL database types. The JPA 2.2 specification maps only the classes of the Date and Time API for which the appendix section B4 of the JDBC 4.2 specification defines a mapping. Mapping Type. Standard JPA Annotation. I tried Boolean, which didn't work and produced the following errors:. As a result, the database won't recognize the LocalDate property as a Date type. The SQL BIT type can be mapped directly to the Java boolean type. 4 bigint_type Bigint Type java.lang.Long int8 20. map Java Compatibility with JDBC mappings. [ Contents ][ Back ][ Next ] [ Trademarks ] These types are called Hibernate mapping types, which can translate from Java to SQL data types and vice versa.. Hibernate can map all of them to a java.util.Date or a java.util.Calendar. In general, any MySQL data type can be converted to a java.lang.String, and any numeric type can be converted to any of the Java numeric types, although round-off, overflow, or loss of precision may occur. java.time.LocalDate is also supported and recommended. 使用AOP+反射实现自定义Mybatis多表关联查询 - 编程宝库 Java format types. Database An SQL CLOB type stores a large array of characters as the value in a column of a database. 2 You can programmatically access values of datetimeoffset with DateTimeOffset Class. 3 int_type Int Type java.lang.Integer int4 11. SQL Maps adapters to Java types. ›Database and Application Migrations. map the Java YearMonth type with JPA