[frs-341] JDBC 4.2 support in FusionReactor


Along with support for Java 8 the FusionReactor JDBC driver now supports the JDBC 4.2 specification and correctly pass through calls to these methods to the underlying objects.

Problem

However even with a JDBC 4.2 compliant driver on many servers you will not be able to correctly call 4.2 methods if you use datasources to create your connection. This is because many application servers wrap JDBC objects (Connection, Statement, ResultSet etc.) created via datasources/contexts.

At the time of writing Tomcat and ColdFusion (and likely other containers) do not implement JDBC 4.2 methods in their wrappers. Calls to these
methods will instead throw UnsupportedOperationException (the Java 8 default implementation).

Resoution/Workaround

Until support is added in wrappers the only way to call these methods is to obtain the connection directly from a DriverManager as opposed to using a datasource or context.

Issue Details

Type: Technote
Issue Number: FRS-341
Components: JDBC
Environment:
Resolution: Fixed
Last Updated: 20/Aug/14 4:49 PM
Affects Version:
Fixed Version: 5.2.0
Server:
Platform:
Related Issues: