Re: Issue while simultaneously accessing mysql db using clsql on a hunchentoot server

On Wed, Aug 03, 2011 at 05:47:16PM +0530, Kushal Das wrote:
> Hi,
> 
> I am writing a small webapp with mysql backend and hunchentoot as a framework.
> using (connect `("host" "dbname" "username" "password")
> :database-type :mysql) to connect , works well if only 1 person tries
> to connect to the system. But with any simultaneous access , the db
> connection dies. I am getting "Error 2006 / MySQL server has gone
> away".
> 
> Can any one can point me to some example on how to solve this and have
> simultaneous access?

I hope you are aware of the fact that hunchentoot is a multi-threaded
application and you need to have a dedicated database connection for
each thread. Otherwise you'll get into big trouble ....

 HTH Ralf Mattes

> Kushal
> -- 
> http://fedoraproject.org
> http://kushaldas.in
> _______________________________________________
> CLSQL mailing list
> [email protected]
> http://lists.b9.com/cgi-bin/mailman/listinfo/clsql