Uploaded image for project: 'Geronimo'
  1. Geronimo
  2. GERONIMO-4222

Database pool unusable after database unavailable for awhile

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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:
      None
    • Environment:

      Red Hat Enterprise Linux Server v5.2

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

      Description

      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 (com.ibm.as400.access.AS400JDBCDriver)
      Pool Min Size: 0
      Pool Max Size: 100
      Blocking Timeout: 5000
      Idle Timeout: 15

        Attachments

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

          Activity

            People

            • Assignee:
              caijunj Jack Cai
              Reporter:
              dfrahm@teamhuber.com David Frahm
            • Votes:
              3 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: