No managed connection after pool limit reached

最新推荐文章于 2022-08-02 05:19:55 发布

sduzhijian

最新推荐文章于 2022-08-02 05:19:55 发布

阅读量962

点赞数

文章标签： database nested browser oracle date

http://forums.pentaho.org/showthread.php?t=51746

No managed connection after pool limit reached

i am using pentaho (1.2.0-470 RC3) with oracle 9i database for my data
i haven't migrate any objects from hypersonic database
i got this error :
org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))
[i've attached the whole server.log and hibernate.cfg.xml]

i've investigated into database and found that after number of sessions
exceeded connection.pool_size in hibernate.cfg.xml, pentaho refuses connection
if i understand correctly, shouldn't connections which are unused are pooled and be ready to be reused?
[i've closed all the browser opening pentaho]

should i configure something else?

thank you,
helmy

Attached Files

server.zip (8.6 KB, 3 views)

Last edited by hanzpk; 02-21-2007 at 03:41 AM. Reason: attach

# 2

02-21-2007, 11:44 PM

hanzpk

Member

Join Date: Mar 2007

Posts: 61

Hi,

Maybe you change the value of "MaximumPoolSize" (the default value seems to be 10)

This parameter is set in either jboss-minimal.xml and jboss-service.xml; you can find these files under pentaho-demo/jboss/server/default/conf

Hope this helps

Regards
Odyssee