CFMX 6.1. Oracle 8i. BLOB. Insert/update trouble
Is anyone has success with inserting data in Oracle BLOB field? I tried latest JDBC driver from otn.oracle.com. As I found, this driver excellently work with CLOBs (insert, select, update) and can select BLOBs too. But when I try to insert BLOB, I receive an error "Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed." I use in to insert or update data with cfsqltype == CF_SQL_BLOB (if I change data type to CF_SQL_BINARY, ColdFusion throws other error: "Invalid data [EMAIL PROTECTED] for CFSQLTYPE CF_SQL_BINARY"). Also I found (it may be helpful for CF/ORACLE developers) that CFMX DataDirect Oracle driver *really* does not support CLOBs/BLOBs at all as well as bundle CFMX JDBC/ODBC bridge with Microsoft ODBC driver for Oracle. Alex. -- Environment details -- * ColdFusion MX 6.1 ENT. * Windows 2000 SP4 + postfixes * Oracle 8.1.7 * Oracle client 9.2.0.1, JDBC driver 9.2.0.3 (ojdbc14.jar, ocrs12.zip, nls_charset12.zip) * CLOB and BLOB checkboxes in datasource configuration in CF Admin are checked. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF MX *right* book.
People, thanks a lot to you for opinions about MX book! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
CF MX *right* book.
Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL & Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: oracle datasource as OLEDB
Hi, Sheila. The best connectivity between CF and Oracle /based on my own expirience/ - ODBC with Microsoft ODBC driver for Oracle. We have had many troubles with native drivers under load within 2 years, but those troubles disappeared as soon as we switched to ODBC. Alex. SH> This is my first encounter with Oracle. I need to define a datasource in SH> CF5. As far as using the database, it'll be nothing but the simplest SELECT SH> statements, so that shouldn't be a problem. SH> Is it possible to define an Oracle database with OLEDB, or do I have to use SH> ODBC? Can anyone give me some hints about defining an Oracle datasource? My SH> experience is mostly with Sql Server. SH> ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: oracle datasource as OLEDB
Hi, Sheila. The best connectivity between CF and Oracle /based on my own expirience/ - ODBC with Microsoft ODBC driver for Oracle. We have had many troubles with native drivers under load within 2 years, but those troubles disappeared as soon as we switched to ODBC. Alex. SH> This is my first encounter with Oracle. I need to define a datasource in SH> CF5. As far as using the database, it'll be nothing but the simplest SELECT SH> statements, so that shouldn't be a problem. SH> Is it possible to define an Oracle database with OLEDB, or do I have to use SH> ODBC? Can anyone give me some hints about defining an Oracle datasource? My SH> experience is mostly with Sql Server. SH> ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: oracle datasource as OLEDB
Hi, Sheila. The best connectivity between CF and Oracle /based on my own expirience/ - ODBC with Microsoft ODBC driver for Oracle. We have had many troubles with native drivers under load within 2 years, but those troubles disappeared as soon as we switched to ODBC. Alex. SH> This is my first encounter with Oracle. I need to define a datasource in SH> CF5. As far as using the database, it'll be nothing but the simplest SELECT SH> statements, so that shouldn't be a problem. SH> Is it possible to define an Oracle database with OLEDB, or do I have to use SH> ODBC? Can anyone give me some hints about defining an Oracle datasource? My SH> experience is mostly with Sql Server. SH> ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re[2]: CFserver 5 and Symantic AntiVirus
Certainly not, we have real time protection turned on (and never run a scan). Absolutely no problem. There is one trick, if you have MS SQL server installed on same computer (it's not right configuration, I know) and MS SQL Server Network library configured to use Named Pipes. In this case you should check 'selected' radio button on 'File Types' group in 'Configure'/'File system realtime protection' dialog. Otherwise, SQL Server will hang on next reboot, because NAV will lock SQL Server network pipe, assuming it is file without end. Alex Timchur, MM Certified Coldfusion 5 Developer PB> Do you have real time protection turned off? If so do you just run a scan PB> during low traffic hours? PB> Phillip B. PB> - Original Message - PB> From: "Alexandr Timchur" <[EMAIL PROTECTED]> PB> To: "CF-Talk" <[EMAIL PROTECTED]> PB> Sent: Wednesday, January 22, 2003 10:28 AM PB> Subject: Re: CFserver 5 and Symantic AntiVirus >> We use Symantec NAV 7.6 with IIS5, CF Server 5 on four web servers. >> Have no problem. >> >> Regards. >> Alex. >> >> PB> The company I work for wants me to use Symantic AntiVirus Corp Edition PB> on the web server. >> PB> Does anyone know if it plays rough with CF Server 5, IIS or anything PB> else for that matter? >> >> PB> Thanks! >> >> PB> Phillip B. >> >> PB> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFserver 5 and Symantic AntiVirus
We use Symantec NAV 7.6 with IIS5, CF Server 5 on four web servers. Have no problem. Regards. Alex. PB> The company I work for wants me to use Symantic AntiVirus Corp Edition on the web server. PB> Does anyone know if it plays rough with CF Server 5, IIS or anything else for that matter? PB> Thanks! PB> Phillip B. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Windows 2000 Security Rollup Package 1
I've installed it. One test and 3 production servers. All ok. -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 4:07 PM To: CF-Talk Subject: Windows 2000 Security Rollup Package 1 anyone installed this yet, any horror stories? zac __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFX tags with Delphi !!!
Hi Hamid! Try CFX_D [ http://www.thecia.net/users/lfofanov/CFXD/cfxd.htm ]. It's works well. Alex. HH> I want to create CFX tags using Delphi. I am wondring HH> if I can create them without any additional components HH> for Delphi. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ColdFusion stoppes responding to requests
Can anybody help me to solve the problem: Sometimes ColdFusion stoppes responding to requests. Performance monitor shows "running requests" to 6 (maximum allowed) and doesn't lowered. During this time, Avg DB Time changes in time, but not large. Processor time in normal bounds. Server: Windows NT 4.0 SP6, Cold Fusion 4.51 SP2 Enterprise (Native ORACLE Drivers), Oracle client 8.0.5. Only restarting of Cold Fusion Application Server service can help to return to the normal functionality. Error code to browsers is: --- Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) --- Best regards, Alex. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Another clustering question (MS SQL 7.0).
Thank you, Andrew! please tell me, can Co-Standby control IIS and ColdFusion services? Alexandr. AE> Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB AE> and 2 SQL servers. One of the SQL servers is live and the other is passive, AE> both sharing a disk array containing the databases. If server 1 fails then AE> server 2 takes over. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Another clustering question (MS SQL 7.0).
Dear subscribers, talk me please about clustering software you use for cluster MS SQL Server 7.0 (or 2000). I would like to solve two problems - the first: solution must provide fault tolerance, the second: load balancing very desirable for me. I tried MS Cluster Service and Legato Cluster Server - those products are good for solving first problem, but I can't find any product that can provide load balancing - it possible in common case for MS SQL Server? Thank you, Alexandr Timchur. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Failover and Load Balancing Solution for IIS/ColdFusion, but not ClusterCats.
Dear subscribers, please recomend me failover (and load balancing - it is important) solution than can clusterise IIS/ColdFusion servers. Ideal will be analog of ClusterCats. I have tried ClusterCats, but it can't clusterise multi-webservers IIS sites (I want create cluster for several virtual servers, but I dont want to create separate clusters for each virtual server). Thank you, Alexandr Timchur. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Where can I get Stream Environment Protocol in Windows 2000 AS?
Hi! I want to setup dynamic ClusterCats Fail-over and must install Stream Environment Protocol, but can't find it in Protocol tab in Windows 2000. In Windows NT 4.0 it is appears there. Please help me find it in Windows 2000. Best regards, Alex. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
