Java classes needed to connect to Oracle for ColdFusion
In the server settings, Java and JVM,, Cold fusion classpath you need to add the location of your oracle class files.
For oracle 9.2 it was: e:\oracle\ora92\jdbc\lib\classes12.zip
For oracle 10.2 it was: E:\oracle\product\10.2.0\client_1\jdbc\lib\classes12.zip
To use the macromedia, it was: C:\CFusionMX7\lib\macromedia_drivers.jar