db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Courcoux <pe...@courcoux.biz>
Subject Re: Problems with Oracle
Date Mon, 03 Feb 2003 11:37:45 GMT
Hi Colin,

I had this problem with postgresql. Try the jdbc2 pool ( next section
down in Torque.props ) instead. Switching pooling implementations solved
this for me.

Regards,

Peter

On Mon, 2003-02-03 at 11:28, Colin Chalmers wrote:
> Hi guys,
> 
> We're experiencing some problems with Oracle (8) and Torque (3).
> 
> It would appear that connections are not being closed properly. After running for a while
we get the following error-code
> 
> ORA-00020: Maximum number processes (%s) is exceeded
> 
> We tried setting the following but it doesn't seem to help
> 
> 1. shared_pool_size = 80000000 in initFoo.ora
> 2. processes = 200 in initFoo.ora
> 3. torque.dsfactory.default.pool.defaultMaxConnections=100 in Torque.properties
> 
> Any ideas?
> 
> /c
-- 
Peter Courcoux <peter@courcoux.biz>

Mime
View raw message