CF 9 Unable to connect to Oracle 8 database

[Guest]

Trying to upgrade from CF7 to CF9 - in my testing enviroment all my applications attempting to connect Oracle 8 fail with the following message

[Macromedia][Oracle JDBC Driver][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01401: inserted value too large for column ORA-06512: at line 2 ORA-02063: preceding 3 lines from {Var I can't post on the internet}

So I create a test page that just has a select statement to a view (the only thing this user has credentials to do):

<cftry>

<cfquery name="test" datasource="Oracle8_database">

SELECT DISTINCT name

FROM VIEW

</cfquery>

<cfcatch type = "Database">

<H3>You've Thrown a Database <B>Error</B></H3>

<cfoutput>

<P>#cfcatch.message#</P>

<P>Caught an exception, type = #cfcatch.type# </P>

<P>The contents of the tag stack are:</P>

<cfloop index = i from = 1 to = #ArrayLen(cfcatch.tagContext)#>

    <cfset sCurrent = #cfcatch.tagContext#>

    <BR>#i# #sCurrent["ID"]#

    (#sCurrent["LINE"]#,#sCurrent["COLUMN"]#)

    #sCurrent["TEMPLATE"]#

</cfloop>

</cfoutput>

</cfcatch>

</cftry>

<cfdump var="#test#" />

I get the following information:

You've Thrown a Database Error

Error Executing Database Query.

Caught an exception, type = Database

Message: Error Executing Database Query.

The contents of the tag stack are:

1 CFQUERY (2,0) /Users/tspangle/Documents/wholesale/drtt/exdocreq/travistest.cfm

Reviewing system reqs, http://www.adobe.com/products/coldfusion/systemreqs/, this should be  a supported database.  I dont' see anyone else on the web having this problem and I'm unable to extract anymore details form the exception.  Is anyone able to provide some guidence or clues on what else I can do? Right now the plan is to move the data to a known working SQL instance. Since it seems like this is a CF9 problem. 

[JR__Bob__Dobbs]

Disclaimer: I do not have very much experience with Oracle databases.

That being said, I beleive that ORA-* messages are built in Oracle error messages.  This would *seem* to point to an Oracle problem.

Is there any information logged in Oracle, such as in a trace file, that can shed some light on the problem?

Can you connect using the same login information with an application other than ColdFusion?

What does a trace of activity on the Oracle database show?  Is the connection successful?

[Guest]

thanks for the info.  I'll write to the owners of the database and confirm if there is anything in the logs.

I can connect to the database using Oracles SQL Developer 1.21 tool.  The current version does not have the outdated JDBC drivers that connect to the DB.  which is originally why I thought it was a CF9 problem, but I seem to be the only one with this issue.

[Guest]

per http://www.adobe.com/products/coldfusion/systemreqs they support Oracle 8i R2-R3. By querying v$version I get Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production.  So it looks like my specific version is unsupported.  Thanks for all the help.