[
https://issues.apache.org/jira/browse/OFBIZ-7344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Le Roux closed OFBIZ-7344.
----------------------------------
Resolution: Fixed
Fix Version/s: 15.12.01
14.12.01
Thanks Gareth,
I was unable to "see a new connection is created for your selected group" when running "Check/Update database from webtools". But I tested with Postgres while and after discussing with you about this. I can confirm it works. After a review it's obvious that, when the connection is null, a finally for closing the new created connection was needed.
Your patch is in
trunk r1748543
R15.12 r1748544
R14.12 r1748545
R13.07 since this is not a biggie and it's hard to backport by hand I let him as is
> 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
> Assignee: Jacques Le Roux
> Priority: Minor
> Fix For: 14.12.01, 15.12.01
>
> 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)
Locked
