Support Tomcat 7 Connection Pooling

XMLWordPrintable

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

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? 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: