Help : where can I view/delete jboss session ? Getting this "No ManagedConnections available within configured blocking timeout"

getting this error...

2008-02-01 15:14:10,904 ERROR [web.struts.support.SrsLoginAction] SQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))
2008-02-01 15:14:10,904 INFO  [STDOUT] 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] ))
2008-02-01 15:14:10,905 INFO  [STDOUT]  at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)



Can I view the list of sessions that are open ? I want to delete some of them to allow freeing up of connections ..

This app sits in a deploy dir with other critical production apps so If i change the ds.xml file to add

1) Incresing the min and max connection Pool Size for data source.
<min-pool-size>10</min-pool-size>
<max-pool-size>100</max-pool-size>

it wil redeploy all the other apps

Is there anything I can do on the database side ? there is no limit on the connections allowed to the db username being used

Thanks


kingkenny86132Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

joebednarzCommented:
There is a PROFILE setting that limits the number of connections by user name... but that doesn't sound the problem you are experiencing.

In case you want to know, it would be set up like this:

ALTER PROFILE some_profile_name LIMIT sessions_per_user 10;

ALTER USER my_user PROFILE some_profile_name;
0
joebednarzCommented:
BTW, to delete a session, you can do it this way, however, be careful... or request it of your DBA:

SQL> SELECT sid, serial, osuser, program FROM v$session;

       SID    SERIAL# OSUSER                         PROGRAM
---------- ---------- ------------------------------ ---------------
        43      11215 USER1                          SQLPLUSW.EXE
        33       5337 USER2                          JAVA.EXE


SQL> ALTER SYSTEM KILL SESSION '43,5337';
0
bpmurrayCommented:
There are a couple of possible reasons for this:
1. The DB allows fewer connections than you specify to JBOSS, and once that limit is exceeded, the DB throws the exception.
2. You don't close *all* your connections. Don't assume that closing them all in your last piece of code will do the trick. You have to close all connections, including prepared statements and resultsets .

To track where the problems occur, have a look at http://jamonapi.sourceforge.net/#monitoringsqlcommands.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.