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

Not sure what you mean by "direct query methods".

However, if what you mean is that you only use clsql:query (and not 
clsql:select) or that you dont store any objects across page requests, 
then you should not experience any errors.

Generally speaking (with-database (...) (clsql:query ...)) should not 
have any thread safety errors.

Hope this helps,
Russ Tyndall
Acceleration.net


On 8/4/2011 6:52 AM, Kushal Das wrote:
> On Wed, Aug 3, 2011 at 8:23 PM, Nathan Bird<[email protected]>  wrote:
>> Russ just wrote up a blog post that might illuminate the situation more:
>> http://russ.unwashedmeme.com/blog/?p=218
>>
>> Generally a quick check is:  make sure you aren't pulling an object
>> from the database and using it in multiple requests. The view-class
>> objects keep a reference to the database they originally came from and
>> use that database connection in the future even if you try to point it
>> at a different database.
> The blog post helped me to understand few things, thanks :)
> Still one question, if I try to use direct query methods within
> with-database , will that work ?
>
> Kushal