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

Database pool unusable after database unavailable for awhile

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.2, 2.1.3, 2.1.4
    • None
    • None
    • Security Level: public (Regular issues)
    • None
    • 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. before and after wasce restart.txt
          26 kB
          David Frahm
        2. connector.patch
          18 kB
          Jun Jie Cai
        3. PGtrial.patch
          4 kB
          Jun Jie Cai
        4. stacktrace.txt
          21 kB
          Thad West
        5. tranql-connector-derby-embed-local-1.5-SNAPSHOT.rar
          91 kB
          Jun Jie Cai
        6. tranql-connector-derby-embed-xa-1.5-SNAPSHOT.rar
          91 kB
          Jun Jie Cai
        7. tranql-connector-mysql-local-1.3-SNAPSHOT.rar
          87 kB
          Jun Jie Cai
        8. tranql-connector-mysql-xa-1.3-SNAPSHOT.rar
          87 kB
          Jun Jie Cai
        9. tranql-connector-postgresql-common-1.1.jar
          10 kB
          Jun Jie Cai
        10. tranql-connector-postgresql-local-1.2-SNAPSHOT.rar
          86 kB
          Jun Jie Cai
        11. tranql-connector-postgresql-xa-1.2-SNAPSHOT.rar
          86 kB
          Jun Jie Cai
        12. vendors.patch
          9 kB
          Jun Jie Cai

        Activity

          People

            caijunj Jun Jie Cai
            dfrahm@teamhuber.com David Frahm
            Votes:
            3 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: