[frs-345] FusionReactor 5.2.0 to 5.2.2: JDBC 4.2 (Java 1.7) Incompatibility

Important: Users of FusionReactor 5.2.0 to 5.2.2 on Adobe ColdFusion Platforms on Java 1.7 and earlier – Update to FR 5.2.3

Customers using FusionReactor versions 5.2.0 to 5.2.2 inclusive, on Adobe ColdFusion running on Java 1.7 and earlier, may see the following exception, followed by a stack trace:

java.lang.NoClassDefFoundError: java/sql/SQLType

This exception occurs when a Datasource is used by a ColdFusion script.

This type was introduced in Java 1.8 (JDBC 4.2). FusionReactor 5.2.0 introduced JDBC Wrapper support for Java 8, but in a way that (should have been) backwards compatible for Java 1.7 (JDBC 4.1) and earlier. The new functionality is not ordinarily visible to clients of the 1.7 driver code.

Unfortunately, the Adobe ColdFusion platform (when running in Java 1.7) enumerates the complete driver, and throws the above exception when attempting to examine the new Java 1.8 (JDBC 4.2) functionality, since the type is new for 1.8 and not present in 1.7.


To work around this issue, customers are strongly encouraged to upgrade to FusionReactor 5.2.3, which corrects it.

If this is not possible:

  • Use a version of FusionReactor earlier than 5.2.0.
  • Exclude the data source by adding __fusionreactor_exclude=true to the data source's Connection String, found in the ColdFusion Administrator > Datasources > (datasource) > Advanced Settings

Issue Details

Type: Technote
Issue Number: FRS-345
Components: JDBC
Resolution: Fixed
Last Updated: 10/Sep/14 4:31 PM
Affects Version: 5.2.0, 5.2.1, 5.2.2
Fixed Version: 5.2.3
Related Issues:

Comments are closed.