?

Log in

No account? Create an account
coldfusion_mx
..::.:.:. ..: .........: .:::..:::.
January 2010
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31

boxing_cat [userpic]
Connection to ORACLE 10g database

This is a short description of how to connect ColdFusion MX 7 to Oracle database.

 

1.)  If Oracle already installed on the server, you have to find this file

oracle_root\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar


2.) Copy this file to the following folders

CFusionMX7_root\wwwroot\WEB-INF\lib

and also, but not necessary into

JRun4_root\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\lib


3.) Restart the ColdFusion MX server.

4.) In the ColdFusion Administrator create a new datasource.
 

5.) Choose a datasource name and select the driver option for Other.


6.) Specify the following parameters:

- Specify JDBC URL as follows: jdbc:oracle:thin:@[host]:1521:SID  

If you do not know your SID, check tnsnames.ora file in oraclexe_root\app\oracle\product\10.2.0\server\NETWORK\ADMIN to look up your SID

- Specify Driver Class as: oracle.jdbc.OracleDriver

- Driver Name: (It is optional. You can leave it empty or provide your custom name)

- Finally, specify your Username and Password 

Click Submit button. It should work if your ORACLE schema allows you to connect to the database. Make sure that your have sufficient privileges.