[wsf-c-dev] sqlite fail with multple processes.

[Damitha Kumarage]

> When testing sandesha2c with multiple requests simultaneously it break.
> I suspect this is beause sqlite fails in this scenario. I wrote four 
> tests
> with sqlite and mysql  to test them in multi-process and multi-thread 
> environments
> where each thread/process insert a record into a database table.
> (see attached). sqlite fail with multi-process test where it only 
> insert only one
> record whereas it should insert 10 records. I will try a mysql storage 
> manager
> which will only take about 2 days for sandesha2c and see whether the 
> problem
> still exist.

I tried linux/php/sandesha2c with mysql storage manager with multiple 
requests
and it seems to run stable whereas the same thing fails when run 
mutliple times
with sqlite storage manager for sandesha2c. So I suggest to use the mysql
storage manager as the default for sandesha2c. However this need to be 
tested
in windows/php/sandesha2c as well before coming to a decision.

Damitha