Maybe update to a new Oracle JDBC driver, and connect via the 'other' datasouce.
Does CF even support 10g? Mark On 2/14/07, Casey C Cook <[EMAIL PROTECTED]> wrote: > Im using an oracle datasource. > > macromedia.jdbc.oracle.OracleDriver is 3.50 > macromedia.jdbc.db2.DB2Driver is 3.50 > macromedia.jdbc.informix.InformixDriver is 3.50 > macromedia.jdbc.sequelink.SequeLinkDriver is 5.4 > macromedia.jdbc.sqlserver.SQLServerDriver is 3.50 > macromedia.jdbc.sybase.SybaseDriver is 3.50 > > Thanks, > CC > x56927 > > > -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > This is a PRIVATE message. If you are not the intended recipient, please > delete without copying and kindly advise us by e-mail of the mistake in > delivery. NOTE: Regardless of content, this e-mail shall not operate to > bind CSC to any order or other contract unless pursuant to explicit > written agreement or government initiative expressly permitting the use of > e-mail for such purpose. > -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > > > > "Mark Mandel" <[EMAIL PROTECTED]> > 02/12/2007 10:00 PM > Please respond to > cf-talk@houseoffusion.com > > > To > CF-Talk <cf-talk@houseoffusion.com> > cc > > Subject > Re: CF7 / oracle 10g migration woes > > > > > > > Casey - what driver are you using? > > Mark > > On 2/13/07, Casey C Cook <[EMAIL PROTECTED]> wrote: > > I have two scenario's, one we have figured out, one we havent. > > > > 1) Figured out: When using the cfstoredproc tag and doing a select query > > in a package/procedure which returns more than 46 columns, the CF 7 > server > > spins off into never never land. If you push it by hitting the URL > several > > times, you can crash the server. If you use cfquery everything works > fine, > > so our immediate solution was to re-write these into coldfusion > templates. > > Has anyone else seen this issue? > > > > test cases: > > cf6 and oracle 9 - all good > > cf6 and oracle 10g - I forget > > cf7 and oracle 9 - off to never never land > > cf7 and oracle 10g - off to never never land > > > > So we concluded, it was most likely the cf7 server and NOT the oracle > 10g. > > > > 2) Currently trying to figure out: when using the cflogin tag in CF6 > > everything works fine, in CF7 Im getting "String index out of range: > -1". > > The cflogin tag just doesnt work. Any ideas ? > > > > Server Product ColdFusion MX > > Version 7,0,2,142559 > > Edition Enterprise > > Operating System Windows 2003 > > OS Version 5.2 > > > > Thanks, > > Casey Cook > > > > > -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > This is a PRIVATE message. If you are not the intended recipient, please > > delete without copying and kindly advise us by e-mail of the mistake in > > delivery. NOTE: Regardless of content, this e-mail shall not operate to > > bind CSC to any order or other contract unless pursuant to explicit > > written agreement or government initiative expressly permitting the use > of > > e-mail for such purpose. > > > -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269729 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
