Support Tomcat 7 Connection Pooling

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Won't Do
    • Component/s: None

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.

      The work to support Tomcat 7 did not include switching to the recommended and long term (tomcat 8+) connection pool (See the apache tomcat site http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html).

      When I use this with Greenhopper the batch upgrade process hangs (this also happened on the importing a backup) with application deadlocks and maybe instead of failing it is catching and retrying the transactions. 

      > org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO cwd_group (ID, group_name, lower_group_name, active, local, created_date, updated_date, description, lower_description, group_type, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Deadlock found when trying to get lock; try restarting transaction)

            Assignee:
            Unassigned
            Reporter:
            Mark Diskin
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: