ColdFusion MX : Connecting to Oracle R3 (8.1.7), Oracle 9i

Use the settings in the following table to connect ColdFusion to Oracle R3 (8.1.7), Oracle 9i data sources:


Setting	Description
CF Data Source Name	The data source name (DSN) used by ColdFusion to connect to the data source.
SID Name	The Oracle System Identifier that refers to the instance of the Oracle database software running on the server. 'ORCL' is the default.
Server	The name of the server that hosts the database that you want to use. If the database is local, enclose the word local in parentheses.
Port	The number of the TCP/IP port that the server monitors for connections.
Username	The user name that ColdFusion passes to the JDBC driver to connect to the data source if a ColdFusion application does not supply a user name-for example, in a `cfquery` tag.
Password	The password that ColdFusion passes to the JDBC driver to connect to the data source if a ColdFusion application does not supply a password-for example, in a `cfquery` tag.
Description	(Optional) A description for this connection.
Maintain Connections	ColdFusion establishes a connection to a data source for every operation that requires one. Enable this option to improve performance by caching the data source connection.
Timeout (min)	The maximum number of minutes after the data source connection is made that you want ColdFusion to cache a connection after it is used.
Interval (sec)	The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
Disable Connections	If selected, suspends all client connections.
Login Timeout (sec)	The number of seconds before ColdFusion times out the data source connection login attempt.
CLOB	Select to return the entire contents of any CLOB/Text columns in the database for this data source. If unchecked, ColdFusion retrieves the amount specified in the Long Text Buffer setting.
BLOB	Select to return the entire contents of any BLOB/Image columns in the database for this data source. If unchecked, ColdFusion retrieves the amount specified in the Blob Buffer setting.
LongText Buffer (chr)	The default buffer size, used if Enable Long Text Retrieval(CLOB) is not selected. Default is 65000 bytes.
BLOB Buffer (bytes)	The default buffer size, used if Enable binary large object retrieval (BLOB) is not selected. Default is 65000 bytes.
Allowed SQL	The SQL operations that can interact with the current data source.

Comments are no longer accepted for ColdFusion MX. ColdFusion 8 is the current version.

Comments

mermedia said on Jun 19, 2002 at 5:34 PM :

I do not see this driver available. I only see Oracle available. Can you tell me more info about the differences, or why i shud get this driver? I am currently having a lot of trouble trying to get CF connected to my Oracle 8 database. I keep getting this error message:

Connection verification failed for data source: testconnection
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.

mike_s said on Jun 21, 2002 at 12:50 PM :

Version numbers do not appear in the drop-down
Driver list, due to legibility concerns. The
"Oracle" driver connects to Oracle R3 (8.1.7)
and Oracle 9i data sources.

If you're still having trouble connecting to
your Oracle database, please visit:
http://www.macromedia.com/support/coldfusion/

Regards,

Michael Stillman
ColdFusion Documentation

pbagnato said on Jul 15, 2002 at 5:08 PM :

I tried and tried and tried to connect to an Oracle 7.3.4 database using the Native drivers in MX.

It doesn't work at all.

ODBC connects just fine.

Is there any support for 7.3.4 Oracle native drivers?

Kindest Regards,
Peter Bagnato

ofrayman said on Aug 26, 2002 at 8:02 PM :

In CF5 you had to edit a start script. Do I have to edit in MX version in order to establish a connection to the oracle server?

sohailalikhan said on Mar 9, 2003 at 8:41 AM :

I could not connect to Oracle9i with coldfusion mx coz driver is not displayed in the list. How to add it in the drivers list. There is no problem with odbc socket. When I enter data in arabic language garbage is getting stored in Oracle9i using odbc socket. Is this problem due to Oracle configuration or cos of non availablity of coldfusion's oralce9i drivers.

minimal11 said on Jul 24, 2003 at 2:35 AM :

We are experiencing performance problems with the Oracle driver in CF 5. From what I've read, there is a 'thin' driver, and the 'type 4' driver which provides significant performance improvements over the thin driver.

When adding a data source, the drop down menu offers only "Oracle" as a driver type - in the datasources folder both OracleThin.cfm and Oracle.cfm are present. How can you tell which driver is being used?

How can set CF to use the Oracle driver (we are running enterprise edition MX).
Thanks.

MXWebGuy said on Aug 19, 2003 at 9:36 AM :

I can create a DSN on the ColdFusion MX Admin page.
It connects and gives me the 'OK', pretty quickly too.
But, when I try to use the DSN in Dreamweaver MX and view
the database and its tables etc, it times out.
Can anyone comment on this?

askiolu said on Dec 15, 2003 at 8:41 AM :

I am running CFMX6.1 on a server but it would not show ORACLE in the datasource types. What could be the problem. Also, when I use oracle native ODBC driver for the DSN, it end up using MS Merant driver (a very shoody one!!) which has problem retrieving long data type. Can someone pls help!! Contact me on adedeji@olowe.com.

sridharreddy said on Dec 24, 2003 at 12:46 AM :

Iam trying to connnect to oracle from coldfusion 6.1.It gives the following error..when I create dsn and try to connect..
Connection verification failed for data source: ora_con
[]java.sql.SQLException: [Macromedia][Oracle JDBC Driver]No more data available to read.
The root cause was that: java.sql.SQLException: [Macromedia][Oracle JDBC Driver]No more data available to read.

jrunrandy said on Dec 29, 2003 at 6:22 AM :

In general, LiveDocs does not receive enough traffic to handle questions such as this. Try posting your issue to the online forums: http://webforums.macromedia.com/coldfusion/

In addition, check out the CF support center at http://www.macromedia.com/support/coldfusion/. In particular, you should look at TechNotes on Oracle. A quick search on Oracle and SQLException shows the following:
http://www.macromedia.com/support/coldfusion/ts/documents/oracle_thin_ds_fails.htm
http://www.macromedia.com/support/coldfusion/ts/documents/driver_class_space.htm

Current page: http://livedocs.adobe.com/coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS11.htm

Administering ColdFusion MX
Data Source Management