Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

apache - Coldfusion 9 MySQL communications link failure -


i've installed coldfusion 9, , working fine , it's connected mysql databse via coldfusion administrator datasrouce, error occuring infrequently, maybe 5 - 10 times day. don't know how recreate it, , if , refresh page goes away.

error executing database query. communications link failure last packet sent server 0 ms ago 

the error being caught coldfusion it's displaying user friendly message , emailing me problem.

almost of time pages load , work fine, , problem has happened since going cfmx7 cf9, both using mysql.

the mysql version using "5.0.77"

i've tried localhost , 127.0.0.1 host in datasource, makes no difference.

does have idea , how fix it? i've seen similar posts java don't see how translate fix across coldfusion? , mysql or apache problem anyway?

edit: unchecked maintain connections @ 11am yesterday (11th), , not had error since. getting 3 - 10 day, seems hopeful. i'll wait until tomorrow before confirming fixed. i'm using mysql 4/5 driver on 5.0.77

this issue discussed on adobe forums. appears suitable workaround enable validation query in coldfusion datasource definition such "select 1" (without quotes). coldfusion test every connection running simple query before letting page request use db connection. guarantee every db connection before use in application.

more details available at: http://forums.adobe.com/message/3396302#3396302


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -