1 Reply Latest reply on May 23, 2007 3:57 AM by vickyk

    Connection Pooling Issue ?

    jsbhangra

      Hi All ..

      I am using Jboss Level connection pooling in my application ...
      my oracle-ds.xml reads as :

      <min-pool-size>10</min-pool-size>
       <max-pool-size>500</max-pool-size>
       <max-idle-timeout>0</max-idle-timeout>
       <blocking-timeout-millis>30000</blocking-timeout-millis>
       <idle-timeout-minutes>15</idle-timeout-minutes>


      I am connecting with oracle 10g express database .

      Now when i send 10 request @ 0.1 seconds i.e. 100 request per second .... to my exception

      after some requests following exception occurs :

      [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@1e8bf76
      java.lang.Throwable: STACKTRACE
       at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290)
       at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:417)
       at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
       at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)


      Help me out ..
      how to handle this ..
      do i need some other pooling mechanism ?

      Regards ,
      Jasdeep
      ???? ?? ???? ???? , ??? ???? ???? ??? ??? | ???? '??? ????? ?? ??? ???? ?? ?? ?? |