Save java.time.LocalDate in Date column of DB2 database

Question

How to persist an item of java.time.LocalDate in a column of type Date within a DB2 database ?

Answer 1

Using a JDBC driver supporting JDBC 4.2 or later, use:

• PreparedStatement::setObject()
• ResultSet::getObject()

Example:

myPStmt.setObject( … , myLocalDate ) ;

Retrieving that date.

LocalDate myLocalDate = myResultSet.getObject( … , LocalDate.class ) ;