You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@servicemix.apache.org by jbi joe <jo...@daggerpoint.net> on 2007/12/13 10:06:40 UTC
Out of COnnections - BPEL error
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?
TIA
--
View this message in context: http://www.nabble.com/Out-of-COnnections---BPEL-error-tp14312356s12049p14312356.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: Out of COnnections - BPEL error
Posted by Alex Boisvert <bo...@intalio.com>.
In the user guide,
http://ode.apache.org/user-guide.html#UserGuide-UsingaJNDIDataSourceunderServiceMixJBI
On 12/14/07, jbi joe <jo...@daggerpoint.net> wrote:
>
>
> How is the EXTERNAL database supposed to be
> created/initialized/propogated/started.
> Who Does what to WHOM! :)
> I tried to create a postgres external db. Looks like I have running, but
> upon
> connecting to the DB I get a stack trace saying the DB is NOT created or
> initialized. ALbeit, I did do the proverbial creadb, initdb commands
> from
> the postgres bin. Also, I manually started the postgres database,i,e,
> postmaster -D mydatabasepath/databasename
> and it looks good up to there. Servicemix starts OK, appears to see the
> JNDI
> data source, but deploying the ODE engine fails to be able to connect up.
> I dont hae a stack trace at the moment, but I can get a snapshot if need
> be..
> As always any help greatly appreaciated.
> TIA
>
>
> Alex Boisvert wrote:
> >
> > In ode-jbi.properties, use EXTERNAL mode and provide the JNDI lookup for
> > your datasource.
> >
> > alex
> >
> > [1]
> >
> http://svn.apache.org/repos/asf/ode/branches/APACHE_ODE_1.1/jbi/src/main/jbi/ode-jbi.properties
> >
> > On 12/13/07, Jamie Penney <jp...@ec.auckland.ac.nz> wrote:
> >>
> >> How does one go about changing the datasource? I am looking at doing a
> >> bit of benchmarking and a better real-world representation would be
> good.
> >>
> >> Thanks,
> >> Jamie Penney
> >>
> >> Alex Boisvert wrote:
> >> > 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
> >> >
> >> >
> >>
> >> --
> >> Jamie Penney
> >>
> >> http://www.jamiepenney.co.nz
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Out-of-COnnections---BPEL-error-tp14312356s12049p14332296.html
> Sent from the ServiceMix - User mailing list archive at Nabble.com.
>
>
Re: Out of COnnections - BPEL error
Posted by jbi joe <jo...@daggerpoint.net>.
How is the EXTERNAL database supposed to be
created/initialized/propogated/started.
Who Does what to WHOM! :)
I tried to create a postgres external db. Looks like I have running, but
upon
connecting to the DB I get a stack trace saying the DB is NOT created or
initialized. ALbeit, I did do the proverbial creadb, initdb commands
from
the postgres bin. Also, I manually started the postgres database,i,e,
postmaster -D mydatabasepath/databasename
and it looks good up to there. Servicemix starts OK, appears to see the
JNDI
data source, but deploying the ODE engine fails to be able to connect up.
I dont hae a stack trace at the moment, but I can get a snapshot if need
be..
As always any help greatly appreaciated.
TIA
Alex Boisvert wrote:
>
> In ode-jbi.properties, use EXTERNAL mode and provide the JNDI lookup for
> your datasource.
>
> alex
>
> [1]
> http://svn.apache.org/repos/asf/ode/branches/APACHE_ODE_1.1/jbi/src/main/jbi/ode-jbi.properties
>
> On 12/13/07, Jamie Penney <jp...@ec.auckland.ac.nz> wrote:
>>
>> How does one go about changing the datasource? I am looking at doing a
>> bit of benchmarking and a better real-world representation would be good.
>>
>> Thanks,
>> Jamie Penney
>>
>> Alex Boisvert wrote:
>> > 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
>> >
>> >
>>
>> --
>> Jamie Penney
>>
>> http://www.jamiepenney.co.nz
>>
>
>
--
View this message in context: http://www.nabble.com/Out-of-COnnections---BPEL-error-tp14312356s12049p14332296.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: Out of COnnections - BPEL error
Posted by Alex Boisvert <bo...@intalio.com>.
In ode-jbi.properties, use EXTERNAL mode and provide the JNDI lookup for
your datasource.
alex
[1]
http://svn.apache.org/repos/asf/ode/branches/APACHE_ODE_1.1/jbi/src/main/jbi/ode-jbi.properties
On 12/13/07, Jamie Penney <jp...@ec.auckland.ac.nz> wrote:
>
> How does one go about changing the datasource? I am looking at doing a
> bit of benchmarking and a better real-world representation would be good.
>
> Thanks,
> Jamie Penney
>
> Alex Boisvert wrote:
> > 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
> >
> >
>
> --
> Jamie Penney
>
> http://www.jamiepenney.co.nz
>
Re: Out of COnnections - BPEL error
Posted by Jamie Penney <jp...@ec.auckland.ac.nz>.
How does one go about changing the datasource? I am looking at doing a
bit of benchmarking and a better real-world representation would be good.
Thanks,
Jamie Penney
Alex Boisvert wrote:
> 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
>
>
--
Jamie Penney
http://www.jamiepenney.co.nz
Re: Out of COnnections - BPEL error
Posted by Alex Boisvert <bo...@intalio.com>.
On 12/13/07, jbi joe <jo...@daggerpoint.net> 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