1. Geronimo
  2. GERONIMO-4222

Database pool unusable after database unavailable for awhile


    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.2, 2.1.3, 2.1.4
    • Fix Version/s: None
    • Component/s: None
    • Security Level: public (Regular issues)
    • Labels:
    • Environment:

      Red Hat Enterprise Linux Server v5.2

      WAS-CE v2.0.0.1, based on Geronimo v2.0.2


      I have frequent trouble with my database pool to an AS/400. The database is taken down every night for backup, and at least once a week the connection pool is unusable after the database comes back up. Restarting the connection pool makes everything work again.

      We are new to Geronimo/WAS-CE – just this one app on one server – so I don't have anything to compare to. However, we have had this same issue with a couple 1.x/1.1.x versions before we upgraded to v2. Also, there are several WebSphere (full WAS, not WAS-CE) apps that do not have this trouble.

      Configuration Info
      Driver: JTOpen v6.1 (
      Pool Min Size: 0
      Pool Max Size: 100
      Blocking Timeout: 5000
      Idle Timeout: 15

      1. before and after wasce restart.txt
        26 kB
        David Frahm
      2. connector.patch
        18 kB
        Jack Cai
      3. PGtrial.patch
        4 kB
        Jack Cai
      4. stacktrace.txt
        21 kB
        Thad West
      5. tranql-connector-derby-embed-local-1.5-SNAPSHOT.rar
        91 kB
        Jack Cai
      6. tranql-connector-derby-embed-xa-1.5-SNAPSHOT.rar
        91 kB
        Jack Cai
      7. tranql-connector-mysql-local-1.3-SNAPSHOT.rar
        87 kB
        Jack Cai
      8. tranql-connector-mysql-xa-1.3-SNAPSHOT.rar
        87 kB
        Jack Cai
      9. tranql-connector-postgresql-common-1.1.jar
        10 kB
        Jack Cai
      10. tranql-connector-postgresql-local-1.2-SNAPSHOT.rar
        86 kB
        Jack Cai
      11. tranql-connector-postgresql-xa-1.2-SNAPSHOT.rar
        86 kB
        Jack Cai
      12. vendors.patch
        9 kB
        Jack Cai



          • Assignee:
            Jack Cai
            David Frahm
          • Votes:
            3 Vote for this issue
            4 Start watching this issue


            • Created: