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]

Shoshould I configure something else?

Thank you,
Helmy

Attached files

Server.zip (8.6 kb, 3 views)

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

Hanzpk

View Public Profile

Send a private message to hanzpk

Find all posts by hanzpk

#2 02-21-2007, 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

Odyssee

View Public Profile

Send a private message to Odyssee

Find all posts by Odyssee