Re: Oracle and Cold Fusion
Have you tried using GenericCursorType for your cursor type? That works for me. (I can give you a sample stored proc that's working for me, if that would be helpful.) - Original Message - From: Richard Crawford [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 01, 2004 6:38 PM Subject: Oracle and Cold Fusion Still having issues. Here is the Stored Procedure in question: == CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; fetch studentInfo into sFirst, sLast, sOrient; close studentInfo; end; / == And here is where it is called in my Cold Fusion page: == cfstoredproc datasource=DLCampus procedure=dlc_sp_getStudentInfo cfprocparam type=in value=#cookieID# cfsqltype=cf_sql_number cfprocresult name=getName /cfstoredproc == In the database, the table tblStudentInfo is set up as this: == sID number sFirst varchar2(50) sLast varchar2(50) sOrient char(1) == When I execute the stored procedure by going to the CF page in a browser, I get the following error: == Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. == I'm still at a loss, and I can't see what else I can do.Anyone got any suggestions? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
On Tuesday 02 Mar 2004 13:29 pm, Deanna Schneider wrote: Have you tried using GenericCursorType for your cursor type? That works for We do something like ref_cursor is REF CURSOR and return ref_cursor type. -- 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]
Re: Oracle and Cold Fusion
Deanna Schneider wrote: Have you tried using GenericCursorType for your cursor type? That works for me. (I can give you a sample stored proc that's working for me, if that would be helpful.) I'd appreciate that.I tried using GenericCursorType, and the SP would not compile, throwing this error: === PLS-00201: identifier 'GENERICCURSORTYPE' must be declared === Here is how I tried to implement it: === CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT GenericCursorType ) === -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Rob wrote: Did you figure out what datatype it is having problems with? i.e. only selecting one field at a time. Can it get just an int ok? All of the datatypes seem to match up just fine.I've gone out of my way to make them all match.If I remove the refcursor from the procedure call, then it gives an error telling me that the procresult is not defined. I mean you are selecting varchar2 and char in your refcursor have you just tried one or the other to see if it has a problem with just one of those datatypes - it's probably a conversion between what the drive says is a query and what cf thinks is a query, but I was hoping the Unsupported data conversion was refering to one of the column types. Hm.I tried with varchar2(50) at each point, and with char(50) at each point.Both gave me the same error. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
== And here is where it is called in my Cold Fusion page: == cfstoredproc datasource=DLCampus procedure=dlc_sp_getStudentInfo cfprocparam type=in value=#cookieID# cfsqltype=cf_sql_number cfprocresult name=getName /cfstoredproc == One thing I noticed is your calling code referenced the procedure directly.I think you need to create a package spec and have the cfstoredproc point to the name of the spec.In the header is where you create a ref cursor and you don't need the return type if the ref cursor is unrestrictive type. CREATE OR REPLACE PACKAGE pkg_studentInfo AS TYPE studentInfo REF CURSOR; PROCEDURE dlc_sp_getStudentInfo( studentID IN number, arg_cursor OUT types.studentInfo ); END pkg_studentInfo; = THEN YOU GO ON AND CREATE THE PACKAGE BODY WHICH INCLUDES THE dlc_sp_getStudentInfo PROCEDURE. = Nick Han [EMAIL PROTECTED] 03/02/04 10:10AM Rob wrote: Did you figure out what datatype it is having problems with? i.e. only selecting one field at a time. Can it get just an int ok? All of the datatypes seem to match up just fine.I've gone out of my way to make them all match.If I remove the refcursor from the procedure call, then it gives an error telling me that the procresult is not defined. I mean you are selecting varchar2 and char in your refcursor have you just tried one or the other to see if it has a problem with just one of those datatypes - it's probably a conversion between what the drive says is a query and what cf thinks is a query, but I was hoping the Unsupported data conversion was refering to one of the column types. Hm.I tried with varchar2(50) at each point, and with char(50) at each point.Both gave me the same error. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Oracle and Cold Fusion
Still having issues. Here is the Stored Procedure in question: == CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; fetch studentInfo into sFirst, sLast, sOrient; close studentInfo; end; / == And here is where it is called in my Cold Fusion page: == cfstoredproc datasource=DLCampus procedure=dlc_sp_getStudentInfo cfprocparam type=in value=#cookieID# cfsqltype=cf_sql_number cfprocresult name=getName /cfstoredproc == In the database, the table tblStudentInfo is set up as this: == sID number sFirst varchar2(50) sLast varchar2(50) sOrient char(1) == When I execute the stored procedure by going to the CF page in a browser, I get the following error: == Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. == I'm still at a loss, and I can't see what else I can do.Anyone got any suggestions? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Did you figure out what datatype it is having problems with? i.e. only selecting one field at a time. Can it get just an int ok? On Mon, 2004-03-01 at 16:38, Richard Crawford wrote: Still having issues. Here is the Stored Procedure in question: == CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; fetch studentInfo into sFirst, sLast, sOrient; close studentInfo; end; / == And here is where it is called in my Cold Fusion page: == cfstoredproc datasource=DLCampus procedure=dlc_sp_getStudentInfo cfprocparam type=in value=#cookieID# cfsqltype=cf_sql_number cfprocresult name=getName /cfstoredproc == In the database, the table tblStudentInfo is set up as this: == sID number sFirst varchar2(50) sLast varchar2(50) sOrient char(1) == When I execute the stored procedure by going to the CF page in a browser, I get the following error: == Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. == I'm still at a loss, and I can't see what else I can do.Anyone got any suggestions? -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Rob wrote: Did you figure out what datatype it is having problems with? i.e. only selecting one field at a time. Can it get just an int ok? All of the datatypes seem to match up just fine.I've gone out of my way to make them all match.If I remove the refcursor from the procedure call, then it gives an error telling me that the procresult is not defined. On Mon, 2004-03-01 at 16:38, Richard Crawford wrote: Still having issues. Here is the Stored Procedure in question: == CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; fetch studentInfo into sFirst, sLast, sOrient; close studentInfo; end; / == And here is where it is called in my Cold Fusion page: == cfstoredproc datasource=DLCampus procedure=dlc_sp_getStudentInfo cfprocparam type=in value=#cookieID# cfsqltype=cf_sql_number cfprocresult name=getName /cfstoredproc == In the database, the table tblStudentInfo is set up as this: == sID number sFirst varchar2(50) sLast varchar2(50) sOrient char(1) == When I execute the stored procedure by going to the CF page in a browser, I get the following error: == Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. == I'm still at a loss, and I can't see what else I can do.Anyone got any suggestions? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Did you figure out what datatype it is having problems with? i.e. only selecting one field at a time. Can it get just an int ok? All of the datatypes seem to match up just fine.I've gone out of my way to make them all match.If I remove the refcursor from the procedure call, then it gives an error telling me that the procresult is not defined. I mean you are selecting varchar2 and char in your refcursor have you just tried one or the other to see if it has a problem with just one of those datatypes - it's probably a conversion between what the drive says is a query and what cf thinks is a query, but I was hoping the Unsupported data conversion was refering to one of the column types. -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Donavan, I would have contacted you directly, but you didn't include your email address and I'm not gonna call ya long distance on my employer's nickel. We use Oracle with Cold Fusion all the time. No problems with stability, but there are some problems with using clobs. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle and Cold Fusion
We also are using Oracle 8i and CF4.5. The To_Char issue is still there but otherwise, everything seems to work flawlessly. -- KNOCK ON MY WOODEN DESK -- Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 8:03 PM To: CF-Talk Subject: Re: Oracle and Cold Fusion We use Oracle 8 8i here with a tremendous amount of success. We've had one issue - that is that our Oracle sits on an IBM box and as a result, I have problems with number fields. I can write fine, but when I read back out using the Native Drivers, number fields come back in EPIDIC, so I have to do a ToChar on them. Otherwise, I can use ODBC without any problems. Now, that's been with 4.01. We're just about ready to load up 4.51, so we'll see what happens then. Oracle on IBM CF 4.01 on NT4.0 SP 5 Native Drivers ODBC Hope this helps, Dave - Original Message - From: Donovan Rittenbach [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 04, 2000 6:57 PM Subject: Oracle and Cold Fusion Is anybody out there integrating Oracle with Cold Fusion? What has been your experience? We are hearing of troubles with application stability with CF from one of our MSPs and have a large job for a prominent printing company we will need help with. Anyhow, we want to migrate from MySQL to Oracle 9i and want to know if there would be any troubles with that. Please contact me directly, if at all possible. Donovan -- Donovan Rittenbach, M.A. ph: 415-331-9110 ext. 402 fx: 415-893-1128 icq: 36547420 Neko Media is a premiere provider of web based applications designed to make your website an integral part of the way your company does business. ___ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Oracle and Cold Fusion
You are the first others I've heard of with that same To_Char problem. I thought it just might be a configuration issue on our end, (NT 4.0 SP5 IBM) but it appears that we're not the only one now. Does anybody know if it's a CF issue or an Oracle issue, because when I talked to Allaire and Oracle, they both just pointed the finger at each other and neither was interested in addressing the problem. Dave - Original Message - From: "Larry Juncker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, October 05, 2000 9:11 AM Subject: RE: Oracle and Cold Fusion We also are using Oracle 8i and CF4.5. The To_Char issue is still there but otherwise, everything seems to work flawlessly. -- KNOCK ON MY WOODEN DESK -- Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 8:03 PM To: CF-Talk Subject: Re: Oracle and Cold Fusion We use Oracle 8 8i here with a tremendous amount of success. We've had one issue - that is that our Oracle sits on an IBM box and as a result, I have problems with number fields. I can write fine, but when I read back out using the Native Drivers, number fields come back in EPIDIC, so I have to do a To_Char on them. Otherwise, I can use ODBC without any problems. Now, that's been with 4.01. We're just about ready to load up 4.51, so we'll see what happens then. Oracle on IBM CF 4.01 on NT4.0 SP 5 Native Drivers ODBC Hope this helps, Dave -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle and Cold Fusion
I have heard that Oracle is the best database for Coldfusion because basically they can communicate natively without ODBC which will give much better performance. How true is this statement? I have a site which is being prototyped in Access (spit) but requires more power. I have been looking at the cheap route; mySql and Interbase compared with Oracle 8i, DB2 v7 and a few others. Is there anything I am overlooking? Does anyone have any comments/urls to help me make a more educated decision? Is Oracle a good database or is it like a Bentley; you just pay for the name? Designer databases :-) -- Gavin Lilley Internet / Intranet Developer Halesowen College Tel: 0121 550 1451 Ext: 330 -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 05 October 2000 14:30 To: CF-Talk Subject: Re: Oracle and Cold Fusion You are the first others I've heard of with that same To_Char problem. I thought it just might be a configuration issue on our end, (NT 4.0 SP5 IBM) but it appears that we're not the only one now. Does anybody know if it's a CF issue or an Oracle issue, because when I talked to Allaire and Oracle, they both just pointed the finger at each other and neither was interested in addressing the problem. Dave - Original Message - From: "Larry Juncker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, October 05, 2000 9:11 AM Subject: RE: Oracle and Cold Fusion We also are using Oracle 8i and CF4.5. The To_Char issue is still there but otherwise, everything seems to work flawlessly. -- KNOCK ON MY WOODEN DESK -- Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 8:03 PM To: CF-Talk Subject: Re: Oracle and Cold Fusion We use Oracle 8 8i here with a tremendous amount of success. We've had one issue - that is that our Oracle sits on an IBM box and as a result, I have problems with number fields. I can write fine, but when I read back out using the Native Drivers, number fields come back in EPIDIC, so I have to do a To_Char on them. Otherwise, I can use ODBC without any problems. Now, that's been with 4.01. We're just about ready to load up 4.51, so we'll see what happens then. Oracle on IBM CF 4.01 on NT4.0 SP 5 Native Drivers ODBC Hope this helps, Dave -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle and Cold Fusion
What is the "to_char problem"? -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 9:30 AM To: CF-Talk Subject: Re: Oracle and Cold Fusion You are the first others I've heard of with that same To_Char problem. I thought it just might be a configuration issue on our end, (NT 4.0 SP5 IBM) but it appears that we're not the only one now. Does anybody know if it's a CF issue or an Oracle issue, because when I talked to Allaire and Oracle, they both just pointed the finger at each other and neither was interested in addressing the problem. Dave -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Oracle and Cold Fusion
For some reason, when reading numeric columns out of the Oracle database, (at least with coming off the IBM), it does not convert the numeric values from EPICIC (the native IBM language) to ASCII. You just get funky characters instead of the values and you can't interpret them. So, to remedy this, we either avoid using numeric formats in the table or do a To_Char(column_name) in the SQL to force the data to ASCII. Dave - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, October 05, 2000 9:57 AM Subject: RE: Oracle and Cold Fusion What is the "to_char problem"? -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 9:30 AM To: CF-Talk Subject: Re: Oracle and Cold Fusion You are the first others I've heard of with that same To_Char problem. I thought it just might be a configuration issue on our end, (NT 4.0 SP5 IBM) but it appears that we're not the only one now. Does anybody know if it's a CF issue or an Oracle issue, because when I talked to Allaire and Oracle, they both just pointed the finger at each other and neither was interested in addressing the problem. Dave -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle and Cold Fusion
We use Sybase here, but I've noticed that the vast majority of discussions are about CF and Oracle. I wonder if that means Oracle is the preferred database for CF or if it is because it has more problems to discuss than the others? :-) At 02:38 PM 10/5/00 +0100, Gavin Lilley wrote: I have heard that Oracle is the best database for Coldfusion because basically they can communicate natively without ODBC which will give much better performance. How true is this statement? I have a site which is being prototyped in Access (spit) but requires more power. I have been looking at the cheap route; mySql and Interbase compared with Oracle 8i, DB2 v7 and a few others. Is there anything I am overlooking? Does anyone have any comments/urls to help me make a more educated decision? Is Oracle a good database or is it like a Bentley; you just pay for the name? Designer databases :-) -- Gavin Lilley Internet / Intranet Developer Halesowen College Tel: 0121 550 1451 Ext: 330 -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 05 October 2000 14:30 To: CF-Talk Subject: Re: Oracle and Cold Fusion You are the first others I've heard of with that same To_Char problem. I thought it just might be a configuration issue on our end, (NT 4.0 SP5 IBM) but it appears that we're not the only one now. Does anybody know if it's a CF issue or an Oracle issue, because when I talked to Allaire and Oracle, they both just pointed the finger at each other and neither was interested in addressing the problem. Dave - Original Message - From: "Larry Juncker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, October 05, 2000 9:11 AM Subject: RE: Oracle and Cold Fusion We also are using Oracle 8i and CF4.5. The To_Char issue is still there but otherwise, everything seems to work flawlessly. -- KNOCK ON MY WOODEN DESK -- Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 8:03 PM To: CF-Talk Subject: Re: Oracle and Cold Fusion We use Oracle 8 8i here with a tremendous amount of success. We've had one issue - that is that our Oracle sits on an IBM box and as a result, I have problems with number fields. I can write fine, but when I read back out using the Native Drivers, number fields come back in EPIDIC, so I have to do a To_Char on them. Otherwise, I can use ODBC without any problems. Now, that's been with 4.01. We're just about ready to load up 4.51, so we'll see what happens then. Oracle on IBM CF 4.01 on NT4.0 SP 5 Native Drivers ODBC Hope this helps, Dave -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle and Cold Fusion
I think itt's because Oracle has a large market share for enterprise-level e-commerce databases... -Original Message- From: Peter Theobald [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 10:23 AM To: CF-Talk Subject: RE: Oracle and Cold Fusion We use Sybase here, but I've noticed that the vast majority of discussions are about CF and Oracle. I wonder if that means Oracle is the preferred database for CF or if it is because it has more problems to discuss than the others? :-) At 02:38 PM 10/5/00 +0100, Gavin Lilley wrote: I have heard that Oracle is the best database for Coldfusion because basically they can communicate natively without ODBC which will give much better performance. How true is this statement? I have a site which is being prototyped in Access (spit) but requires more power. I have been looking at the cheap route; mySql and Interbase compared with Oracle 8i, DB2 v7 and a few others. Is there anything I am overlooking? Does anyone have any comments/urls to help me make a more educated decision? Is Oracle a good database or is it like a Bentley; you just pay for the name? Designer databases :-) -- Gavin Lilley Internet / Intranet Developer Halesowen College Tel: 0121 550 1451 Ext: 330 -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 05 October 2000 14:30 To: CF-Talk Subject: Re: Oracle and Cold Fusion You are the first others I've heard of with that same To_Char problem. I thought it just might be a configuration issue on our end, (NT 4.0 SP5 IBM) but it appears that we're not the only one now. Does anybody know if it's a CF issue or an Oracle issue, because when I talked to Allaire and Oracle, they both just pointed the finger at each other and neither was interested in addressing the problem. Dave - Original Message - From: "Larry Juncker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, October 05, 2000 9:11 AM Subject: RE: Oracle and Cold Fusion We also are using Oracle 8i and CF4.5. The To_Char issue is still there but otherwise, everything seems to work flawlessly. -- KNOCK ON MY WOODEN DESK -- Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 8:03 PM To: CF-Talk Subject: Re: Oracle and Cold Fusion We use Oracle 8 8i here with a tremendous amount of success. We've had one issue - that is that our Oracle sits on an IBM box and as a result, I have problems with number fields. I can write fine, but when I read back out using the Native Drivers, number fields come back in EPIDIC, so I have to do a To_Char on them. Otherwise, I can use ODBC without any problems. Now, that's been with 4.01. We're just about ready to load up 4.51, so we'll see what happens then. Oracle on IBM CF 4.01 on NT4.0 SP 5 Native Drivers ODBC Hope this helps, Dave - --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- - Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle and Cold Fusion
I would have said that the majority are about MS SQL Server and MS Access. I've used both oracle (7.3, 8.04) and Ms SQL Server (6.5) with CF without significant issues and can't say I have a strong preference. -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 1:23 PM To: CF-Talk Subject: RE: Oracle and Cold Fusion We use Sybase here, but I've noticed that the vast majority of discussions are about CF and Oracle. I wonder if that means Oracle is the preferred database for CF or if it is because it has more problems to discuss than the others? :-) At 02:38 PM 10/5/00 +0100, Gavin Lilley wrote: I have heard that Oracle is the best database for Coldfusion because basically they can communicate natively without ODBC which will give much -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle and Cold Fusion
According to Oracle they power 65% of database enabled sites. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 6 October 2000 5:00 To: CF-Talk Subject: RE: Oracle and Cold Fusion I would have said that the majority are about MS SQL Server and MS Access. I've used both oracle (7.3, 8.04) and Ms SQL Server (6.5) with CF without significant issues and can't say I have a strong preference. -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 1:23 PM To: CF-Talk Subject: RE: Oracle and Cold Fusion We use Sybase here, but I've noticed that the vast majority of discussions are about CF and Oracle. I wonder if that means Oracle is the preferred database for CF or if it is because it has more problems to discuss than the others? :-) At 02:38 PM 10/5/00 +0100, Gavin Lilley wrote: I have heard that Oracle is the best database for Coldfusion because basically they can communicate natively without ODBC which will give much -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle and Cold Fusion
One high-traffic app I developed used Oracle 7.3.4 and CF 4.01 on Solaris. Worked great on NT with an Access database, died on UNIX with Oracle. Go figure. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Donovan Rittenbach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 3:58 PM To: CF-Talk Subject: Oracle and Cold Fusion Is anybody out there integrating Oracle with Cold Fusion? What has been your experience? We are hearing of troubles with application stability with CF from one of our MSPs and have a large job for a prominent printing company we will need help with. Anyhow, we want to migrate from MySQL to Oracle 9i and want to know if there would be any troubles with that. Please contact me directly, if at all possible. Donovan -- Donovan Rittenbach, M.A. ph: 415-331-9110 ext. 402 fx: 415-893-1128 icq: 36547420 Neko Media is a premiere provider of web based applications designed to make your website an integral part of the way your company does business. ___ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Oracle and Cold Fusion
Is anybody out there integrating Oracle with Cold Fusion? What has been your experience? We are hearing of troubles with application stability with CF from one of our MSPs and have a large job for a prominent printing company we will need help with. Anyhow, we want to migrate from MySQL to Oracle 9i and want to know if there would be any troubles with that. Please contact me directly, if at all possible. Donovan -- Donovan Rittenbach, M.A. ph: 415-331-9110 ext. 402 fx: 415-893-1128 icq: 36547420 Neko Media is a premiere provider of web based applications designed to make your website an integral part of the way your company does business. ___ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Oracle and Cold Fusion
We use Oracle 8 8i here with a tremendous amount of success. We've had one issue - that is that our Oracle sits on an IBM box and as a result, I have problems with number fields. I can write fine, but when I read back out using the Native Drivers, number fields come back in EPIDIC, so I have to do a ToChar on them. Otherwise, I can use ODBC without any problems. Now, that's been with 4.01. We're just about ready to load up 4.51, so we'll see what happens then. Oracle on IBM CF 4.01 on NT4.0 SP 5 Native Drivers ODBC Hope this helps, Dave - Original Message - From: Donovan Rittenbach [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 04, 2000 6:57 PM Subject: Oracle and Cold Fusion Is anybody out there integrating Oracle with Cold Fusion? What has been your experience? We are hearing of troubles with application stability with CF from one of our MSPs and have a large job for a prominent printing company we will need help with. Anyhow, we want to migrate from MySQL to Oracle 9i and want to know if there would be any troubles with that. Please contact me directly, if at all possible. Donovan -- Donovan Rittenbach, M.A. ph: 415-331-9110 ext. 402 fx: 415-893-1128 icq: 36547420 Neko Media is a premiere provider of web based applications designed to make your website an integral part of the way your company does business. ___ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
