Uploaded image for project: 'Spring Roo'
  1. Spring Roo
  2. ROO-2433

DBCP connection pool is not aware when a database connection is unavailable

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Complete
    • Affects Version/s: 1.1.4.RELEASE
    • Fix Version/s: 1.1.4.RELEASE
    • Component/s: PERSISTENCE
    • Labels:
    • Environment:
      Linux Ubuntu 10.10, Apache Maven 3.0.2, Java 1.6.0_23, PostgreSQL 8.2.9, Commit b098cf6dad4ace726f52ec10fba5b6618d960787

      Description

      You can reproduce the issue restarting the database server while application running.

      See problem explanation and possible resolution:

      DBCP configuration properties:

      Configuration properties summary that solves the problem:

              <property name="validationQuery" value="SELECT 1"/>
              <property name="testOnBorrow" value="true"/>
              <property name="testOnReturn" value="true"/>
              <property name="testWhileIdle" value="true"/>
              <property name="timeBetweenEvictionRunsMillis" value="1800000"/>
              <property name="numTestsPerEvictionRun" value="3"/>
              <property name="minEvictableIdleTimeMillis" value="1800000"/>
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stewarta Alan Stewart
              Reporter:
              mmartinez Mario Martínez Sánchez - gvNIX - DISID
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0.25d
                  0.25d
                  Remaining:
                  Remaining Estimate - 0.25d
                  0.25d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified