Using UDA with Macromedia ColdFusion MX 7 (Linux)

Contents






Required components

You will need to download the following components


Install Macromedia ColdFusion MX 7 (Delevoper Edition)

Execute the downloaded *.bin file -
./coldfusion-701-lin.bin

NOTE: You may need to set the execute permission on the *.bin file before it can be executed.

Accept the license agreement.

When prompted, select - Install type ->3- Developer edition

What kind of installation do you want? ->1- Server configuration

Is there already a server configuration of Macromedia ColdFusion MX 7 installed? ->2- No

Sub-component installation choose 4) Continue with installation

Select all default options from this point onwards.

Enter administrator password.

Enable RDS (required for Report Builder and DW Extensions) (Y/N) : N

The installation will now complete.

NOTE: This may take several minutes to complete.


Start Macromedia ColdFusion MX 7 (Delevoper Edition)

Start Macromedia ColdFusion MX 7 (Delevoper Edition) using the command --
/opt/coldfusionmx7/bin/coldfusion start

Browse to the following url to verify the Administrator application is running --
http://coldfision_server:8500/CFIDE/administrator


Install OpenLink jar files}}}

Copy the file chosen for your JDK/JVM/JRE --
opljdbc.jar
opljdbc2.jar
or
opljdbc3.jar

into the directory - /opt/coldfusionmx7/openlink/jars

NOTE: You will need to create this directory if it does not already exist.

Open the Administrator --
http://coldfision_server:8500/CFIDE/administrator

Select Server Settings -> Java and JVM}}

In the {{{ColdFusion Class Path field enter --
/opt/coldfusionmx7/openlink/jars

Select Submit Changes

You will be prompted to restart the server.

Restart ColdFusion --
/opt/coldfusionmx7/bin/coldfusion restart


Configure Data Sources

Open the Administrator --
http://coldfision_server:8500/CFIDE/administrator

Select Server Settings -> Data & Services

Select Data Sources

Enter a name for the Data Source - {{o32opljdbc1}}}

In the Driver drop down list box select - other

Select Add

Enter the JDBC URL --
jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa

Enter the Driver Class --
openlink.jdbc.Driver

Select Submit

The Datasources page will display showing the new data source.

Select the Verify icon to the left of the datasource name.

If the data source was created successflly then the Status field will display OK


You will need to repeat this for the following datasources --

Data Source Name Driver Class URL
o32opljdbc1 openlink.jdbc.Driver jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa
m32opljdbc1 openlink.jdbc.Driver jdbc:openlink://192.168.0.150:5000/SVT=SQLServer 2000/Database=Northwind/options=-H 192.168.0.150/UID=sa/PWD=sa
o32opljdbc2 openlink.jdbc2.Driver jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa
m32opljdbc2 openlink.jdbc2.Driver jdbc:openlink://192.168.0.150:5000/SVT=SQLServer 2000/Database=Northwind/options=-H 192.168.0.150/UID=sa/PWD=sa
o32opljdbc3 openlink.jdbc3.Driver jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa
m32opljdbc3 openlink.jdbc3.Driver jdbc:openlink://192.168.0.150:5000/SVT=SQLServer 2000/Database=Northwind/options=-H 192.168.0.150/UID=sa/PWD=sa

NOTE: You will need to edit the URLs accordingly.


Prepare the ColdFusion test page

Create the following file --
/opt/coldfusionmx7/wwwroot/opltest.cfm

to read -- 

<html>
  <head>
    <title>Hello World!!</title>
  </head>
  <body>
    <cfquery name = "query_o32opljdbc1" dataSource = "o32opljdbc1" dbtype = "query">
      select EmployeeID, FirstName, LastName, Title from Employees
    </cfquery>
    <cfquery name = "query_m32opljdbc1" dataSource = "m32opljdbc1" dbtype = "query">
      select EmployeeID, FirstName, LastName, Title from Employees
    </cfquery>
    <cfquery name = "query_o32opljdbc2" dataSource = "o32opljdbc2" dbtype = "query">
      select EmployeeID, FirstName, LastName, Title from Employees
    </cfquery>
    <cfquery name = "query_m32opljdbc2" dataSource = "m32opljdbc2" dbtype = "query">
      select EmployeeID, FirstName, LastName, Title from Employees
    </cfquery>
    <cfquery name = "query_o32opljdbc3" dataSource = "o32opljdbc3" dbtype = "query">
      select EmployeeID, FirstName, LastName, Title from Employees
    </cfquery>
    <cfquery name = "query_m32opljdbc3" dataSource = "m32opljdbc3" dbtype = "query">
      select EmployeeID, FirstName, LastName, Title from Employees
    </cfquery>

    <h1>OpenLink - ColdFusion MX 7 test</h1>

    <h2>Using: o32opljdbc1 - openlink.jdbc.Driver</h2>
    <table>
      <cfoutput query="query_o32opljdbc1">
        <tr>
          <td>#EmployeeID#</td>
          <td>#FirstName#</td>
          <td>#LastName#</td>
          <td>#Title#</td>
        </tr>
      </cfoutput>
    </table>

    <h2>Using: m32opljdbc1 - openlink.jdbc.Driver</h2>
    <table>
      <cfoutput query="query_m32opljdbc1">
        <tr>
          <td>#EmployeeID#</td>
          <td>#FirstName#</td>
          <td>#LastName#</td>
          <td>#Title#</td>
        </tr>
      </cfoutput>
    </table>

    <h2>Using: o32opljdbc2 - openlink.jdb2.Driver</h2>
    <table>
      <cfoutput query="query_o32opljdbc2">
        <tr>
          <td>#EmployeeID#</td>
          <td>#FirstName#</td>
          <td>#LastName#</td>
          <td>#Title#</td>
        </tr>
      </cfoutput>
    </table>

    <h2>Using: m32opljdbc2 - openlink.jdbc2.Driver</h2>
    <table>
      <cfoutput query="query_m32opljdbc2">
        <tr>
          <td>#EmployeeID#</td>
          <td>#FirstName#</td>
          <td>#LastName#</td>
          <td>#Title#</td>
        </tr>
      </cfoutput>
    </table>

    <h2>Using: o32opljdbc3 - openlink.jdbc3.Driver</h2>
    <table>
      <cfoutput query="query_o32opljdbc3">
        <tr>
          <td>#EmployeeID#</td>
          <td>#FirstName#</td>
          <td>#LastName#</td>
          <td>#Title#</td>
        </tr>
      </cfoutput>
    </table>

    <h2>Using: m32opljdbc3 - openlink.jdbc3.Driver</h2>
    <table>
      <cfoutput query="query_m32opljdbc3">
        <tr>
          <td>#EmployeeID#</td>
          <td>#FirstName#</td>
          <td>#LastName#</td>
          <td>#Title#</td>
        </tr>
      </cfoutput>
    </table>

  </body>
</html>


View the test page at the following URL --
http://coldfision_server:8500/CFIDE/opltest.cfm