I am having the same issue, with CF8/MySql 5 on my installation of BlogCFC, and haven't seen any solutions thus far. The problem is intermittent but it seems to happen pretty regularly.
The BlogCFC forum at RIAforge has this post: http://www.coldfusionjedi.com/forums/messages.cfm?threadid=83FA26F7-19B9-E658-9D258B669DE98D60 And I also posted there: http://www.coldfusionjedi.com/forums/messages.cfm?threadid=2BDF68EF-19B9-E658-9DDB2C6260E2CD89 Not saying it's BlogCFC related specifically, but there is some code in there that seems to bring up the JDBC database connectivity issue. Not sure what the problem is though, everything there looks hunky dory to me. -- Josh ----- Original Message ----- From: "Andy Matthews" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Monday, January 28, 2008 9:16 PM Subject: ColdFusion, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword? > I've been dealing with a very odd, seemingly fringe issue and wanted to > post about it. I believe I figured out how to get around it, but I'm not > sure what's causing it. > > My host is running the following apps/versions: > > ColdFusion: 8,0,0,176276 > MySQL: 5.0.45-community-nt > > I have a dynamic query that I'm calling via a CFC. On my environment it > works just fine, but on my host's servers, calling this specific query > returned a "Communications Link Failure" error. After doing some > debugging, commenting out various portions of the query, etc. I finally > tracked it down to my LIMIT keyword, which previously used cfqueryparams1. > It appears that when using this unique combination of things, I get this > error. But when I remove them, and just use plain old pounded variables, > it works. > > Does anyone know anything about this, why it's happening, and what I might > do for my host? Is it possible that they're just running a few point > releases behind? Doing some online research for that error, I find some > posts from Ray Camden (and others) suggesting that it might be the JDBC > drivers. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
