On 12/13/07, jbi joe <[EMAIL PROTECTED]> wrote: > > After about 20+ concurrent BPEL Assembly instances are started, > I get an out of Cnnections error. Im using the ODE engine ( also > posted to ODE list - no help ) I had been using the EMBEDDED > derby db. It looks like its NOT using POOLED CONNECTION. > Increasing the Pool size has no effect. DO I need to set up DERBY > to be PooledCOnnection? If so, is there a HOWTO. Is it better > to use an EXTERNAL mysql or postgress database?
Yes, I would recommend using an external datasource (from your application server). The embedded Derby datasource is for convenience and not meant for production/benchmarking use since it does not provide all the necessary tuning parameters to achieve peak QoS levels. alex
