-
1. Re: No ManagedConnections available within configured blocki
neotyk Apr 19, 2006 2:14 PM (in response to udayn)Hi udyan,
Increasing connection pool should be connected with increasing max allowed connections in RDBMS.
Probably your Oracle doesn't allow JBoss to connect max-pool-size times, or you have resource leak (do you close every connection?).
HTH,
Hubert. -
2. Re: No ManagedConnections available within configured blocki
udayn Apr 22, 2006 8:09 AM (in response to udayn)Hbert,
We are clsoing all connections
About the "Orcale doesn't allow JBoss to connect max-pool-size times" thing, is there any way to moniter this from Jboss? or does JBoss prints some info. related to this in logs? -
3. Re: No ManagedConnections available within configured blocki
neotyk Apr 24, 2006 9:43 AM (in response to udayn)Let's say your DB accepts 10 connections maximum.
You have configured JBoss to use 11 connections (in 3 different DS).
As long as 10 connections are used everything works just fine, when 11-th conn is needed you have exception from your first message.
You have to check your RDBMS configuration, and any *-ds.xml definition that uses this DB.
Good luck, -
4. Re: No ManagedConnections available within configured blocki
udayn Apr 25, 2006 2:26 AM (in response to udayn)neotyk,
I ahv alredy taken care of that. We have five data sources configured. The total of max connactions specified from all five pools goes to 250.
We have 750 connection limit on Oracale DB
Below mentioned are the settings on Oracale server
-------------------------------------------------
PROCESS=750
SESSION=810
TRANSACTION=913
OPEN_CURSOR=5000 -
5. Re: No ManagedConnections available within configured blocki
neotyk Apr 25, 2006 3:37 AM (in response to udayn)You can try configuration with low numbers, like 1 or 2 connectcions per DS (it is easier to see what's wrong).
I think this is Oracle question.
This forum is about JBoss Performance Tuning, not Oracle configuration.
Ask local Oracle expert. -
6. Re: No ManagedConnections available within configured blocki
talm Jun 13, 2006 5:01 AM (in response to udayn)hey kungfoo - this happens on mysql as well. its a jboss problem. if you dont know the answer, thats ok too.
-
7. Re: No ManagedConnections available within configured blocki
neotyk Jun 13, 2006 5:15 AM (in response to udayn)This is performance tuning forum.
Please contact me be mail od Jabber (details in profile).
Best wishes, -
8. Re: No ManagedConnections available within configured blocki
sauser Aug 26, 2006 8:33 AM (in response to udayn)Hi,
I am using Jboss 4.0.2 and encountering the same No ManagedConnections exception after the blocking timeout which I believe leads to Transaction Timeout and Transaction Rollback exception -
Conn-pool configurations are
Min-pool-Size = 10
Max-pool-Size = 80
Blocking timeout = 30000 ms
stateless session bean configurations are as follows :
Max Bean instance pool size = 80
There does not seem to be any connection leaks in the application.
I have also tried adding strictMaximumSize in the session beans dd so as to restrict the concurrent beans accessing the connection pool but that does not solve the problem.
The expected load on application is somewhere around 300 concurrent threads (atmost).
Will altering of Basic Thread pool configurations help?
Are there any other configurations which I might be missing or have misconfigured?
Awaiting reply???
Regards,
sauser -
9. Re: No ManagedConnections available within configured blocki
wandi Aug 31, 2006 4:30 PM (in response to udayn)Man, it could sounds stupid but you close every connection? I have a similar problem and my app was using more than one datasoure, at end I don close every connection (for each datasorce)... so the problem of ManagedConnection arise.
...} finally { if (pstmYY != null) pstmYY.close(); if (pstmXX != null) pstmXX.close(); if (connAA != null) connAA.close(); if (connBB != null) connBB.close(); }
-
10. Re: No ManagedConnections available within configured blocki
stevesouza Aug 31, 2006 9:23 PM (in response to udayn)If you can use a jamon proxy driver connection you will be able to see if you have closed all of your db connections or not. http://www.jamonapi.com
-
11. Re: No ManagedConnections available within configured blocki
bilange Nov 12, 2006 10:28 PM (in response to udayn)Did you ever find what the issue is/was?
I'm seeing the same problem with Postgres... -
12. Re: No ManagedConnections available within configured blocki
plexiq Nov 14, 2006 7:35 AM (in response to udayn)Also having the same problem on Postgres.
Any hints highly welcome. (I did tipple-check any connection-closing code.)
I ll try the jamonapi.com proxy to check again tho. -
13. Re: No ManagedConnections available within configured blocki
bilange Nov 17, 2006 11:51 AM (in response to udayn)It seems that our pb went away.
Our initial code was closing connections only (in the finally clause) assuming that this will de facto close it.
It seems that it's not enough for this pool. In also closing resultsets and prepared statements, our leak is now gone. Apparently some non closed objects in the connection prevent to close it properly. -
14. Re: No ManagedConnections available within configured blocki
bilange Nov 17, 2006 1:27 PM (in response to udayn)I spoke too soon... we still see a leakage...