Re: Cold Fusion and Oracle Unsupported Data Conversion
On Thursday 02 Sep 2004 22:04 pm, Adrocknaphobia wrote: This is def a driver/cfmx issue as you will not see this error in any form in SQL*Plus. Do you still see the error with the updated drivers from the Updater ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
I'd found that out, too, and ended up adding error catching in the PL/SQL to always make sure that I opened the ref cursor and passed it back, even if it was empty. - Original Message - From: Adrocknaphobia ** this is a response to a post from 3/9/2004 which never seemed to be resolved ** Explanation of CFMX Oracle JDBC database error Unsupported Data Conversion This issue occurs when using RefCursors to return queries from oracle via a stored procedure. When you declare a RefCursor it is NULL until it is populated with the OPEN ... FOR syntax. If any sort of error or premature return from the stored procedure occurs, Oracle still passes the RefCursor to CFMX. CFMX cannot convert the NULL RefCursor to an empty query. Now, if oracle performed and OPEN...FOR on the cursor and no rows were returned, then the RefCursor is successfully passed back to CFMX as it is no longer considered NULL. This one can be a little tricky to debug, especially you have good exception handling. In my case I was catching and returning an error before it got to populate the RefCursor. But CFMX threw it's Unsupported Data Conversion before it threw the actual error. This is def a driver/cfmx issue as you will not see this error in any form in SQL*Plus. Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
Not Adrocknaphobia, but as far as we'er concerned Don't know - the updated drivers crash our whole system. :( - Original Message - From: Thomas Chiverton Do you still see the error with the updated drivers from the Updater ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
I'll post back with more information about drivers. I'm going to be running test against oracle's drivers, as well as the latest ones MM released with the updater. (I'm still struggling with a thread locking issues, on another system, that seem to be related to the DataDirect 3.2 drivers not dealing with Oracle deadlocks very well) -Adam - Original Message - From: Deanna Schneider [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 08:45:29 -0500 Subject: Re: Cold Fusion and Oracle Unsupported Data Conversion To: CF-Talk [EMAIL PROTECTED] Not Adrocknaphobia, but as far as we'er concerned Don't know - the updated drivers crash our whole system. :( - Original Message - From: Thomas Chiverton Do you still see the error with the updated drivers from the Updater ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
I'd be interested to hear how the Oracle drivers work for you. We had to roll back from the latest MM drivers. But, I don't think they've tried any of the Oracle ones. Are there new drivers with this latest release? It hasn't been installed here yet. - Original Message - From: Adrocknaphobia I'll post back with more information about drivers. I'm going to be running test against oracle's drivers, as well as the latest ones MM released with the updater. (I'm still struggling with a thread locking issues, on another system, that seem to be related to the DataDirect 3.2 drivers not dealing with Oracle deadlocks very well) -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
Yeah, according to Forta one of the major reasons they relased the 6.1 Updater was because they got some new drivers made for Blackstone and didnt want to make us wait for them. Previously the lastest dataDirect driver they released was 3.3, so I assume that the ones included with the 6.1 Updater are 3.4. NEway, I got one task in between me and deploying different drivers to our test servers. I'll let you know what I find. There is also a 3rd reason I'm testing other drivers... LOBs. We keep running into issues using BLOBs with CFMX. Currently I have java classes in place for each application to manage clobs, but I'd like to get it to work with stored procedures. -Adam - Original Message - From: Deanna Schneider [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 10:46:28 -0500 Subject: Re: Cold Fusion and Oracle Unsupported Data Conversion To: CF-Talk [EMAIL PROTECTED] I'd be interested to hear how the Oracle drivers work for you. We had to roll back from the latest MM drivers. But, I don't think they've tried any of the Oracle ones. Are there new drivers with this latest release? It hasn't been installed here yet. - Original Message - From: Adrocknaphobia I'll post back with more information about drivers. I'm going to be running test against oracle's drivers, as well as the latest ones MM released with the updater. (I'm still struggling with a thread locking issues, on another system, that seem to be related to the DataDirect 3.2 drivers not dealing with Oracle deadlocks very well) -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
On Fri, 3 Sep 2004 13:15:31 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: Yeah, according to Forta one of the major reasons they relased the 6.1 Updater was because they got some new drivers made for Blackstone and didnt want to make us wait for them. Previously the lastest dataDirect driver they released was 3.3, so I assume that the ones included with the 6.1 Updater are 3.4. NEway, I got one task in between me and deploying different drivers to our test servers. I'll let you know what I find. There is also a 3rd reason I'm testing other drivers... LOBs. We keep running into issues using BLOBs with CFMX. Currently I have java classes in place for each application to manage clobs, but I'd like to get it to work with stored procedures. The Updater is still using the 3.3 driver family, but just a later build (I *believe* it's build 48). We are actually still using the Updater 3 Plus Oracle drivers because all drivers released after that set have issues (removeOnExceptions in pre-Rollup releases and dropping client variables in the latest Updater Rollup). Since we've downgraded the drivers, we haven't had to re-boot our instances once for performance reasons. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
Dave which version of the Oracle JDBC drivers are you using? -Adam - Original Message - From: Dave Carabetta [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 13:23:19 -0400 Subject: Re: Cold Fusion and Oracle Unsupported Data Conversion To: CF-Talk [EMAIL PROTECTED] On Fri, 3 Sep 2004 13:15:31 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: Yeah, according to Forta one of the major reasons they relased the 6.1 Updater was because they got some new drivers made for Blackstone and didnt want to make us wait for them. Previously the lastest dataDirect driver they released was 3.3, so I assume that the ones included with the 6.1 Updater are 3.4. NEway, I got one task in between me and deploying different drivers to our test servers. I'll let you know what I find. There is also a 3rd reason I'm testing other drivers... LOBs. We keep running into issues using BLOBs with CFMX. Currently I have java classes in place for each application to manage clobs, but I'd like to get it to work with stored procedures. The Updater is still using the 3.3 driver family, but just a later build (I *believe* it's build 48). We are actually still using the Updater 3 Plus Oracle drivers because all drivers released after that set have issues (removeOnExceptions in pre-Rollup releases and dropping client variables in the latest Updater Rollup). Since we've downgraded the drivers, we haven't had to re-boot our instances once for performance reasons. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
On Fri, 3 Sep 2004 13:51:20 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: Dave which version of the Oracle JDBC drivers are you using? Using the script at the below URL, this is what I get: [Macromedia][Oracle JDBC Driver]Driver Version: 3.1.003921002406001721 Script: http://www.bpurcell.org/blog/index.cfm?mode=entryentry=988 Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
I think that script is refering to the dataDirect drivers, not actual Oracle drivers. Although I could be wrong, the dataDirect drivers are around version 3.x whereas Oracle drivers follow version of the database (ie 9.2, 10.1) they correspond to. -Adam - Original Message - From: Dave Carabetta [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 14:03:52 -0400 Subject: Re: Cold Fusion and Oracle Unsupported Data Conversion To: CF-Talk [EMAIL PROTECTED] On Fri, 3 Sep 2004 13:51:20 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: Dave which version of the Oracle JDBC drivers are you using? Using the script at the below URL, this is what I get: [Macromedia][Oracle JDBC Driver]Driver Version: 3.1.003921002406001721 Script: http://www.bpurcell.org/blog/index.cfm?mode=entryentry=988 Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Cold Fusion and Oracle Unsupported Data Conversion
** this is a response to a post from 3/9/2004 which never seemed to be resolved ** Explanation of CFMX Oracle JDBC database error Unsupported Data Conversion This issue occurs when using RefCursors to return queries from oracle via a stored procedure. When you declare a RefCursor it is NULL until it is populated with the OPEN ... FOR syntax. If any sort of error or premature return from the stored procedure occurs, Oracle still passes the RefCursor to CFMX. CFMX cannot convert the NULL RefCursor to an empty query. Now, if oracle performed and OPEN...FOR on the cursor and no rows were returned, then the RefCursor is successfully passed back to CFMX as it is no longer considered NULL. This one can be a little tricky to debug, especially you have good exception handling. In my case I was catching and returning an error before it got to populate the RefCursor. But CFMX threw it's Unsupported Data Conversion before it threw the actual error. This is def a driver/cfmx issue as you will not see this error in any form in SQL*Plus. Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]