Menu

Connection pooling problem

Developers
2007-10-30
2013-03-08
  • Armen Rizal (Goodwill)

    I hit this error lately after applying C3p0:

    ..............................14:46:10,545  WARN BasicResourcePool:1222 - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 1d0e2c9 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30).
    14:46:10,779  WARN BasicResourcePool:1222 - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 1d0e17a -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30).
    14:46:10,779  WARN BasicResourcePool:1222 - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at d8fd1a -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30).
    .14:46:10,839  WARN SettingsFactory:109 - Could not obtain connection metadata
    java.sql.SQLException: Connections could not be acquired from the underlying database!

    Anyone know what's wrong ?

    Armen

     
    • Carlos Ruiz

      Carlos Ruiz - 2007-10-30

      Hi Armen, since the integration of c3po I'm having similar problems.

      When the database connection can't be acquired the program don't fail but goes in an endless loop.

      The same happens in the server - if the server can't connect to oracle it goes in an endless loop of the same error.

      Maybe we can report this as a bug for the new c3po implementation.

      Regards,

      Carlos Ruiz

       
    • João Vieira

      João Vieira - 2007-11-14

      I belive that there are some problem about closing connections:

      I using WAN connection by oracle (of course webstart the client), and opened several windows (so, po, business partner, invoice and so on).. after a lot of windows opened (or another client started with some windows opened at the same time), the system get into this loop, and it's even impossible to close any of the opened windows... just killing java process and shutting down the server i can get the connections back..

      it happens with LAN connections too. i even upgraded jdbc drivers, but without success.

      i'm using oracle 10g, java 1.6 u3, windows server 2003 r2 in a pentium d 4gb ram system.

       
    • João Vieira

      João Vieira - 2007-11-14

      complement: to monitor oracle sessions:

      SELECT SID, SERIAL#, STATUS,SERVER
        FROM V$SESSION
        WHERE USERNAME = 'ADEMPIERE';

       

Log in to post a comment.