%META:TOPICPARENT{name="InstallConfigJDBC"}% = Using UDA with Macromedia ColdFusion MX 7 (Linux) = %TOC% == Required components == You will need to download the following components * Macromedia ColdFusion MX 7 (Developer Edition) - [[http://www.macromedia.com|download]] * OpenLink jar file - one of these, appropriate to the selected JDK/JRE/JVM - | **JDK/JRE/JVM** | **OpenLink JDBC Driver Filename** | **OpenLink JDBC Driver Classname** | | 1.1 | opljdbc.jar | openlink.jdbc.Driver | | 1.2 or 1.3 | opljdbc2.jar | openlink.jdbc2.Driver | | 1.4 or 1.5 | opljdbc3.jar | openlink.jdbc3.Driver | | 1.6 | opljdbc4.jar | openlink.jdbc4.Driver | | 1.7 | opljdbc4_1.jar | openlink.jdbc4.Driver | | 1.8 | opljdbc4_2.jar | openlink.jdbc4.Driver | //**Note:** You should only have one of the above JDBC Drivers in the {{{CLASSPATH}}} at any time. It is usually best to use the latest driver supported by the active JVM.// == Install Macromedia ColdFusion MX 7 (Developer 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. == Start Macromedia ColdFusion MX 7 (Developer Edition) == # Start Macromedia ColdFusion MX 7 (Developer Edition) using the command -- {{{ /opt/coldfusionmx7/bin/coldfusion start }}} # Browse to the following url to verify the Administrator application is running -- {{{ http://coldfusion_server:8500/CFIDE/administrator }}} == Install OpenLink jar files == # Copy the {{{.jar}}} file chosen for your JDK/JVM/JRE 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://coldfusion_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://coldfusion_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 successfully then the Status field will display OK. Repeat the above process for each datasource, editing the URLs as appropriate for your environment -- | *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}}} | |||| == Prepare the ColdFusion test page == # Create the following file -- {{{ /opt/coldfusionmx7/wwwroot/opltest.cfm }}} to read -- {{{ Hello World!! select EmployeeID, FirstName, LastName, Title from Employees select EmployeeID, FirstName, LastName, Title from Employees select EmployeeID, FirstName, LastName, Title from Employees select EmployeeID, FirstName, LastName, Title from Employees select EmployeeID, FirstName, LastName, Title from Employees select EmployeeID, FirstName, LastName, Title from Employees

OpenLink - ColdFusion MX 7 test

Using: o32opljdbc1 - openlink.jdbc.Driver

#EmployeeID# #FirstName# #LastName# #Title#

Using: m32opljdbc1 - openlink.jdbc.Driver

#EmployeeID# #FirstName# #LastName# #Title#

Using: o32opljdbc2 - openlink.jdb2.Driver

#EmployeeID# #FirstName# #LastName# #Title#

Using: m32opljdbc2 - openlink.jdbc2.Driver

#EmployeeID# #FirstName# #LastName# #Title#

Using: o32opljdbc3 - openlink.jdbc3.Driver

#EmployeeID# #FirstName# #LastName# #Title#

Using: m32opljdbc3 - openlink.jdbc3.Driver

#EmployeeID# #FirstName# #LastName# #Title#
}}} # View the test page at the following URL -- {{{ http://coldfusion_server:8500/CFIDE/opltest.cfm }}}