No managed connection after pool limit reached

 

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

hanzpkView Public ProfileSend a private message to hanzpkFind all posts by hanzpk

  #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

OdysseeView Public ProfileSend a private message to OdysseeFind all posts by Odyssee