Re: Odd db error
Rob, This could be a few little things, but most importantly, hit up the CFMX hot fixes page: http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm and make sure you have the latest database drivers (v 3.3). While you're there, you may want to look into all the other ones. I do really recommend you install them all, especially anything related to databases, cfquery and cfqueryparam. -nathan Rob wrote: > I've just finished updating a site from MX6.0 to MX6.1 and there is a > (very very) long process that will eventually throw the following > error into the exception log, but never stops the request - it just > hangs the resources. > > "Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]No > more data available to read. The specific sequence of files included > or processed is: \blahblah.cfm " > coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing > Database Query. > > I've searched google and haven't found much. This is a schedule task > process that runs at like 3:00AM so I'd like it not to do that :) > > There are ... several ... thing that the code should do that it > doesn't (like db timeouts and such), but I am asked why it worked in 6 > and not 6.1 (this app is going away and they don't really want to > rewrite large portions of the code) > > Winders2K > MX Version: 6,1,0,63958 > SQL2K > > Any help / pointers / links would most appreciated > > Thanks > Rob > > -- > ~The cfml plug-in for eclipse~ > http://cfeclipse.tigris.org > ~open source xslt IDE~ > http://treebeard.sourceforge.net > ~open source XML database~ > http://ashpool.sourceforge.net > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Odd db error
On Wed, 21 Jul 2004 14:35:05 -0700, Nathan Strutz <[EMAIL PROTECTED]> wrote: > Rob, > > This could be a few little things, but most importantly, hit up the CFMX > hot fixes page: > > http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm > > and make sure you have the latest database drivers (v 3.3). While you're > there, you may want to look into all the other ones. I do really > recommend you install them all, especially anything related to > databases, cfquery and cfqueryparam. Updated the macromedia_drivers.zip one and that seems to have cleared up the problem. Time will tell, but it looks good. Thanks Nathan :) -- ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~open source XML database~ http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Odd db error
You now know everythingthere is no more data...please wipe your brain clean and press "Re-Start" ;-) Sorry had to. I've seen that error before, but can't remeber what caused it. Did you give Google Groups a whirl yet for that error? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: DeMarco, Alex To: CF-Talk Sent: Wednesday, November 12, 2003 11:51 AM Subject: Odd db error What would cause this error? "No More data avilable to read" It's a simple query, that has never returned an error before... - Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Odd db error
It's a DataDirect 3.2 JDBC generic error. It happens under load. AFAIK, Macromedia is looking at it. Solving it is difficult... First, make sure you've installed this patch: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_sqlserver_c pu.htm Second, check this thread on the CF forums to get instructions on how to downgrade to the DataDirect 3.1 drivers (from CFMX 6.0) -- I didn't have luck with this one: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6&threadid= 684306 Third, you can use your vendor-specific drivers (for example SQL Server, use Microsoft's JDBC driver), check this page for info: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_config_mssql2 000.htm -nathan strutz -Original Message- From: DeMarco, Alex [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 12:51 PM To: CF-Talk Subject: Odd db error What would cause this error? "No More data avilable to read" It's a simple query, that has never returned an error before... - Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Odd db error
This is a known bug with CFMX 6.1. Look here: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6&threadid=684306 The workaround sucks, but you might not have any choice. - Original Message - From: Bryan Stevenson <[EMAIL PROTECTED]> Date: Wednesday, November 12, 2003 12:56 pm Subject: Re: Odd db error > You now know everythingthere is no more data...please wipe > your brain clean and press "Re-Start" ;-) > > Sorry had to. > > I've seen that error before, but can't remeber what caused it. > Did you give Google Groups a whirl yet for that error? > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > - Original Message - > From: DeMarco, Alex > To: CF-Talk > Sent: Wednesday, November 12, 2003 11:51 AM > Subject: Odd db error > > > What would cause this error? > > "No More data avilable to read" > > It's a simple query, that has never returned an error before... > > - Alex > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Odd db error
On Wednesday 12 Nov 2003 20:12 pm, Nathan Strutz wrote: > Solving it is difficult... But apperently will be addressd in a patch in a few weeks time. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]