On Saturday, Dec 28, 2002, at 19:04 US/Pacific, Li Chunshen ((Don))
wrote:
> The one that came with CFMX, to use OCI native drivers
> for Oracle 8i I need to read some docs, do you know
> any good one other than that which comes with it?
The only docs I know about are the ones on Oracle Tech Net that explain
how to install the drivers. You need to add the libraries to the path
and then you set up the driver in CFMX like this:
JDBC URL: jdbc:oracle:oci:@<SID>.<domain>
Driver Class: oracle.jdbc.OracleDriver
Driver Name: Oracle 9i OCI Client (note: this is only a comment!)
You need to ensure the SID is set up correctly. The following setup
notes may help you (taken from my team's server setup doc):
Steps to setup DSN with Oracle OCI driver
1. Install Oracle Client in the server where the CF/MX Server is
running (ask the DBAs).
2. Ensure that you have the right version of Oracle OCI driver is
installed, say in the directory /fs0/app/oracle/product/9.2/lib or
/fs0/app/oracle/product/9.2/lib32 for the 32-bit libraries.
3. Ensure that the CF/MX server start up file
/data/www/appserver/cfusionmx/bin (or start_cfmx in
/data/www/appserver/jrun/bin) has the following shell parameters
defined with the following path information
Note: Modify this with the right path for oracle in your server
(and it may be lib32 not lib):
PATH=$PATH:/bin:/sbin:/usr/bin:/usr/sbin:/fs0/app/oracle/product/9.2/bin
LD_LIBRARY_PATH="$CF_DIR/lib:$CF_DIR/lib/_solaris/bin:/fs0/app/oracle/
product/9.2/lib"
TNS_ADMIN=/fs0/app/oracle/product/9.2/network/admin
4. Ensure that the TNS netadmin file,
/fs0/app/oracle/product/9.2/network/admin/tnsnames.ora has the TNS name
defined for the oracle instance you are trying to associate with the
data source name you intend to create in the format:
<TNSNAME>.MACROMEDIA.COM = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)
(HOST = <DBSERVER_NAME>.macromedia.com)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME = <ORACLE_SID>)))
5. Once all the above things are in place, create Data Source thru
CF/MX Admin screen - see the table above.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
