JDBC app that INSERT/SELECT OffsetDateTime using PreparedStatement#setObject() and ResultSet#getObject()

OffsetDateTimeTest.java

import java.sql.*;
import java.time.*;
import java.util.*;

public class OffsetDateTimeTest {
  public static void main(String[] args) throws Exception {
    try (Connection con = new JdbcConnection(args[0]).getConnection()) {
      try (Statement stmt = con.createStatement()) {
        try {
          stmt.execute("drop table test");
        } catch (Exception e) {
          // expected
        }
        stmt.execute("create table test (id integer, t " + args[1] + ")");
      }
      insert(con);
      select(con, 2);
    }
  }

  private static void select(Connection con, final Integer id) throws SQLException {
    try (PreparedStatement stmt = con.prepareStatement("select id, t from test where id = ?")) {
      stmt.setInt(1, id);
      try (ResultSet rs = stmt.executeQuery()) {
        while (rs.next()) {
          System.out.println("id: " + rs.getInt(1));
          System.out.println("time: " + rs.getObject(2, OffsetDateTime.class));
        }
      }
    }
  }

  private static void insert(Connection con) throws SQLException {
    try (PreparedStatement stmt = con.prepareStatement("insert into test (id, t) values (?, ?)")) {
      OffsetDateTime testValue = OffsetDateTime.of(2018, 10, 8, 11, 22, 33, 123456789, ZoneOffset.ofHoursMinutes(10, 20));
      stmt.setInt(1, 2);
      stmt.setObject(2, testValue);
      stmt.executeUpdate();
    }
  }
}

public class JdbcConnection {
  private final String db;

  public JdbcConnection(String db) {
    this.db = db;
  }

  public Connection getConnection() throws ClassNotFoundException, SQLException {
    final ResourceBundle bundle = ResourceBundle.getBundle("dbs/" + db);
    final String driver = bundle.getString("driver");
    final String url = bundle.getString("url");
    final String username = bundle.getString("username");
    final String password = bundle.getString("password");
    Class.forName(driver);
    Connection con = DriverManager.getConnection(url, username, password);
    DatabaseMetaData dbmd = con.getMetaData();
    System.out.println(">>> DB version : " + dbmd.getDatabaseProductName() + " " + dbmd.getDatabaseProductVersion());
    System.out.println(">>> Driver version : " + dbmd.getDriverVersion());
    return con;
  }
}

Put drivers in 'drivers' directory and JDBC configuration files in 'dbs' direcotry.

The .properties files should look as follows.

driver=org.hsqldb.jdbcDriver
url=jdbc:hsqldb:mem:test
username=sa
password=

With Java 11, you can run it directly as follows.

java --module-path drivers OffsetDateTimeTest.java hsqldb "timestamp with time zone"

The first argument is the file name of a DB config and the second argument is the column type.