JDBCAppServerColdfusiuonLinuxUsing UDA with Macromedia ColdFusion MX 7 (Linux) 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 - <tgroup><thead /><tbody> <row /> <row><entry> 1.1 </entry><entry> <ulink url="http://download.openlinksw.com">opljdbc.jar</ulink> </entry></row> <row><entry> 1.2 or 1.3 </entry><entry> <ulink url="http://download.openlinksw.com">opljdbc2.jar</ulink> </entry></row> <row><entry> 1.4 or 1.5 </entry><entry> <ulink url="http://download.openlinksw.com">opljdbc3.jar</ulink> </entry></row> </tbody></tgroup></table> </listitem> </itemizedlist><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h3">Install Macromedia ColdFusion MX 7 (Delevoper Edition)</bridgehead> <para>Execute the downloaded *.bin file - <computeroutput>./coldfusion-701-lin.bin</computeroutput></para><para>NOTE: You may need to set the execute permission on the *.bin file before it can be executed.</para><para>Accept the license agreement.</para><para>When prompted, select - <computeroutput>Install type ->3- Developer edition</computeroutput></para><para>What kind of installation do you want? <computeroutput>->1- Server configuration</computeroutput></para><para>Is there already a server configuration of Macromedia ColdFusion MX 7 installed? <computeroutput>->2- No</computeroutput></para><para>Sub-component installation choose <computeroutput>4) Continue with installation</computeroutput></para><para>Select all default options from this point onwards.</para><para>Enter administrator password.</para><para>Enable RDS (required for Report Builder and DW Extensions) (Y/N) <computeroutput>: N</computeroutput></para><para>The installation will now complete.</para><para>NOTE: This may take several minutes to complete.</para><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h3">Start Macromedia ColdFusion MX 7 (Delevoper Edition)</bridgehead> <para>Start Macromedia ColdFusion MX 7 (Delevoper Edition) using the command -- <computeroutput>/opt/coldfusionmx7/bin/coldfusion start</computeroutput></para><para>Browse to the following url to verify the Administrator application is running -- <computeroutput>http://coldfision_server:8500/CFIDE/administrator</computeroutput></para><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h3">Install OpenLink jar files}}}</bridgehead> <para>Copy the file chosen for your JDK/JVM/JRE -- <computeroutput>opljdbc.jaropljdbc2.jaroropljdbc3.jar</computeroutput></para><para>into the directory - <computeroutput>/opt/coldfusionmx7/openlink/jars</computeroutput></para><para>NOTE: You will need to create this directory if it does not already exist.</para><para>Open the Administrator -- <computeroutput>http://coldfision_server:8500/CFIDE/administrator</computeroutput></para><para>Select <computeroutput>Server Settings -> Java and JVM}}In the {{{ColdFusion Class Path</computeroutput> field enter -- <computeroutput>/opt/coldfusionmx7/openlink/jars</computeroutput></para><para>Select <computeroutput>Submit Changes</computeroutput></para><para>You will be prompted to restart the server.</para><para>Restart ColdFusion -- <computeroutput>/opt/coldfusionmx7/bin/coldfusion restart</computeroutput></para><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h3">Configure Data Sources</bridgehead> <para>Open the Administrator -- <computeroutput>http://coldfision_server:8500/CFIDE/administrator</computeroutput></para><para>Select <computeroutput>Server Settings -> Data & Services</computeroutput></para><para>Select <computeroutput>Data Sources</computeroutput></para><para>Enter a name for the Data Source - {{o32opljdbc1}}}</para><para>In the <computeroutput>Driver</computeroutput> drop down list box select - <computeroutput>other</computeroutput></para><para>Select <computeroutput>Add</computeroutput></para><para>Enter the <computeroutput>JDBC URL</computeroutput> -- <computeroutput>jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa</computeroutput></para><para>Enter the <computeroutput>Driver Class</computeroutput> -- <computeroutput>openlink.jdbc.Driver</computeroutput></para><para>Select <computeroutput>Submit</computeroutput></para><para>The <computeroutput>Datasources</computeroutput> page will display showing the new data source.</para><para>Select the <computeroutput>Verify</computeroutput> icon to the left of the datasource name.</para><para>If the data source was created successflly then the <computeroutput>Status</computeroutput> field will display <computeroutput>OK</computeroutput></para><para> You will need to repeat this for the following datasources -- </para><table><title /><tgroup><thead /><tbody> <row /> <row><entry> o32opljdbc1 </entry><entry> openlink.jdbc.Driver </entry><entry> <computeroutput>jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa</computeroutput> </entry></row> <row><entry> m32opljdbc1 </entry><entry> openlink.jdbc.Driver </entry><entry> <computeroutput>jdbc:openlink://192.168.0.150:5000/SVT=SQLServer 2000/Database=Northwind/options=-H 192.168.0.150/UID=sa/PWD=sa</computeroutput> </entry></row> <row><entry> o32opljdbc2 </entry><entry> openlink.jdbc2.Driver </entry><entry> <computeroutput>jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa</computeroutput> </entry></row> <row><entry> m32opljdbc2 </entry><entry> openlink.jdbc2.Driver </entry><entry> <computeroutput>jdbc:openlink://192.168.0.150:5000/SVT=SQLServer 2000/Database=Northwind/options=-H 192.168.0.150/UID=sa/PWD=sa</computeroutput> </entry></row> <row><entry> o32opljdbc3 </entry><entry> openlink.jdbc3.Driver </entry><entry> <computeroutput>jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa</computeroutput> </entry></row> <row><entry> m32opljdbc3 </entry><entry> openlink.jdbc3.Driver </entry><entry> <computeroutput>jdbc:openlink://192.168.0.150:5000/SVT=SQLServer 2000/Database=Northwind/options=-H 192.168.0.150/UID=sa/PWD=sa</computeroutput> </entry></row><entry /><entry /><entry /> </tbody></tgroup></table> <para>NOTE: You will need to edit the URLs accordingly.</para><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h3">Prepare the ColdFusion test page</bridgehead> <para>Create the following file -- <computeroutput>/opt/coldfusionmx7/wwwroot/opltest.cfm</computeroutput></para><para>to read -- </para><programlisting><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> </programlisting><para> View the test page at the following URL -- <computeroutput>http://coldfision_server:8500/CFIDE/opltest.cfm</computeroutput> </para></section></docbook>