Uploaded image for project: 'Pentaho BA Platform'
  1. Pentaho BA Platform
  2. BISERVER-1069

C3P0 jar and config example should be included in the MySQL PCI distribution

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 1.7.1.GA, 2.0.GA
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      When using MySQL as the platform repository, the server loses connection to MySQL overnight (after periods of inactivity) and the server has to be restarted. By utilizing c3p0 for connection pooling we can avoid this problem. See Marc's forum post here: http://forums.pentaho.org/showthread.php?t=54939&highlight=c3p0&page=5

      We need to include the c3p0 solution as part of the MySQL distribution.

        Attachments

          Activity

            People

            • Assignee:
              dkincade David Kincade
              Reporter:
              jcornelius Jared Cornelius
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: