Enhancements to IBM Toolbox for Java JDBC support for IBM i 7.5

Many additions were made to JDBC support in IBM i 7.5.

The enhancements to IBM® Toolbox for Java™ JDBC support are the following.
  • Support boolean data type on IBM i 7.5
  • Support LocalTime,LocalDate,LocalDateTime
  • New connection property: tcp no delay

Support boolean data type on IBM i 7.5

IBM i 7.5 has added support for a native boolean type. The driver was updated to correctly handle the new boolean data type on IBM i 7.5

Support LocalTime , LocalDate , LocalDateTime

The JDBC 4.2 support was updated to correctly support the LocalTime, LocalDate, and LocalDateTime data types.

New connection property: tcp no delay

The “tcp no delay” connection property was added to force the underlying socket to immediately send data when the property is set to true. This is useful for systems when the use of Nagle’s algorithm by the underlying operating system can cause performance problems when using the JDBC driver.