CF 9 Unable to connect to Oracle 8 database
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.
AdChoices