Connecting to Oracle R3 (8.1.7), Oracle 9i

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

Setting	Description
CF Data Source Name	The data source name (DSN) used by ColdFusion MX 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 MX 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 (16-character limit) that ColdFusion MX 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.
Limit Connections	Specifies whether ColdFusion MX limits the number of database connections for the data source. If you enable this option, use the Restrict Connections to field to specify the maximum.
Restrict Connections to	Specifies the maximum number of database connections for the data source. To use this restriction, you must enable Limit Connections.
Maintain Connections	ColdFusion MX 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.
String Format	Enable this option if your application uses Unicode data in DBMS-specific Unicode datatypes such as National Character or nchar.
Max Pooled Statements	Enables reuse of prepared statements (that is, stored procedures and queries that use the `cfqueryparam` tag). Although you tune this setting based on your application, start by setting it to the sum of the following: Unique `cfquery` tags that use `cfqueryparam` Unique `cfstoredproc` tags
Timeout (min)	The maximum number of minutes after the data source connection is made that you want ColdFusion MX to cache a connection after it is used.
Interval (min)	The time (in minutes) 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 MX 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 not selected, ColdFusion MX 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 not selected, ColdFusion MX retrieves the amount specified in the Blob Buffer setting.
LongText Buffer	The default buffer size, used if Enable Long Text Retrieval(CLOB) is not selected. Default is 64000 bytes.
BLOB Buffer	The default buffer size, used if Enable binary large object retrieval (BLOB) is not selected. Default is 64000 bytes.
Allowed SQL	The SQL operations that can interact with the current data source.

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

Comments

No screen name said on Sep 17, 2003 at 2:09 PM :

I am getting NET8 error while connecting to oracle 8 via CF enterprise 6.1Connection verification failed for data source: ros_dev
[]java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error.
The root cause was that: java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error.

Stijn Dreezen (Marburg) said on Oct 8, 2003 at 12:54 AM :

It should be made very clear that you will not get blobs and clobs work without the expensive enterprise edition or the equally expensive datadirect JDBC driver for oracle databases.
Up til now (october 2003) macromedia is unable to give me a working third party jdbc driver example with reasonable cost (300$ or so).
Oh sure, they do their very best to hide this fact and refer to all kind of third party drivers, but if you try them and you get your facts straight and you discuss it in deep, they haven't been able to make one single example work.
So until we see a working example thread on the developers forum in the database threads, it should be very clear you will have to pay bigtime to make blobs and clobs work on oracle.

sdupre said on Oct 20, 2003 at 5:44 AM :

The Sero driver from Inet Software (www.inetsoftware.de) should do the trick.

$249 for 20 connections. Supports CLOBs (need additional URL param to get CLOBs > 4000 bytes - see release notes for driver).

