Using the FusionReactor JDBC Driver Wrapper Tutorial Basic Setup Setting up a wrapped datasource The first step in using the Wrapper is to find your ColdFusion datasource. Intergral Information Solutions GmbH Schickardstr 32 • D-71034 • Böblingen • Germany Tutorial: Using the FusionReactor JDBC Driver Wrapper Doc. Rev. 238, 26 June 2006

Using the FusionReactor JDBC Driver Wrapper Tutorial Basic Setup Setting up a wrapped datasource The first step in using the Wrapper is to find your ColdFusion datasource. This datasource should be working prior to applying the Wrapper. Find your datasource within the ColdFusion Administrator’s ‘Data Sources’ section. Here’s ours: You can see that the example will use a built-in Macromedia driver to connect to the ‘frtest’ SQL Server database on int0006. In order to have FusionReactor gather metrics for this connection, we must ‘wrap’ the driver. This will involve converting it to an ‘other’ type driver. In ColdFusion Administrator, add a new driver called ‘frtest-wrapper’, of type ‘other’. You can refer to the FusionReactor JDBC Driver Wrapper User Guide to get some examples of JDBC URLs for the Macromedia builtin drivers. Here’s the form with our previous connection ‘wrapped’ with the FusionReactor JDBC Driver Wrapper. The important things to note here are: 1. Since we’re using an ‘other’ type driver, we worked out the Macromedia builtin driver URL (using the FusionReactor JDBC Driver Wrapper User Guide) : jdbc:macromedia: sqlserver://int0006:1433;databaseName=frtest;Sele ctMethod=cursor 2. We’ve added the FusionReactor JDBC Driver Wrapper text to the JDBC URL: jdbc:fusionreactor:wrapper:{ jdbc:macromeida:… URL } 3. We’ve add the FusionReactor Driver Wrapper class name: com.intergral.fusionreactor.jdbc.Wrapper 4. The username and password are unchanged. Since we’re using a builtin Macromedia driver, there’s no need to supply the ‘driver’ argument to the FusionReactor JDBC URL – CF will pre-load this driver for us. If we were using a third party driver, we would simply add the classname to the JDBC URL, like this: jdbc:fusionreactor:wrapper:{ jdbc:mysql:… URL } ;driver=com.some company.Driver When you submit this form, ColdFusion will load our driver and make sure it can access the wrapped database. If all goes well, you’ll see an ‘OK’ in the status column: If something goes wrong, you’ll get plenty of information to help you fix it. If FusionReactor can’t access the wrapped driver, it will give you a helpful message indicating where the problem lies. If the wrapped driver has problems accessing the database, FusionReactor will relay its message so you can fix the problem. Here’s an example of a problem – we got the name of the FusionReactor driver class wrong ….

Download Tutorial Using the FusionReactor JDBC Driver Wrapper.Pdf