Using UDA with Macromedia
Contents
Required components
You will need to download the following components
- Macromedia
ColdFusion MX 7 (Delevoper Edition) - download
-
OpenLink jar file - one of these, appropriate to the selected JDK/JRE -
JDK/JRE/JVM 1.1 opljdbc.jar 1.2 or 1.3 opljdbc2.jar 1.4 or 1.5 opljdbc3.jar
Install Macromedia
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
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
Start Macromedia
/opt/coldfusionmx7/bin/coldfusion start
Browse to the following url to verify the Administrator application is running --
http://coldfision_server:8500/CFIDE/administrator
Install
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
/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
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