How to flush Connection in jBoss?

[ramsbuddha]

Hi All,

here I have a doubt on how to configure to force jboss to flush database connection after certain time.

Here I have come across some flush() method in JBossManagedConnectionPool.
is that method can be used in this scenario, if so How can we do so.

is there a way to do this by some configuraiton changes rather than programatically.

Thanks
Rams

[peterj]

Try this, Using the jmx console (http://localhost:8080/jmx-console), go to the jboss.jca:name=XXX,service=ManagedConnectionPool MBean (where XXX is the datasource name). Change the pool sizes and timeout value. Then wait for the timeout and the connections should be closed.

Also, you can set the pool sizes and timeout in the *-ds.xml file:

<datasources>
 <local-tx-datasource>
 <jndi-name>someds</jndi-name>
 ...
 <min-pool-size>10</min-pool-size>
 <max-pool-size>100</max-pool-size>
 <idle-timeout-minutes>15</idle-timeout-minutes>
 </local-tx-datasource>
</datasources>

[ramsbuddha]

Hi Peter,

Thanks for your suggestion. I think your first suggestion can be done from JMX console and your second suggestion is about flushing the connections which are idle.

Here my requirement is that, we need to flush all the connections whether they are idle or in use(should be flushed after the usage).

Can you please suggest me what can we do in this scenario.
Note:-I would like to know how to use JBossManagedConnectionPool.flush().

Thanks
Rams

[peterj]

ramsbuddha, please do not ask the same question in multiple posts. Since Vicky answered your other post, lets continue the discussion there.

http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4194007

[ramsbuddha]

Hi Peter,

I never thought of asking the same question and will not let this happen.

Thanks

Rama