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

Paul Fremantle paul at wso2.com
Tue Apr 3 00:37:23 PDT 2007


+1

Can you get me a build to test with MySQL?

Paul

Damitha Kumarage wrote:
> 
>> 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
> 
> 
> _______________________________________________
> Wsf-c-dev mailing list
> Wsf-c-dev at wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/wsf-c-dev
> 

-- 
Paul Fremantle
VP/Technical Sales, WSO2
OASIS WS-RX TC Co-chair

http://bloglines.com/blog/paulfremantle
paul at wso2.com
(646) 290 8050

"Oxygenating the Web Service Platform", www.wso2.com





More information about the Wsf-c-dev mailing list