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 ALTER Stored 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=lists&body=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