JSC402

Technical Requirements

Operating System Options

This class only supports Windows Operating Systems.

• Windows XP Service Pack 2 or above
• Windows Vista
• Windows 7

ColdFusion Application Server

• Download - You may need to register.
• System Requirements
• Select the 32 bit edition if you are using Access as the database. (Even if you are running a 64 bit OS, you must run the 32 bit edition to use Access

Installation

Choose the default options during the installation, with the following exceptions:

• Step 3, Install Type: 'Developer Edition'
• Step 4, Install Configuration: 'Server Configuration'
• Step 10, Configure Web Servers: choose 'Built-in Web Server'.
• When asked to enable RDS select Yes and set a password

If you have access to a networked or remote server with ColdFusion 8 or 9 and Microsoft Access, that will also work. In this case, you will need to be able to access ColdFusion Administrator to create Data Source names.

Instructions

1. Create a folder in the web root (e.g. C:\ColdFusion9\wwwroot) called "Webucator" and extract the class files zip to that folder.

ColdFusion Editor Options

• Adobe Dreamweaver CS3
  • Download (Recommended)
  • System Requirements
• Adobe Homesite
  • Download
  • System Requirements

Database Options

• Microsoft Access 2000 or later
• Microsoft SQL Server 2005 Express
  • Download
• MySQL 4.1 or later
  • Download
• Oracle 8i or later
  • Download - - Oracle Database 10g Express Edition
  • The file you want to download is Oracle Database 10g Express Edition (Western European) - OracleXE.exe.
  • You will need to register for a free account.
  • Run through the Installer accepting all the defaults. Make sure to write down your password.
  • Follow steps 1-3 of the Getting Started Guide available at the Oracle Web site

Browser Options for Windows

• Mozilla Firefox 2.0 or greater - Download
• Internet Explorer 6 or greater - Download
• Google Chrome - Download

Firebug for Firefox

• Get Firebug

Using Firebug with Ajax

We strongly recommend getting Firebug when taking any of our Ajax courses because you can:

• See the Ajax calls being made to the server and what parameters, if any, were passed.
• See the response from the server after the Ajax calls are made in either plain text, JSON, or XML accordingly.
• Inspect HTML elements
• Learn more...

Class Files

1. Download the class files.

Setup Instructions

1. Create a folder in the root of your C:\ColdFusion9\wwwroot directory called "Webucator" and extract the class files zip to that folder.

Databases

Using MySQL

There are MySQL database scripts in the ClassFiles/Setup directory. Open and execute them in your MySQL client software.

Using Access

There are Access databases in the ClassFiles/Setup directory. You must have Microsoft Access installed to use them for this class. Data Source Names

Create three data source names: "Northwind", "Presidents", "DragDrop" that map to the databases of the same names in c:\ColdFusion9\wwwroot\Webucator\ClassFiles.

Database Access in 64-bit Windows

The first option is to use MySQL instead of the Access files. Since this does not use ODBC.

To use the Access files with ODBC, if you do not have a 64-bit MS Office installation:

1. You need to have a 32-bit Java installation which would generally be in C:\Program Files (x86) and therefore you will also need a 32-bit tomcat installation
2. Set a JAVA_HOME environment variable as discussed in the setup instructions and do the same for CATALINA_HOME (It is generally better to use the 8.3 form of paths that would have spaces, as in: C:\Progra~2\Java\jdk1.6.0_20 in which the ~2 is there because C:\Progra~1 is going to be C:\Program Files).

• You can test if the path is correct when written that way by pasting into the address bar of Windows Explorer.
• Go to c:\windows\SysWOW64. Find and double-click odbcad32.exe - that opens the 32-bit ODBC administrator

Testing The Setup

1. In your browser navigate to http://localhost/Webucator/ClassFiles/MoreAjaxApps/Solutions/Presidents.cfm or http://localhost:8500/Webucator/ClassFiles/MoreAjaxApps/Solutions/Presidents.cfm if you chose to use the Buil-In web server during installation. You should see a table of the presidents.
2. Click once on the word "Washington" in the first row. It should become editable in a form field.
3. Modify the word (e.g, change it to "Washington2") and click the little edit icon next to it. It should blink and then show the new word.
4. Refresh the page. Your change should be shown.

FAQ

• If you choose to use the ColdFusion built-in web server as one of the options during the install (recommended unless already running Apache or IIS), you will need to use the port as specified on line 350 of the jrun.xml file (usually 3500 or 8500) that is located at "C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\jrun.xml". To test the setup, open the browser to http://localhost:8500/Webucator/... replacing "8500" with the appropriate port number.