The Oracle thin driver does not conform to the spec (it's not a CFMX issue). To implement this, we would require oracle-specific classes inside CFMX which is not correct for a Type 4 driver.

When Oracle implements CLOBs fully in their Thin driver, users will be able to INSERT/UPDATE clobs with CFMX with the thin driver and the cheaper version of CFMX. The release note for 52292 (known issues) states:

"The Oracle Thin Client will not work with CLOBS/BLOBS on CFMX. You need to use the Data Direct Oracle JDBC driver that ships with CFMX Enterprise to work with CLOBs/BLOBs on Oracle."

This really confuses the issue and implies you need Enterprise when this was not the intent of the note.

It should have been re-worded to say "Oracle doesn't implement full CLOB support in their Type 4 Thin driver as of the 6.1 release."

Stephen Dupre
Macromedia QA

leewc said on Jan 14, 2004 at 12:41 AM :

I am getting NET8 error while connecting to oracle 8 via CF enterprise 6.1.

Connection verification failed for data source: ed
[]java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error.
The root cause was that: java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error.

Does anyone have a solution to this?

nyteschayde said on Feb 3, 2004 at 1:36 PM :

I am getting the same problem with the net8 protocol error. Same as leewc and the first guy to post.

Coldguru said on Mar 11, 2004 at 11:00 AM :

I am getting the same error as leewc , please help.

Only Diff is i am trying to connet to Oracle 9i . Works fine with 8i.

[]java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error.
The root cause was that: java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error.

(windows XP Pro, Cfmx 6/6.1,IIS).

Please help. We are moving production 8i db to 9i , and i dont want this thing to stop that.

jrunrandy said on Apr 8, 2004 at 6:12 AM :

Updated drivers are available at http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_sqlserver_cpu.htm.

jfp said on May 28, 2004 at 11:32 AM :

If there are EXAMPLES I couldn't find them.

ASandstrom said on May 28, 2004 at 11:38 AM :

Macromedia doesn't include sample Oracle databases with ColdFusion. However, you may find the following article helpful.
http://www.macromedia.com/devnet/server_archive/articles/cf_best_practices_oracle.html

No screen name said on Jun 29, 2004 at 9:42 AM :

I installed the new drivers mentioned from http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_sqlserver_cpu.htm

The driver started working from the CF administrator module it, i.e it stopped throwing the "[Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error".

I then created a simple page which did a basic query on the source created above and tried outputting the resultset. That is when I got the "[Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error" on the page. I did stop and restart the service. Please advice.

gjarmiolowski said on Jul 13, 2004 at 2:57 PM :

Can you use the OCI driver for Oracle (type 2 driver) for BLOB?

I cannot get the provided datadirect driver to connect to an Oracle instance that requires encryption. The data source page in the admin module does not give any options in this regard yet I see that JRUN has an xml configuration file to do this. Is this possible with CFMX?

No screen name said on Jul 26, 2004 at 6:17 AM :

I'm trying to connect to an Oracle 8.0.3 database using Coldfusion MX 6 and it is not connecting. Do I need a specific JDBC driver to connect to older Oracle databases?

KW Developer said on Dec 30, 2004 at 5:42 AM :

I am trying to connect to Oracle 10G. Is this supported? You just mention 9i.

No screen name said on Jan 31, 2005 at 7:22 AM :

I am trying to qyery a table in an oracle 10g database, the table has 2 CLOB columns which contain data in both english and arabic fonts, the problem is that the query takes more than 2 minutes to execute and when it does it retrieves no data from the CLOB attributes, i modified the application servers setting to allow for unicode non-latin configured datasources as well as enabling the CLOB and BLOB retrieval, AND i increased the maximum buffer size for the CLOB and BLOB buffers.
i am pretty much out of tricks,
your help is most appreciated.

manuelg1972 said on Jun 19, 2006 at 12:23 PM :

The infamous net8 protocol error.

This is _usually_ caused when the password for a schema is about to
expire. SQL*Plus and other programs can handle that responses and
prompt you with a message to change your password, or whatever.

However the drivers for CFMX don't know what to do with that response
and throw this generic net8 protocol error.

- Adam
Taken from house of fusion...

zerointeractive said on Aug 21, 2007 at 1:12 AM :

I encounter this error every time I have a small amount of space in my Oracle8 tablespace.
Try to extend the tablespace dimension and try again.

It works for me.

Hope this helps,

Luigi

zerointeractive said on Sep 10, 2007 at 12:37 AM :

Another tip to let the error disappear:
I had a .cfm page with a cfquery using several cfqueryparam tags.
After a small update (I've changed only 1 column name) and re-deploy in production environment , let's boom and the Net8 Protocol error appeared again!
I've managed around the datasource settings in CFAdministrator and I've found that resizing the MAX POOLED STATEMENTS (i've set it to 5) will let the net8 error disappear.

Hope this helps,

Luigi BELLI


Contents > Configuring and Administering ColdFusion MX > Data Source Management > Connecting to Oracle R3 (8.1.7), Oracle 9i