Complete instructions for installing the CRM Application can be found in Chapter IV-4 of Reality ColdFusion MX J2EE Integration.  

Database: 

The CRM application uses a SQL Server database. There is a sql script included in the distribution that will create an empty database for your use. It has the initial values (such as order statuses) and one admin user with the username and password 'admin'/'admin'. The file is Install2.sql. In SQL Server, create a database called 'crm' and use QueryAnalyzer to open and run the sql script.

Then create a datasource called CRMSQL in the ColdFusion Administrator.

CFML:

Copy all of the pages in the .zip file under wwwroot into the wwwroot of your Cold Fusion application. The  files include all of the application pages, including CFCs which interact with the Enterprise Java Beans in this application. 

ColdFusion Server:

ColdFusion needs access to classes dealing with Weblogic and the EJB interfaces. Find weblogic.jar (included with a download of Weblogic) and copy in the server library CFusionMX/wwwroot/WEB-INF/lib. Then, copy the remote interface .class files from the EJBs (all those with Remote or HomeRemote in the name) into CFusionMX/wwwroot/WEB-INF/classes. Keep the correct folder structure under this directory--so com/telepro/crm/contact for the two contact classes, etc.

Weblogic:

Once you have installed the Weblogic server (a demo version is available on the www.bea.com website). Use the Weblogic administrator to set up a Connection Pool called crmPool which points to the crm database. Then set up a Tx Data Source which points at this pool called crmTxPool. You may also need to modify some of the CFCs to point to your weblogic installation (the code comes ready to run off of a local installation of the Weblogic server). 

EJB:

There are two sets of files needed here--the .class files for the EJBs and the .xml files under META-INF which are used for deployment. Use the Java jar utility to jar up all these files (note that the .java source are also included for your review). Call the file crm.jar. Use the Weblogic administration console to deploy the jar (under Deployments/EJB/Configure a New EJB). Make sure that your SQL database is installed and running, and that the datasources have been correctly installed. If you change the name of the datasources or pools, you will need to update the .xml files before jarring and deploying.

This should be all the installation you need.  

Bonnie Plottner
bplottner@yahoo.com