[jira] [Updated] (OFBIZ-7344) db connections remain open and unused on startup

["Gareth Carter (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-7344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gareth Carter updated OFBIZ-7344:
---------------------------------
    Attachment: DatabaseUtil.patch

This patch removes the need for getDatabaseMetaData to create a connection. I have created 2 new methods to retrieve the information from DatabaseMetaData and close connections as required.

My initial patch closed the connection after retrieving the database meta data but this may cause issues later if connection is flagged as closed

> db connections remain open and unused on startup
> ------------------------------------------------
>
>                 Key: OFBIZ-7344
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-7344
>             Project: OFBiz
>          Issue Type: Bug
>          Components: ALL COMPONENTS
>    Affects Versions: Trunk
>            Reporter: Gareth Carter
>            Priority: Minor
>         Attachments: DatabaseUtil.patch
>
>
> When ofbiz starts and checks the database, it will leave open connections and will not get reused.
> If you run Check/Update database from webtools, you can see a new connection is created for your selected group
> As far as I can tell, the problem lies in DatabaseUtil.getDatabaseMetaData. If the parameter connection is null, a new connection object is created but not closed (like any resource should be!)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)