RE: CFMX - I've never seen anything so unstable in my life
Just in case this was missed. I have found that upgrading the jre to Sun's 1.40 jre, goes some way to relieving the SQL 7 jdbc related problems. I've not had any problems since upgrading. However, I've not been able to run any load testing. I've also found that the ODBC socket shows instability when there are stability issues in the jdbc connection. Like someone pointed out - the odbc socket is simply a java wrapper. Dave -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 13 October 2002 01:01 To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life Sorry it's taken me a while to get back to you on this. Have you tried the ODBC Socket driver setup to see whether that is more stable? The product team have a lot of information now from folks seeing some problems with SQL Server 7 and the JDBC driver and they are looking into the problem. However, since all the database drivers are 3rd-party, we may be somewhat limited in how fast we can resolve this (hence the workaround of trying the ODBC Socket driver). An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 On Monday, Oct 7, 2002, at 13:06 US/Pacific, Ben Densmore wrote: Here are the settings for one Datasource, I put in some dummy data for datasource name etc.. All my datasources have these same settings. Data Source Name - Datasource Name Database - Database Name Server - 0.0.0.0 Port - 1433 Username Password Description Select Method - Direct Limit Connections - Not Checked Restrict connections to - Blank Maintain Connections - Checked String Format- Not Checked Timeout (min) - 20 Interval (min) - 7 Disable Connections - Not Checked Login Timeout (sec) - 30 CLOB - Not Checked BLOB - Not Checked Long Text Buffer (chr) - 64000 Blob Buffer(bytes) - 64000 Allowed SQL SELECT Create GRANT INSERT DROP REVOKE UPDATE ALTERStored Procedures DELETE Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:43 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Hmm, doesn't sound like an unusual setup. That's a very frequent error rate tho'... What is the full data source configuration, including Advanced Settings? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Re: CFMX - I've never seen anything so unstable in my life
I too, found the stability problems vanish when replacing jrun with Sun 1.4 This address is filtered through the open relay database at http://www.ordb.org and is virus scanned by ANTIVIR http://www.dwhite.ws mailto:[EMAIL PROTECTED] - Original Message - From: Dave Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 14, 2002 8:36 AM Subject: RE: CFMX - I've never seen anything so unstable in my life | Just in case this was missed. I have found that upgrading the jre to Sun's | 1.40 jre, goes some way to relieving the SQL 7 jdbc related problems. I've | not had any problems since upgrading. However, I've not been able to run any | load testing. | | I've also found that the ODBC socket shows instability when there are | stability issues in the jdbc connection. Like someone pointed out - the odbc | socket is simply a java wrapper. | | Dave | | -Original Message- | From: Sean A Corfield [mailto:[EMAIL PROTECTED]] | Sent: 13 October 2002 01:01 | To: CF-Talk | Subject: Re: CFMX - I've never seen anything so unstable in my life | | | Sorry it's taken me a while to get back to you on this. Have you tried | the ODBC Socket driver setup to see whether that is more stable? The | product team have a lot of information now from folks seeing some | problems with SQL Server 7 and the JDBC driver and they are looking | into the problem. However, since all the database drivers are | 3rd-party, we may be somewhat limited in how fast we can resolve this | (hence the workaround of trying the ODBC Socket driver). | | An Architect's View -- http://www.corfield.org/blog/ | | Macromedia DevCon 2002, October 27-30, Orlando, Florida | Architecting a New Internet Experience | Register today at http://www.macromedia.com/go/devcon2002 | | On Monday, Oct 7, 2002, at 13:06 US/Pacific, Ben Densmore wrote: | Here are the settings for one Datasource, I put in some dummy data for | datasource name etc.. All my datasources have these same settings. | |Data Source Name - Datasource Name |Database - Database Name |Server - 0.0.0.0 Port - 1433 |Username | |Password | |Description | | |Select Method - Direct | |Limit Connections - Not Checked Restrict connections to - Blank | |Maintain Connections - Checked | |String Format- Not Checked | | | |Timeout (min) - 20 Interval (min) - 7 | | | | | |Disable Connections - Not Checked | |Login Timeout (sec) - 30 | |CLOB - Not Checked | |BLOB - Not Checked | |Long Text Buffer (chr) - 64000 | |Blob Buffer(bytes) - 64000 | |Allowed SQL | SELECT Create GRANT | INSERT DROP REVOKE | UPDATE ALTERStored Procedures | DELETE | | Ben | | | -Original Message- | From: Sean A Corfield [mailto:[EMAIL PROTECTED]] | Sent: Monday, October 07, 2002 3:43 PM | To: CF-Talk | Subject: Re: CFMX - I've never seen anything so unstable in my life | | On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: | Here are the answers to your questions. | - OS / patch level - Win2k SP3 | - Database / patch level - SQL Server 7 SP4 | - Is the DB on a separate machine? - Yes | - Which driver are you using specifically? | -macromedia.jdbc.MacromediaDriver | - How often do you see this? - Happens daily about every 2-5 minutes | - Does it seem to be connected to any other network issues? - We've | never had any problems with CF 4.5 | - Are there other errors in the CF logs? - No | | Hmm, doesn't sound like an unusual setup. That's a very frequent error | rate tho'... | | What is the full data source configuration, including Advanced | Settings? | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
RE: CFMX - I've never seen anything so unstable in my life
Dave, Thanks for the tip. Can you post a simple 1-2-3 on how to upgrade the JRE to Sun's JRE? That would be helpful. Are there any pitfalls? -mk -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 8:36 AM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Just in case this was missed. I have found that upgrading the jre to Sun's 1.40 jre, goes some way to relieving the SQL 7 jdbc related problems. I've not had any problems since upgrading. However, I've not been able to run any load testing. I've also found that the ODBC socket shows instability when there are stability issues in the jdbc connection. Like someone pointed out - the odbc socket is simply a java wrapper. Dave -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 13 October 2002 01:01 To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life Sorry it's taken me a while to get back to you on this. Have you tried the ODBC Socket driver setup to see whether that is more stable? The product team have a lot of information now from folks seeing some problems with SQL Server 7 and the JDBC driver and they are looking into the problem. However, since all the database drivers are 3rd-party, we may be somewhat limited in how fast we can resolve this (hence the workaround of trying the ODBC Socket driver). An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 On Monday, Oct 7, 2002, at 13:06 US/Pacific, Ben Densmore wrote: Here are the settings for one Datasource, I put in some dummy data for datasource name etc.. All my datasources have these same settings. Data Source Name - Datasource Name Database - Database Name Server - 0.0.0.0 Port - 1433 Username Password Description Select Method - Direct Limit Connections - Not Checked Restrict connections to - Blank Maintain Connections - Checked String Format- Not Checked Timeout (min) - 20 Interval (min) - 7 Disable Connections - Not Checked Login Timeout (sec) - 30 CLOB - Not Checked BLOB - Not Checked Long Text Buffer (chr) - 64000 Blob Buffer(bytes) - 64000 Allowed SQL SELECT Create GRANT INSERT DROP REVOKE UPDATE ALTERStored Procedures DELETE Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:43 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Hmm, doesn't sound like an unusual setup. That's a very frequent error rate tho'... What is the full data source configuration, including Advanced Settings? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
RE: CFMX - I've never seen anything so unstable in my life
Can you post a simple 1-2-3 on how to upgrade the JRE to Sun's JRE? That would be helpful. It's very easy. 1. Download and install the JRE of choice. 2. Within the CF Administrator, enter the path to the jre directory (which should contain two subdirectories, bin and lib). 3. Restart CF MX. Are there any pitfalls? I've been running on the Sun 1.4.0_01 JVM for a while, and haven't run into any problems that I can directly trace to the newer VM. However, last week on this list there was a discussion of a bug that manifested itself with CF MX using the 1.4.1 JVM - look at the Another MX boo boo thread for more info. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life
As far as installing the Sun jre goes, its simply a matter of downloading the jre from: http://java.sun.com/j2se/1.4/download.html and running the self extracting installer with all default settings - Note this was on my newly formatted and win2k server/CFMX installed development machine. The install notes for the win2k version can be found below: http://java.sun.com/j2se/1.4/jre/install-windows.html Can't get much simpler :) HTH, Dave -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: 14 October 2002 14:54 To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Dave, Thanks for the tip. Can you post a simple 1-2-3 on how to upgrade the JRE to Sun's JRE? That would be helpful. Are there any pitfalls? -mk -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 8:36 AM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Just in case this was missed. I have found that upgrading the jre to Sun's 1.40 jre, goes some way to relieving the SQL 7 jdbc related problems. I've not had any problems since upgrading. However, I've not been able to run any load testing. I've also found that the ODBC socket shows instability when there are stability issues in the jdbc connection. Like someone pointed out - the odbc socket is simply a java wrapper. Dave -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 13 October 2002 01:01 To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life Sorry it's taken me a while to get back to you on this. Have you tried the ODBC Socket driver setup to see whether that is more stable? The product team have a lot of information now from folks seeing some problems with SQL Server 7 and the JDBC driver and they are looking into the problem. However, since all the database drivers are 3rd-party, we may be somewhat limited in how fast we can resolve this (hence the workaround of trying the ODBC Socket driver). An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 On Monday, Oct 7, 2002, at 13:06 US/Pacific, Ben Densmore wrote: Here are the settings for one Datasource, I put in some dummy data for datasource name etc.. All my datasources have these same settings. Data Source Name - Datasource Name Database - Database Name Server - 0.0.0.0 Port - 1433 Username Password Description Select Method - Direct Limit Connections - Not Checked Restrict connections to - Blank Maintain Connections - Checked String Format- Not Checked Timeout (min) - 20 Interval (min) - 7 Disable Connections - Not Checked Login Timeout (sec) - 30 CLOB - Not Checked BLOB - Not Checked Long Text Buffer (chr) - 64000 Blob Buffer(bytes) - 64000 Allowed SQL SELECT Create GRANT INSERT DROP REVOKE UPDATE ALTERStored Procedures DELETE Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:43 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Hmm, doesn't sound like an unusual setup. That's a very frequent error rate tho'... What is the full data source configuration, including Advanced Settings? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFMX - I've never seen anything so unstable in my life
Can you post a simple 1-2-3 on how to upgrade the JRE to Sun's JRE? That would be helpful. It's very easy. 1. Download and install the JRE of choice. 2. Within the CF Administrator, enter the path to the jre directory (which should contain two subdirectories, bin and lib). 3. Restart CF MX. I inadvertently left out step 2 but still noticed the improvements to the jdbc driver performance. I presume the new jre automatically improves upon any existing jdbc drivers installed on the machine and that the jvm mapping required in the cf administrator is for the purpose of mapping other CF items to the upgraded jre. Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
RE: CFMX - I've never seen anything so unstable in my life
I just downloaeded 1.4.1 and am getting this error message when I try to switch over to it's jvm.dll The JVM path you entered is not a valid JVM path. The JVM path must have a bin directory with a JVM executable located in it. Any ideas why I would be getting this message? Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 9:58 AM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life As far as installing the Sun jre goes, its simply a matter of downloading the jre from: http://java.sun.com/j2se/1.4/download.html and running the self extracting installer with all default settings - Note this was on my newly formatted and win2k server/CFMX installed development machine. The install notes for the win2k version can be found below: http://java.sun.com/j2se/1.4/jre/install-windows.html Can't get much simpler :) HTH, Dave -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: 14 October 2002 14:54 To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Dave, Thanks for the tip. Can you post a simple 1-2-3 on how to upgrade the JRE to Sun's JRE? That would be helpful. Are there any pitfalls? -mk -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 8:36 AM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Just in case this was missed. I have found that upgrading the jre to Sun's 1.40 jre, goes some way to relieving the SQL 7 jdbc related problems. I've not had any problems since upgrading. However, I've not been able to run any load testing. I've also found that the ODBC socket shows instability when there are stability issues in the jdbc connection. Like someone pointed out - the odbc socket is simply a java wrapper. Dave -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 13 October 2002 01:01 To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life Sorry it's taken me a while to get back to you on this. Have you tried the ODBC Socket driver setup to see whether that is more stable? The product team have a lot of information now from folks seeing some problems with SQL Server 7 and the JDBC driver and they are looking into the problem. However, since all the database drivers are 3rd-party, we may be somewhat limited in how fast we can resolve this (hence the workaround of trying the ODBC Socket driver). An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 On Monday, Oct 7, 2002, at 13:06 US/Pacific, Ben Densmore wrote: Here are the settings for one Datasource, I put in some dummy data for datasource name etc.. All my datasources have these same settings. Data Source Name - Datasource Name Database - Database Name Server - 0.0.0.0 Port - 1433 Username Password Description Select Method - Direct Limit Connections - Not Checked Restrict connections to - Blank Maintain Connections - Checked String Format- Not Checked Timeout (min) - 20 Interval (min) - 7 Disable Connections - Not Checked Login Timeout (sec) - 30 CLOB - Not Checked BLOB - Not Checked Long Text Buffer (chr) - 64000 Blob Buffer(bytes) - 64000 Allowed SQL SELECT Create GRANT INSERT DROP REVOKE UPDATE ALTERStored Procedures DELETE Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:43 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Hmm, doesn't sound like an unusual setup. That's a very frequent error rate tho'... What is the full data source configuration, including Advanced Settings? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http
RE: CFMX - I've never seen anything so unstable in my life
I'm not sure Robert, Note I reccomended version 1.4.0. At the risk of condescending you - You may simply be pointing to the incorrect directory. For j2se 1.4.0 the jvm mapping should point to C:\Program Files\Java\j2re1.4.0_02 providing you ran a default install. Dave -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: 14 October 2002 15:29 To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life I just downloaeded 1.4.1 and am getting this error message when I try to switch over to it's jvm.dll The JVM path you entered is not a valid JVM path. The JVM path must have a bin directory with a JVM executable located in it. Any ideas why I would be getting this message? Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 9:58 AM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life As far as installing the Sun jre goes, its simply a matter of downloading the jre from: http://java.sun.com/j2se/1.4/download.html and running the self extracting installer with all default settings - Note this was on my newly formatted and win2k server/CFMX installed development machine. The install notes for the win2k version can be found below: http://java.sun.com/j2se/1.4/jre/install-windows.html Can't get much simpler :) HTH, Dave -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: 14 October 2002 14:54 To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Dave, Thanks for the tip. Can you post a simple 1-2-3 on how to upgrade the JRE to Sun's JRE? That would be helpful. Are there any pitfalls? -mk -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 8:36 AM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Just in case this was missed. I have found that upgrading the jre to Sun's 1.40 jre, goes some way to relieving the SQL 7 jdbc related problems. I've not had any problems since upgrading. However, I've not been able to run any load testing. I've also found that the ODBC socket shows instability when there are stability issues in the jdbc connection. Like someone pointed out - the odbc socket is simply a java wrapper. Dave -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 13 October 2002 01:01 To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life Sorry it's taken me a while to get back to you on this. Have you tried the ODBC Socket driver setup to see whether that is more stable? The product team have a lot of information now from folks seeing some problems with SQL Server 7 and the JDBC driver and they are looking into the problem. However, since all the database drivers are 3rd-party, we may be somewhat limited in how fast we can resolve this (hence the workaround of trying the ODBC Socket driver). An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 On Monday, Oct 7, 2002, at 13:06 US/Pacific, Ben Densmore wrote: Here are the settings for one Datasource, I put in some dummy data for datasource name etc.. All my datasources have these same settings. Data Source Name - Datasource Name Database - Database Name Server - 0.0.0.0 Port - 1433 Username Password Description Select Method - Direct Limit Connections - Not Checked Restrict connections to - Blank Maintain Connections - Checked String Format- Not Checked Timeout (min) - 20 Interval (min) - 7 Disable Connections - Not Checked Login Timeout (sec) - 30 CLOB - Not Checked BLOB - Not Checked Long Text Buffer (chr) - 64000 Blob Buffer(bytes) - 64000 Allowed SQL SELECT Create GRANT INSERT DROP REVOKE UPDATE ALTERStored Procedures DELETE Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:43 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Hmm, doesn't sound like an unusual setup. That's a very frequent error
RE: CFMX - I've never seen anything so unstable in my life
On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No This is pretty much the same as my setup, except I'm running SQL 7 on same box. My JDBC connection error is slightly different though [1]. I've read through the rest of this thread this morning and have noted a few items which I shall go and check out now to see if they will fix things and shall report back later with my findings. Dave [1] - SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The datasource is set up correctly as it was working fine for a few days and nothing has changed. I can no longer access the CF Administrator and don't know of any other way of editing JDBC settings on my win2k machine. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFMX - I've never seen anything so unstable in my life
Quoting Dave Wilson [EMAIL PROTECTED]: The datasource is set up correctly as it was working fine for a few days and nothing has changed. I can no longer access the CF Administrator and don't know of any other way of editing JDBC settings on my win2k machine. Use the coldfusion.server.ServiceFactory: http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=12 You can verify all the information about the datasources and you can even change it, if you don't mind the settings not being documented. It should also be possible to do so by editing the XML files, but that would require a restart after every change. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life
Thanks Jochem, However I'm getting a Runtime Exception from that link. Running win2k Pro IE 6 with css enabled as default (got a note about not supporting your css) Still not having much joy with CFMX here either. May post the series of events leading up to my current problems in another mail shortly if I don't come up with anything. Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFMX - I've never seen anything so unstable in my life
I dunno, I saw a man on stilts in quickstand once.. he looked pretty unstable; :-) -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 13:08 To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Thanks Jochem, However I'm getting a Runtime Exception from that link. Running win2k Pro IE 6 with css enabled as default (got a note about not supporting your css) Still not having much joy with CFMX here either. May post the series of events leading up to my current problems in another mail shortly if I don't come up with anything. Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life
Quoting Dave Wilson [EMAIL PROTECTED]: However I'm getting a Runtime Exception from that link Oeps. The database is running on an experimental machine and I was upgrading it. Try again. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life - Also - LONG time CF Supporter.........
Amalgamating two similar threads. OK here is the sequence of events which have led me to where I am right now with my CFMX problems. CURRENT SITUATION: -- Unable to browse cfm templates on virtual hosts - http 500 error thrown - have attempted wsconfig.jar (see below) SEQUENCE: - CFMX problem. 1. Removed CF4.5 ENT, including Registry keys. 2. Run the CFMX installation wizard - install verified fine. 3. Attempt to view some virtual sites - not working - 500 errors 4. Consulted cf-talk - discovered requirement to run wsconfig.jar and edit an xml file for virtual site support despite having selected IIS during CFMX install - I believe Macromedia should have incorporated this configuration into the installation process. 5. Virtual sites appear to be functioning just fine now - proceed to update code to work in CFMX. 6. Converted a few existing popchart driven charts to work using cfchart instead. 7. Ran into a COM related problem. 8. Installed the updater as suggested by cf-talk members to resolve COM problems 9. COM problem persists 10. attempted to run wsconfig.jar again under presumption the updates may required redistribution to the virtual hosts. 11. No longer able to access the cfadministrator - Unable to find templates etc. 12. Attempted to remove CFMX - Installer only runs the uninstall but won't remove files from c:\cfusionMX folder. 13. Unable to manually remove files as one file was in use - Sorry can't remember which. 14. Re-installed CFMX to a new folder c:\cfusion - everything was fine after this. 15. Went home for the weekend 16. Returned on Monday to find my existing problems - 404 errors upon cfadministrator login, JDBC related error messages and very basic code producing errors where it was fine before (for over 2 years). Some of the problems I'm experiencing remind me of when CF4.0 required a new MDAC to be installed. 17. Checked server logs and no activity aparent for the weekend period of absence. 18. Checked and re-checked all Service packs, including upgrading SQL Server to SP4 from SP2. SP4 includes an update to the MDAC. 19. Removed and reinstalled CFMX to default directory. 20. Attempted to run wsconfig.jar - Returns message stating that IIS already configured. 21. Attempt to view any cfm templates located anywhere on the virtual sites - won't work! 22. The CF Administrator has become accessible again. END SEQUENCE Note, I've opted to use the ODBC Sockets for connecting to my MS SQL 7 datasource. This is for a number of reasons. firstly, I want to use NT authentication on the database, which isnt supported by the JDBC driver. I was once told in the past that SQL Server logins are stored in the system registry and hence are easier to compromise than the NT logins being stored in the SAM db or in Active Directory. I've also noted that several people have been having problems with the JDBC drivers including inability to communicate with remote SQL machines on same network etc. Any ideas anyone? TIA, Dave -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 13:40 To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Quoting Dave Wilson [EMAIL PROTECTED]: However I'm getting a Runtime Exception from that link Oeps. The database is running on an experimental machine and I was upgrading it. Try again. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life - Also - LONG time CF Supporter.........
I'm reading through this thread, adding as I can...more to come. One thing I notice here Dave is that you mention you had trouble with your uninstall/reinstall, particularly deleting the directory. Tech support has been recommending that when you uninstall, you reboot afterward, then delete the c:\CFusionMX directory, so that you don't run into the file busy or locked situation. Then you can do a cleaner reinstall. This may not clear up the entire situation for you, but it certainly could help. I wonder if it would be adventageous to put uninstall/reinstall instructions in the livedocs? Vernon Viehe ColdFusion Community Manager Developer Relations Macromedia, Inc. Online diary: http://vvmx.blogspot.com/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at www.macromedia.com/go/devcon2002 -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 6:50 AM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life - Also - LONG time CF Supporter. Amalgamating two similar threads. OK here is the sequence of events which have led me to where I am right now with my CFMX problems. CURRENT SITUATION: -- Unable to browse cfm templates on virtual hosts - http 500 error thrown - have attempted wsconfig.jar (see below) SEQUENCE: - CFMX problem. 1. Removed CF4.5 ENT, including Registry keys. 2. Run the CFMX installation wizard - install verified fine. 3. Attempt to view some virtual sites - not working - 500 errors 4. Consulted cf-talk - discovered requirement to run wsconfig.jar and edit an xml file for virtual site support despite having selected IIS during CFMX install - I believe Macromedia should have incorporated this configuration into the installation process. 5. Virtual sites appear to be functioning just fine now - proceed to update code to work in CFMX. 6. Converted a few existing popchart driven charts to work using cfchart instead. 7. Ran into a COM related problem. 8. Installed the updater as suggested by cf-talk members to resolve COM problems 9. COM problem persists 10. attempted to run wsconfig.jar again under presumption the updates may required redistribution to the virtual hosts. 11. No longer able to access the cfadministrator - Unable to find templates etc. 12. Attempted to remove CFMX - Installer only runs the uninstall but won't remove files from c:\cfusionMX folder. 13. Unable to manually remove files as one file was in use - Sorry can't remember which. 14. Re-installed CFMX to a new folder c:\cfusion - everything was fine after this. 15. Went home for the weekend 16. Returned on Monday to find my existing problems - 404 errors upon cfadministrator login, JDBC related error messages and very basic code producing errors where it was fine before (for over 2 years). Some of the problems I'm experiencing remind me of when CF4.0 required a new MDAC to be installed. 17. Checked server logs and no activity aparent for the weekend period of absence. 18. Checked and re-checked all Service packs, including upgrading SQL Server to SP4 from SP2. SP4 includes an update to the MDAC. 19. Removed and reinstalled CFMX to default directory. 20. Attempted to run wsconfig.jar - Returns message stating that IIS already configured. 21. Attempt to view any cfm templates located anywhere on the virtual sites - won't work! 22. The CF Administrator has become accessible again. END SEQUENCE Note, I've opted to use the ODBC Sockets for connecting to my MS SQL 7 datasource. This is for a number of reasons. firstly, I want to use NT authentication on the database, which isnt supported by the JDBC driver. I was once told in the past that SQL Server logins are stored in the system registry and hence are easier to compromise than the NT logins being stored in the SAM db or in Active Directory. I've also noted that several people have been having problems with the JDBC drivers including inability to communicate with remote SQL machines on same network etc. Any ideas anyone? TIA, Dave -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 13:40 To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Quoting Dave Wilson [EMAIL PROTECTED]: However I'm getting a Runtime Exception from that link Oeps. The database is running on an experimental machine and I was upgrading it. Try again. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion
RE: CFMX - I've never seen anything so unstable in my life - Also - LONG time CF Supporter.........
Thanks Vernon, Yes, on that particular instance of uninstall/reinstall I had neglected to reboot. However on all other instances I did reboot (although I didnt remove the directory on every instance). I'm about to go to another office where we have a spare machine I can use. Will do a complete fresh install of Win2K and everything on it and see what happens then. This should help to discount any extraneous environment issues with our existing Dev machine. I may not get to respond to the discussions until tomorrow (I'm in the UK and it's evening time). Thanks again, Dave -Original Message- From: Vernon Viehe [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 16:41 To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life - Also - LONG time CF Supporter. I'm reading through this thread, adding as I can...more to come. One thing I notice here Dave is that you mention you had trouble with your uninstall/reinstall, particularly deleting the directory. Tech support has been recommending that when you uninstall, you reboot afterward, then delete the c:\CFusionMX directory, so that you don't run into the file busy or locked situation. Then you can do a cleaner reinstall. This may not clear up the entire situation for you, but it certainly could help. I wonder if it would be adventageous to put uninstall/reinstall instructions in the livedocs? Vernon Viehe ColdFusion Community Manager Developer Relations Macromedia, Inc. Online diary: http://vvmx.blogspot.com/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at www.macromedia.com/go/devcon2002 -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 6:50 AM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life - Also - LONG time CF Supporter. Amalgamating two similar threads. OK here is the sequence of events which have led me to where I am right now with my CFMX problems. CURRENT SITUATION: -- Unable to browse cfm templates on virtual hosts - http 500 error thrown - have attempted wsconfig.jar (see below) SEQUENCE: - CFMX problem. 1. Removed CF4.5 ENT, including Registry keys. 2. Run the CFMX installation wizard - install verified fine. 3. Attempt to view some virtual sites - not working - 500 errors 4. Consulted cf-talk - discovered requirement to run wsconfig.jar and edit an xml file for virtual site support despite having selected IIS during CFMX install - I believe Macromedia should have incorporated this configuration into the installation process. 5. Virtual sites appear to be functioning just fine now - proceed to update code to work in CFMX. 6. Converted a few existing popchart driven charts to work using cfchart instead. 7. Ran into a COM related problem. 8. Installed the updater as suggested by cf-talk members to resolve COM problems 9. COM problem persists 10. attempted to run wsconfig.jar again under presumption the updates may required redistribution to the virtual hosts. 11. No longer able to access the cfadministrator - Unable to find templates etc. 12. Attempted to remove CFMX - Installer only runs the uninstall but won't remove files from c:\cfusionMX folder. 13. Unable to manually remove files as one file was in use - Sorry can't remember which. 14. Re-installed CFMX to a new folder c:\cfusion - everything was fine after this. 15. Went home for the weekend 16. Returned on Monday to find my existing problems - 404 errors upon cfadministrator login, JDBC related error messages and very basic code producing errors where it was fine before (for over 2 years). Some of the problems I'm experiencing remind me of when CF4.0 required a new MDAC to be installed. 17. Checked server logs and no activity aparent for the weekend period of absence. 18. Checked and re-checked all Service packs, including upgrading SQL Server to SP4 from SP2. SP4 includes an update to the MDAC. 19. Removed and reinstalled CFMX to default directory. 20. Attempted to run wsconfig.jar - Returns message stating that IIS already configured. 21. Attempt to view any cfm templates located anywhere on the virtual sites - won't work! 22. The CF Administrator has become accessible again. END SEQUENCE Note, I've opted to use the ODBC Sockets for connecting to my MS SQL 7 datasource. This is for a number of reasons. firstly, I want to use NT authentication on the database, which isnt supported by the JDBC driver. I was once told in the past that SQL Server logins are stored in the system registry and hence are easier to compromise than the NT logins being stored in the SAM db or in Active Directory. I've also noted that several people have been having problems with the JDBC drivers including inability to communicate with remote
RE: CFMX - I've never seen anything so unstable in my life
Well, I have had the problem of it losing a connection to SQL Server via JDBC, that is the only problem I have had but has prevented me from buying the full version for use in the company I work for. Other than that it works great, but I can't have these connection reset errors coming up every few minutes. Ben -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:31 PM To: CF-Talk Subject: CFMX - I've never seen anything so unstable in my life Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life
Ben, I've seen that socket reset error too. Does anyone have an idea why it occurs? -mk -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:37 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Well, I have had the problem of it losing a connection to SQL Server via JDBC, that is the only problem I have had but has prevented me from buying the full version for use in the company I work for. Other than that it works great, but I can't have these connection reset errors coming up every few minutes. Ben -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:31 PM To: CF-Talk Subject: CFMX - I've never seen anything so unstable in my life Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life
Just so you know there is a patch on the smack-romedia site that might help (don't know the address though). We are porting cf5 to MX and had several sloppy coding errors, as well as some full fledged product errors. All in all, when the code is optimized for MX - which almost no currently existing cf code is - it runs like a champ. It is *very* obvious that the project was pushed out the door without being tested well, or at least tested in some sort of large production environment - probably do to the dropping stock. Don't give up just yet as this appears to be the way cf is going, and if you give up your site will be stuck in old technology. either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, We are having issues with the JDBC Drivers as well. We have several messages into smack-romedia, and we will post when we hear. Good luck, Rob -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:31 AM To: CF-Talk Subject: CFMX - I've never seen anything so unstable in my life Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Re: CFMX - I've never seen anything so unstable in my life
Maybe Microsoft really owns Macromedia and is dilluting the market with unstable products in a effort to move everyone to a single Microsoft platform... Or maybe it is just the fact that your using a little older database in which a small portion of testing was conducted upon. - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 10:56 AM Subject: RE: CFMX - I've never seen anything so unstable in my life Ben, I've seen that socket reset error too. Does anyone have an idea why it occurs? -mk -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:37 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Well, I have had the problem of it losing a connection to SQL Server via JDBC, that is the only problem I have had but has prevented me from buying the full version for use in the company I work for. Other than that it works great, but I can't have these connection reset errors coming up every few minutes. Ben -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:31 PM To: CF-Talk Subject: CFMX - I've never seen anything so unstable in my life Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFMX - I've never seen anything so unstable in my life
Rob, If you get an answer to the JDBC Drivers please let us know, I have been asking for like 2 months now, trying to figure out what's going on. And have not gotten an answer, I've used the updater, Installed all the newest sp's for SQL Server and still nothing. Thanks, Ben -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:57 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Just so you know there is a patch on the smack-romedia site that might help (don't know the address though). We are porting cf5 to MX and had several sloppy coding errors, as well as some full fledged product errors. All in all, when the code is optimized for MX - which almost no currently existing cf code is - it runs like a champ. It is *very* obvious that the project was pushed out the door without being tested well, or at least tested in some sort of large production environment - probably do to the dropping stock. Don't give up just yet as this appears to be the way cf is going, and if you give up your site will be stuck in old technology. either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, We are having issues with the JDBC Drivers as well. We have several messages into smack-romedia, and we will post when we hear. Good luck, Rob -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:31 AM To: CF-Talk Subject: CFMX - I've never seen anything so unstable in my life Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. I'm running CFMX on Win2k Server SP3, IIS 5 and MSSQL Server 7 TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX - I've never seen anything so unstable in my life
On Monday, Oct 7, 2002, at 10:30 US/Pacific, Dave Wilson wrote: Is it just me, or is CFMX proving totally unstable for everyone else too? It isn't *just* you but it is certainly a minority. Unfortunately, mailing lists like this (and the webforums) are typically where people come when they have problems so things seem worse than they are - we don't see legions of people piping up and saying It works just fine for me!... I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or the JDBC drivers dropping connections and ceasing to function, or simply being unable to access any sites being served by CFMX. This is totally unacceptable for a production environment. That sounds unusually unstable. Perhaps applying the Updater will resolve some of your problems but it sounds to me like something else is wrong in your environment. Hopefully folks here can help you resolve it. Can someone please tell me these problems are rare and only I am experiencing them as opposed to being the general rule of thumb for CFMX installs. We have CFMX running on Solaris backed by Oracle for some applications in production (ColdFusion Examples app, various Flash / Flash Remoting / CFMX examples, PetMarket) and these have been running just fine for months without needing any attention (except when we upgraded to Apache 2.x and broke some connector mappings - but that was our bad!). We have been running CFMX internally for many, many months and have experienced very few stability problems (we had a badly-behaved Java tag library that occasionally hung JRun but not much apart from that). An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX - I've never seen anything so unstable in my life
On Monday, Oct 7, 2002, at 10:56 US/Pacific, Rob Rohan wrote: We are porting cf5 to MX and had several sloppy coding errors, as well as some full fledged product errors. All in all, when the code is optimized for MX - which almost no currently existing cf code is - it runs like a champ. Glad to hear it (that it runs like a champ)! It's always good to hear from a (fairly) satisfied customer :) It is *very* obvious that the project was pushed out the door without being tested well, or at least tested in some sort of large production environment - probably do to the dropping stock. Hmm, that's a very unfair criticism. No products are error-free and CFMX was *extensively* tested for many months. The QA team accrued a vast pool of ColdFusion source code to test against and my team was developing heavy applications in CFMX and working with the product team on resolving issues. CFMX was probably tested more than any previous version of CF. However, you must bear in mind that CFMX is a complete rewrite on a new platform - that means there are bound to be *some* issues that will crop up. Some of these are a natural fall-out of the transition from C++ to Java and the use of different libraries (for example, the database access via JDBC). We are having issues with the JDBC Drivers as well. We have several messages into smack-romedia, and we will post when we hear. Has the Updater helped? Several database issues were addressed in that, I believe. Please let either Vern or myself know if there are specific issues we can follow up on for you! An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Re: CFMX - I've never seen anything so unstable in my life
Rob Rohan wrote: We are having issues with the JDBC Drivers as well. We have several messages into smack-romedia, and we will post when we hear. Why not ask Microsoft? Macromedia has made sure that CF MX can use JDBC, so now it is up to the database vendors to provide working JDBC drivers. Just like with previous versions CF could use ODBC and it was up to the database vendor to provide a decent ODBC driver. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
RE: CFMX - I've never seen anything so unstable in my life
Sean, I have posted this a couple of times on MM's forums and in here but no real solution. I get this error that says Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Connection reset by peer: JVM_recv in socket input stream read Any ideas? Thanks, Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:13 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 10:56 US/Pacific, Rob Rohan wrote: We are porting cf5 to MX and had several sloppy coding errors, as well as some full fledged product errors. All in all, when the code is optimized for MX - which almost no currently existing cf code is - it runs like a champ. Glad to hear it (that it runs like a champ)! It's always good to hear from a (fairly) satisfied customer :) It is *very* obvious that the project was pushed out the door without being tested well, or at least tested in some sort of large production environment - probably do to the dropping stock. Hmm, that's a very unfair criticism. No products are error-free and CFMX was *extensively* tested for many months. The QA team accrued a vast pool of ColdFusion source code to test against and my team was developing heavy applications in CFMX and working with the product team on resolving issues. CFMX was probably tested more than any previous version of CF. However, you must bear in mind that CFMX is a complete rewrite on a new platform - that means there are bound to be *some* issues that will crop up. Some of these are a natural fall-out of the transition from C++ to Java and the use of different libraries (for example, the database access via JDBC). We are having issues with the JDBC Drivers as well. We have several messages into smack-romedia, and we will post when we hear. Has the Updater helped? Several database issues were addressed in that, I believe. Please let either Vern or myself know if there are specific issues we can follow up on for you! An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Re: CFMX - I've never seen anything so unstable in my life
On Monday, Oct 7, 2002, at 11:21 US/Pacific, Ben Densmore wrote: I have posted this a couple of times on MM's forums and in here but no real solution. I get this error that says Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Connection reset by peer: JVM_recv in socket input stream read Sounds like the database is dropping the connection. What's your: - OS / patch level - Database / patch level - Is the DB on a separate machine? - Which driver are you using specifically? - How often do you see this? - Does it seem to be connected to any other network issues? - Are there other errors in the CF logs? Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 fax: (415) 865-3113 -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CFMX - I've never seen anything so unstable in my life
Has the Updater helped? Several database issues were addressed in that, I believe. Please let either Vern or myself know if there are specific issues we can follow up on for you! Sorry for the interruption. I don't wish to take away from this thread but how do you tell if the CFUpdater has already been installed or not? I have a client who doesn't remember if he installed the updater or not. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
RE: CFMX - I've never seen anything so unstable in my life
Sean, Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:02 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 11:21 US/Pacific, Ben Densmore wrote: I have posted this a couple of times on MM's forums and in here but no real solution. I get this error that says Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Connection reset by peer: JVM_recv in socket input stream read Sounds like the database is dropping the connection. What's your: - OS / patch level - Database / patch level - Is the DB on a separate machine? - Which driver are you using specifically? - How often do you see this? - Does it seem to be connected to any other network issues? - Are there other errors in the CF logs? Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 fax: (415) 865-3113 -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life
The best way to get something resolved is to open an incident with 'em. It's rare you'll get an answer on the forum. :\ Stace -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:21 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Sean, I have posted this a couple of times on MM's forums and in here but no real solution. I get this error that says Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Connection reset by peer: JVM_recv in socket input stream read Any ideas? Thanks, Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:13 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 10:56 US/Pacific, Rob Rohan wrote: We are porting cf5 to MX and had several sloppy coding errors, as well as some full fledged product errors. All in all, when the code is optimized for MX - which almost no currently existing cf code is - it runs like a champ. Glad to hear it (that it runs like a champ)! It's always good to hear from a (fairly) satisfied customer :) It is *very* obvious that the project was pushed out the door without being tested well, or at least tested in some sort of large production environment - probably do to the dropping stock. Hmm, that's a very unfair criticism. No products are error-free and CFMX was *extensively* tested for many months. The QA team accrued a vast pool of ColdFusion source code to test against and my team was developing heavy applications in CFMX and working with the product team on resolving issues. CFMX was probably tested more than any previous version of CF. However, you must bear in mind that CFMX is a complete rewrite on a new platform - that means there are bound to be *some* issues that will crop up. Some of these are a natural fall-out of the transition from C++ to Java and the use of different libraries (for example, the database access via JDBC). We are having issues with the JDBC Drivers as well. We have several messages into smack-romedia, and we will post when we hear. Has the Updater helped? Several database issues were addressed in that, I believe. Please let either Vern or myself know if there are specific issues we can follow up on for you! An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFMX - I've never seen anything so unstable in my life
I get this error that says Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Connection reset by peer: JVM_recv in socket input stream read Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No This is just a shot in the dark, but you might try using a newer JVM. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CFMX - I've never seen anything so unstable in my life
On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Hmm, doesn't sound like an unusual setup. That's a very frequent error rate tho'... What is the full data source configuration, including Advanced Settings? Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
RE: CFMX - I've never seen anything so unstable in my life
Good idea. We're on Sun's 1.4.1 and so far so good. *crosses fingers* -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:58 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life I get this error that says Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Connection reset by peer: JVM_recv in socket input stream read Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No This is just a shot in the dark, but you might try using a newer JVM. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFMX - I've never seen anything so unstable in my life
Here are the settings for one Datasource, I put in some dummy data for datasource name etc.. All my datasources have these same settings. Data Source Name - Datasource Name Database - Database Name Server - 0.0.0.0 Port - 1433 Username Password Description Select Method - Direct Limit Connections - Not Checked Restrict connections to - Blank Maintain Connections - Checked String Format- Not Checked Timeout (min) - 20 Interval (min) - 7 Disable Connections - Not Checked Login Timeout (sec) - 30 CLOB - Not Checked BLOB - Not Checked Long Text Buffer (chr) - 64000 Blob Buffer(bytes) - 64000 Allowed SQL SELECT Create GRANT INSERT DROP REVOKE UPDATE ALTERStored Procedures DELETE Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:43 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Hmm, doesn't sound like an unusual setup. That's a very frequent error rate tho'... What is the full data source configuration, including Advanced Settings? Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life
Check the build number under Version Information in the admin. Anything less than 6,0,0,52311 then it's not installed. Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:13 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life Has the Updater helped? Several database issues were addressed in that, I believe. Please let either Vern or myself know if there are specific issues we can follow up on for you! Sorry for the interruption. I don't wish to take away from this thread but how do you tell if the CFUpdater has already been installed or not? I have a client who doesn't remember if he installed the updater or not. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CFMX - I've never seen anything so unstable in my life
One of my team said they saw this behavior when they were working with a PC (app server) that was not part of the same domain as the database server. Are both your web/app server and db server registered into the same Windows networking domain? On Monday, Oct 7, 2002, at 13:06 US/Pacific, Ben Densmore wrote: Here are the settings for one Datasource, I put in some dummy data for datasource name etc.. All my datasources have these same settings. Data Source Name - Datasource Name Database - Database Name Server - 0.0.0.0 Port - 1433 Username Password Description Select Method - Direct Limit Connections - Not Checked Restrict connections to - Blank Maintain Connections - Checked String Format- Not Checked Timeout (min) - 20 Interval (min) - 7 Disable Connections - Not Checked Login Timeout (sec) - 30 CLOB - Not Checked BLOB - Not Checked Long Text Buffer (chr) - 64000 Blob Buffer(bytes) - 64000 Allowed SQL SELECT Create GRANT INSERT DROP REVOKE UPDATE ALTERStored Procedures DELETE Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:43 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Hmm, doesn't sound like an unusual setup. That's a very frequent error rate tho'... What is the full data source configuration, including Advanced Settings? Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX - I've never seen anything so unstable in my life
Nothing changed on the SQL Server, correct? No one checked the Boost SQL Server priority on Windows NT checkbox or changed any SMP settings? Is ColdFusion the only thing that talks to SQL? Don't rule out coincidence. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:22 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Sean, Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:02 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 11:21 US/Pacific, Ben Densmore wrote: I have posted this a couple of times on MM's forums and in here but no real solution. I get this error that says Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Connection reset by peer: JVM_recv in socket input stream read Sounds like the database is dropping the connection. What's your: - OS / patch level - Database / patch level - Is the DB on a separate machine? - Which driver are you using specifically? - How often do you see this? - Does it seem to be connected to any other network issues? - Are there other errors in the CF logs? Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 fax: (415) 865-3113 -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CFMX - I've never seen anything so unstable in my life
Yes, they are on the same domain. I guess one thing that could possibly because it as I am thinking about it now is that the Database server is behind a firewall, I am just using a test server now, not a live server, which is not on a firewall. But our server that we use for production is not on a firewall either(which is running CF 4.5) and we don't have this problem. Thanks, Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 4:52 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life One of my team said they saw this behavior when they were working with a PC (app server) that was not part of the same domain as the database server. Are both your web/app server and db server registered into the same Windows networking domain? On Monday, Oct 7, 2002, at 13:06 US/Pacific, Ben Densmore wrote: Here are the settings for one Datasource, I put in some dummy data for datasource name etc.. All my datasources have these same settings. Data Source Name - Datasource Name Database - Database Name Server - 0.0.0.0 Port - 1433 Username Password Description Select Method - Direct Limit Connections - Not Checked Restrict connections to - Blank Maintain Connections - Checked String Format- Not Checked Timeout (min) - 20 Interval (min) - 7 Disable Connections - Not Checked Login Timeout (sec) - 30 CLOB - Not Checked BLOB - Not Checked Long Text Buffer (chr) - 64000 Blob Buffer(bytes) - 64000 Allowed SQL SELECT Create GRANT INSERT DROP REVOKE UPDATE ALTERStored Procedures DELETE Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:43 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: Here are the answers to your questions. - OS / patch level - Win2k SP3 - Database / patch level - SQL Server 7 SP4 - Is the DB on a separate machine? - Yes - Which driver are you using specifically? -macromedia.jdbc.MacromediaDriver - How often do you see this? - Happens daily about every 2-5 minutes - Does it seem to be connected to any other network issues? - We've never had any problems with CF 4.5 - Are there other errors in the CF logs? - No Hmm, doesn't sound like an unusual setup. That's a very frequent error rate tho'... What is the full data source configuration, including Advanced Settings? Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
