Sean do you happen to know off hand if the OCI drivers in 8i support the query timeout option? I noticed the JDBC version with CFMX does not.
Stace -----Original Message----- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 1:17 AM To: CF-Talk Subject: Re: CFMX doesn't seem to like Oracle8 CLOB data 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
