Re: Oracle 11g Upgrade Unable to select from CLOB datatype
CF8 doesn't support Oracle 11G, so you may be out of luck getting any official resolution. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 5 November 2010 21:24, Wimbley, Noveta wrote: > > CF8 > > -Original Message- > From: James Holmes [mailto:james.hol...@gmail.com] > Sent: Friday, November 05, 2010 7:31 AM > To: cf-talk > Subject: Re: Oracle 11g Upgrade Unable to select from CLOB datatype > > > Which version of CF are you using? > > -- > WSS4CF - WS-Security framework for CF > http://wss4cf.riaforge.org/ > > > > On 5 November 2010 15:50, Noveta Wimbley wrote: >> >> We have just upgraded from Oracle 10g to 11g. Now we have an application >> that will not select from clob datatype column. >> >> We are getting the following error: >> >> Error Executing Database Query. >> [Macromedia][Oracle JDBC Driver]No more data available to read. >> >> The error occurred in E:\Collab\iweb\webapps\admin\Test\drivertest.cfm: line >> 1 >> >> 1 : >> 2 : select >> 3 : >> >> > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Oracle 11g Upgrade Unable to select from CLOB datatype
CF8 -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Friday, November 05, 2010 7:31 AM To: cf-talk Subject: Re: Oracle 11g Upgrade Unable to select from CLOB datatype Which version of CF are you using? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 5 November 2010 15:50, Noveta Wimbley wrote: > > We have just upgraded from Oracle 10g to 11g. Now we have an application that > will not select from clob datatype column. > > We are getting the following error: > > Error Executing Database Query. > [Macromedia][Oracle JDBC Driver]No more data available to read. > > The error occurred in E:\Collab\iweb\webapps\admin\Test\drivertest.cfm: line 1 > > 1 : > 2 : select > 3 : > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Upgrade Unable to select from CLOB datatype
Which version of CF are you using? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 5 November 2010 15:50, Noveta Wimbley wrote: > > We have just upgraded from Oracle 10g to 11g. Now we have an application that > will not select from clob datatype column. > > We are getting the following error: > > Error Executing Database Query. > [Macromedia][Oracle JDBC Driver]No more data available to read. > > The error occurred in E:\Collab\iweb\webapps\admin\Test\drivertest.cfm: line 1 > > 1 : > 2 : select > 3 : > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Oracle 11g Upgrade Unable to select from CLOB datatype
We have just upgraded from Oracle 10g to 11g. Now we have an application that will not select from clob datatype column. We are getting the following error: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]No more data available to read. The error occurred in E:\Collab\iweb\webapps\admin\Test\drivertest.cfm: line 1 1 : 2 : select 3 : ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Procedure won't talk to our ColdFusion code.
On 7/26/2010 4:26 PM, Maureen wrote: > Sounds more like a timing issue with the actual execution of the code > on the database. Can you check the success of the insert before > calling the stored proc? As noted in an earlier post, it was a commit issue. The insert in the was not being committed. And the stored procedure being called in the was waiting for it to be committed. Adding a to explicitly commit the insert allowed the process to work as desired. I've just never had to do that before. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Procedure won't talk to our ColdFusion code.
Sounds more like a timing issue with the actual execution of the code on the database. Can you check the success of the insert before calling the stored proc? On Mon, Jul 26, 2010 at 3:12 PM, Ian Skinner wrote: > At this time, the Insert is done with a simple call BEFORE > the call. That is the way the stored procedure was > created over a decade ago. For the first phase of this project, we are > only updating the application server level of this process. It waits > for a future phase to tackle the stored procedures in the database > level. And let me tell you that is a project we both desire and dr ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Procedure won't talk to our ColdFusion code.
On 7/26/2010 2:47 PM, Craigsell wrote: > If you are doing the insert inside the Oracle stored procedure, then you > have to commit inside the stored procedure. I have evolved into setting up > a general exception process so that if, for some reason, a stored procedure > fails, it can call a rollback and send some sort of a status message back to > the CFC or whatever called the stored proc. 11g should be no different. > > If you want some simple examples of that work on 10g and CF8, let me know > and I'll put something together and post it. > > Warren At this time, the Insert is done with a simple call BEFORE the call. That is the way the stored procedure was created over a decade ago. For the first phase of this project, we are only updating the application server level of this process. It waits for a future phase to tackle the stored procedures in the database level. And let me tell you that is a project we both desire and dread. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Procedure won't talk to our ColdFusion code.
If you are doing the insert inside the Oracle stored procedure, then you have to commit inside the stored procedure. I have evolved into setting up a general exception process so that if, for some reason, a stored procedure fails, it can call a rollback and send some sort of a status message back to the CFC or whatever called the stored proc. 11g should be no different. If you want some simple examples of that work on 10g and CF8, let me know and I'll put something together and post it. Warren ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Procedure won't talk to our ColdFusion code.
> Are you referring to the ColdFusion DataSource settings or something > more directly involving the JDBC drivers? I don't know offhand if the CF Administrator will let you control autocommit directly, or whether you need to edit the neo-datasource.xml file to enable autocommit. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Procedure won't talk to our ColdFusion code.
On 7/26/2010 8:37 AM, Dave Watts wrote: > I suspect this has to do with your database's default settings. You > can probably force autocommit in your JDBC settings, however. Are you referring to the ColdFusion DataSource settings or something more directly involving the JDBC drivers? We are using CF 9 Enterprise with its Oracle driver, if that changes anything? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Procedure won't talk to our ColdFusion code.
> Our stored procedure is now working. Our DBA determined that the call > was working, but the procedure was waiting, because the previous > INSERT block was not committed. But why would that be? > I've never had to explicity commit my INSERTS using > before. Is this something common? Is is something in the Database or > drivers or just Oracle 11g? I suspect this has to do with your database's default settings. You can probably force autocommit in your JDBC settings, however. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or on ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Procedure won't talk to our ColdFusion code.
More Information. Our stored procedure is now working.Our DBA determined that the call was working, but the procedure was waiting, because the previous INSERT block was not committed. But why would that be? I've never had to explicity commit my INSERTS using before. Is this something common? Is is something in the Database or drivers or just Oracle 11g? Placing a commit block around they resolved the issue. But I have never had to do that before. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
On 7/23/2010 5:30 PM, James Holmes wrote: > Which version of CF are you on? Oracle 11G isn't supported until CF9. > A) We are on CF 9.0 (not 9.0.1 yet). B) That's rather interesting as we had CF 8 talking to Oracle 11g for two years before we upgraded to CF 9 last month. Albeit, not using this stored procedure. But another piece of CFML code has been using another stored procedure for years. All the way back to CF 4.5 against a Oracle 7 system. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
http://www.adobe.com/products/coldfusion/coldfusion8/systemreqs/ "Oracle 8i R2-R3 8.1.7 Oracle 9i R1-R2 including RAC support Oracle 10g R1-R2 including RAC support" -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 24 July 2010 19:29, Matthew Williams wrote: > > Is this acknowledged anywhere on Adobe's site? I've not seen an issue > with the vast majority of the shared apps we host. > > > Matthew Williams > Geodesic GraFX > www.geodesicgrafx.com/blog > > On 7/23/2010 8:30 PM, James Holmes wrote: >> Which version of CF are you on? Oracle 11G isn't supported until CF9. >> >> -- >> WSS4CF - WS-Security framework for CF >> http://wss4cf.riaforge.org/ >> >> >> On 24 July 2010 05:06, Ian Skinner wrote: >>> We are attempting to execute a stored procedure with this piece of code. >>> >>> >> procedure="co_error.check_records" debug="yes"> >> cfsqltype="cf_sql_decimal" value="2010"> >>> >>> As you can see, it is a pretty small block. Executing >>> it returns this error. >>> >>> [Macromedia][Oracle JDBC Driver]Unhandled sql ty >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
Is this acknowledged anywhere on Adobe's site? I've not seen an issue with the vast majority of the shared apps we host. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog On 7/23/2010 8:30 PM, James Holmes wrote: > Which version of CF are you on? Oracle 11G isn't supported until CF9. > > -- > WSS4CF - WS-Security framework for CF > http://wss4cf.riaforge.org/ > > > On 24 July 2010 05:06, Ian Skinner wrote: >> We are attempting to execute a stored procedure with this piece of code. >> >> > procedure="co_error.check_records" debug="yes"> > cfsqltype="cf_sql_decimal" value="2010"> >> >> As you can see, it is a pretty small block. Executing >> it returns this error. >> >> [Macromedia][Oracle JDBC Driver]Unhandled sql ty > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
Which version of CF are you on? Oracle 11G isn't supported until CF9. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 24 July 2010 05:06, Ian Skinner wrote: > > We are attempting to execute a stored procedure with this piece of code. > > procedure="co_error.check_records" debug="yes"> cfsqltype="cf_sql_decimal" value="2010"> > > As you can see, it is a pretty small block. Executing > it returns this error. > > [Macromedia][Oracle JDBC Driver]Unhandled sql ty ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
On 7/23/2010 3:03 PM, Scott McAllister wrote: > Hi Ian, > > What happens if you change the cfsqltype attribute of the cfprocparam tag to > be cf_sql_numeric ? > > -Scott We tried numeric, float and decimal all with the same results. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335686 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
Hi Ian, What happens if you change the cfsqltype attribute of the cfprocparam tag to be cf_sql_numeric ? -Scott >We are attempting to execute a stored procedure with this piece of code. > >procedure="co_error.check_records" debug="yes"> cfsqltype="cf_sql_decimal" value="2010"> > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Oracle 11g Stored Proccedure won't talk to our ColdFusion code.
We are attempting to execute a stored procedure with this piece of code. As you can see, it is a pretty small block. Executing it returns this error. [Macromedia][Oracle JDBC Driver]Unhandled sql type The error occurred in D:\playground\warren\PpurComponents.cfc: line 49 Called from D:\playground\warren\ppur_file_import.cfm: line 53 Called from D:\playground\warren\PpurComponents.cfc: line 49 Called from D:\playground\warren\ppur_file_import.cfm: line 53 Here is what I hope is the relevant portion of a 1400 line stored procedure located in Oracle. We don't get to refactor the stored procedure until phase two of this project. PROCEDURE Check_records(p_year IN NUMBER) AS v_use_no NUMBER(8); v_error_code BINARY_INTEGER := 0; v_error_type VARCHAR2(20); ... This project is to replace a 15 year old Perl program to used to call this procedure with this code. open(SQL_OUTPUT, "sqlplus -S ops\$x/...@dev11ge \...@check_errors $year |") That executed this SQL file. * Run the error checking procedures */ SET pause off SET verify off SET TERMOUT ON SET FEEDBACK OFF SET document off SET serveroutput ON size 100 format word_wrapped WHENEVER SQLERROR EXIT 1 ROLLBACK WHENEVER OSERROR EXIT 1 ROLLBACK EXECUTE Co_error.Check_records(&1); show errors EXIT 0 Can anybody provide some insight on why this won't work form our CFML? TIA Ian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
Here's some similar code I cobbled together which tells you a bunch of info about the server. I don't have access to the Server Admin and was tired of annoying the server team when I (or they) forgot something. ColdFusion Information - click on struct for infomation Server Information Base Template Path = #GetBaseTemplatePath()# Mappings Data Sources Scheduled Tasks Driver Versions #drivername##driver.getMajorVersion()#.#driver.getMinorVersion()# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
> Yes, I know. Unfortunately our servers are locked down. We have to > rely on our server admins to copy over our files and they aren't too > happy when we try to sneak through something that isn't part of an > application . . . But you did give me the idea to send them the code so they can run it themselves. Thanks, Maureen! George ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320138 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
>You can check the version of you drivers yourself with a cfm file :) Yes, I know. Unfortunately our servers are locked down. We have to rely on our server admins to copy over our files and they aren't too happy when we try to sneak through something that isn't part of an application . . . Thanks, though. George ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320137 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
You can check the version of you drivers yourself with a cfm file :) ---> #drivername# is #driver.getMajorVersion() #.#driver.getMinorVersion()# Got that from a google search long ago. On Thu, Mar 5, 2009 at 08:47, george.e...@ssa.gov george.e...@ssa.gov wrote: > >>Hi - the macromedia.jar file that ships with cfmxe7 is not the most current. >>http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a > > Thanks for the link. I'm checking with our server admins to see if they have > already updated the DataDirect drivers. > >>Also have you tried Oracle's thin client? You can download it off >>http://www.oracle.com/ This will be specific to 11g. > > Right. We're saving that solution. Our standard is to use the DataDirect > drivers. We'll go down the updated DataDirect drivers path first before we > try Oracle's thin client drivers. > >>The character set is applied at the database level. Not sure if your >>DBAs want to change it for you, but that is also worth a shot. > > Yes. We are already exploring this one. The DBAs have agreed to change the > character set setting so we'll see what that does. It just seems strange to > me that with ColdFusion using UTF-8 and Oracle using UTF-8 we get these > non-standard characters popping up so we're going to change the setting in > Oracle to US7ASCII to see if that fixes the problem . . . > > Thanks for your input. > > George > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320132 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
>Hi - the macromedia.jar file that ships with cfmxe7 is not the most current. >http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a Thanks for the link. I'm checking with our server admins to see if they have already updated the DataDirect drivers. >Also have you tried Oracle's thin client? You can download it off >http://www.oracle.com/ This will be specific to 11g. Right. We're saving that solution. Our standard is to use the DataDirect drivers. We'll go down the updated DataDirect drivers path first before we try Oracle's thin client drivers. >The character set is applied at the database level. Not sure if your >DBAs want to change it for you, but that is also worth a shot. Yes. We are already exploring this one. The DBAs have agreed to change the character set setting so we'll see what that does. It just seems strange to me that with ColdFusion using UTF-8 and Oracle using UTF-8 we get these non-standard characters popping up so we're going to change the setting in Oracle to US7ASCII to see if that fixes the problem . . . Thanks for your input. George ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320131 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
Thanks for the heads up. I'm checking with our server admins to see if they have updated the DataDirect drivers. George >I can't answer your question since we are still on 10G but I would suggest >you check/update the drivers. We were running the drivers that came with >CF7 -- certain things in 10G wouldn't work at all. We are now running 3.50 >on CF7 and 3.6 on CF8. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320130 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
Hi - the macromedia.jar file that ships with cfmxe7 is not the most current. http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a Also have you tried Oracle's thin client? You can download it off http://www.oracle.com/ This will be specific to 11g. The character set is applied at the database level. Not sure if your DBAs want to change it for you, but that is also worth a shot. On Wed, Mar 4, 2009 at 13:24, Earl, George wrote: > > Our development environment was just upgraded from Oracle 10G to Oracle > 11G (which is not officially supported by ColdFusion, but it's not our > decision). We're on ColdFusion 7 Enterprise and we're using the supplied > Data Direct drivers. We are getting some unexpected non-standard special > characters spread through our output that is pulled from Oracle 11G > CLOBs\BLOBs that we were not getting with Oracle 10G. > > If we run this query: > > Select value from SYS.NLS_DATABASE_PARAMETERS where PARAMETER = > 'NLS_CHARACTERSET' > > to determine the character sets that are being used by Oracle we find: > > Oracle 10G - US7ASCII > > Oracle 11G - UTF8 > > We are accepting the ColdFusion 7 default use of UTF-8 in our > application and we do not override it anywhere in our application. > > Any ideas why we wouldn't get non-standard characters in our output with > Oracle 10G set up to use US7ASCII but we DO get these non-standard > characters with Oracle 11G set up to use UTF-8? > > Thanks! > > George > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320127 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
I can't answer your question since we are still on 10G but I would suggest you check/update the drivers. We were running the drivers that came with CF7 -- certain things in 10G wouldn't work at all. We are now running 3.50 on CF7 and 3.6 on CF8. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320123 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Oracle 11G CLOBs\BLOBs yielding non-standard characters with CF7
Our development environment was just upgraded from Oracle 10G to Oracle 11G (which is not officially supported by ColdFusion, but it's not our decision). We're on ColdFusion 7 Enterprise and we're using the supplied Data Direct drivers. We are getting some unexpected non-standard special characters spread through our output that is pulled from Oracle 11G CLOBs\BLOBs that we were not getting with Oracle 10G. If we run this query: Select value from SYS.NLS_DATABASE_PARAMETERS where PARAMETER = 'NLS_CHARACTERSET' to determine the character sets that are being used by Oracle we find: Oracle 10G - US7ASCII Oracle 11G - UTF8 We are accepting the ColdFusion 7 default use of UTF-8 in our application and we do not override it anywhere in our application. Any ideas why we wouldn't get non-standard characters in our output with Oracle 10G set up to use US7ASCII but we DO get these non-standard characters with Oracle 11G set up to use UTF-8? Thanks! George ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Oracle 11g
The ironic drawback is that the Oracle drivers don't support stored procedures which the DD drivers do. And we need that. The current delivered drivers support just 10g. On Tue, Oct 28, 2008 at 18:29, AJ Mercer <[EMAIL PROTECTED]> wrote: > you can do a JDBC connect then use the drivers from your Oracle client > > Here are a couple of blog posts to get your started >http://www.talkingtree.com/blog/index.cfm/2005/11/14/Oracle10gJDBCHowTo > > http://blog.sixsigns.com/2008/01/25/configure-the-jdbc-driver-for-oracle-on-coldfusion-8-standard-edition/ > > > > > On Tue, Oct 28, 2008 at 9:45 PM, Maureen Barger <[EMAIL PROTECTED]> wrote: > >> Hi - does anyone know of any plans to push out free DataDirect drivers >> (an updated macromedia.jar) in support of Oracle 11g? >> >> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Oracle 11g
you can do a JDBC connect then use the drivers from your Oracle client Here are a couple of blog posts to get your started http://www.talkingtree.com/blog/index.cfm/2005/11/14/Oracle10gJDBCHowTo http://blog.sixsigns.com/2008/01/25/configure-the-jdbc-driver-for-oracle-on-coldfusion-8-standard-edition/ On Tue, Oct 28, 2008 at 9:45 PM, Maureen Barger <[EMAIL PROTECTED]> wrote: > Hi - does anyone know of any plans to push out free DataDirect drivers > (an updated macromedia.jar) in support of Oracle 11g? > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Oracle 11g
Hi - does anyone know of any plans to push out free DataDirect drivers (an updated macromedia.jar) in support of Oracle 11g? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
