JDBC Wrapper Tool

David Stockton
David Stockton
Senior ColdFusion Consultant

Article Contents



  • Created:
    Thu, 8 Oct 2009
  • Updated:
    Wed, 16 May 2012
  • Products:
    FusionReactor
    Nagios
    JDBC Wrapper

JDBC Wrapper Tool

Users using FusionReactor 4.5.0 or higher should use the new wrapper found here.

The JDBC tool is designed to provide an automated interface to configure the FusionReactor JDBC Wrapper. The tool uses the CF admin API introduced in CF7 to add/update your DSN entries. Once installed, the JDBC wrapper doesn't break if your FusionReactor license expires (trial or subscription).

Note: The tool is still under active development. Though we have used this succesfully we cannot guarantee it will function in all cases. Please check below for our tested compatibility chart.


Requirements

FusionReactor
CF7 or above OR A Compatible CFML Engine


Latest Version

The latest versions available for download are:

Latest Stable: 0.10
Download
Documentation


Compatibility Notes

CF 9

  • There is an additional requirement for CF9. Please install the "fr_jdbc_wrapper.cfm" tool inside the "/CFIDE/administrator" folder.

Railo 3

  • Three is an additional requirement for Railo. Please ensure configuration security access is set to "open" when using the tool. This can be set back to your preferred setting after running the tool.

Tested Compatibility

Adobe CF 7,0,2,142559

  • Microsoft SQL Server
  • ODBC Socket

Adobe CF 8,0,1,195765

  • Apache Derby Client
  • Microsoft SQL Server
  • MySQL (4/5)
  • Apache Derby Embedded (Requires CF Restart)
  • ODBC Socket
  • PostgreSQL
  • Other JDBC Driver
  • Sybase

Adobe CF 9,0,0,251028

  • Apache Derby Client
  • Microsoft SQL Server
  • MySQL (4/5)
  • Apache Derby Embedded (Requires CF Restart)
  • ODBC Socket
  • PostgreSQL
  • Other JDBC Driver
  • Sybase

Railo 3.1.1.000

  • MSSQL - Microsoft SQL Server (Vendor Microsoft)
  • MSSQL - Microsoft SQL Server (Vendor jTDS)
  • MySQL

Railo 3.2.2.000

  • MSSQL - Microsoft SQL Server (Vendor Microsoft)
  • MSSQL - Microsoft SQL Server (Vendor jTDS)
  • MySQL

Screenshots






Changelog

  • v0.1 - Initial basic wrapping tool
  • v0.2 - Enhanced tool with un-wrap support for CFMX7 & CFMX8
  • v0.3 - Tool re-write with "wizard" stepped interface
  • v0.4beta - Javascript additions to DSN selection
  • v0.5beta - IE support (for Javascript changes) & updated website URLs
  • v0.6 - 0.5beta stabilised
  • v0.7 - Fixed "devMode" detection & embedded JavaScript loading
  • v0.8 - Added Support for Railo 3.1 and CF9
  • v0.9 - Updated support for Railo 3.2
  • v0.10 - Fixed bug in version detection