[jira] [Updated] (OFBIZ-5216) The thread is locked at DBCPConnectionFactory.getConnection() when connects to multiple databases

[Nicolas Malin (Jira)]

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

Wei Zhang updated OFBIZ-5216:
-----------------------------

    Description:
I connected 5 databases, ofbiz, ofbiz_olap, ofbiz_tenant and 2 MSSQL databases of myself. Three ofbiz databases were created in Postgres. But the the thread will locked at DBCPConnectionFactory.getConnection() when OFBiz was starting.  

And I　changed

    public Connection getConnection(GenericHelperInfo helperInfo, JdbcElement abstractJdbc) throws SQLException, GenericEntityException

to

    public synchronized Connection getConnection(GenericHelperInfo helperInfo, JdbcElement abstractJdbc) throws SQLException, GenericEntityException

it then works.


  was:
I connected 4 databases, ofbiz, ofbiz_olap, ofbiz_tenant and my MSSQL database. Three ofbiz databases were created in Postgres. But the the thread will locked at DBCPConnectionFactory.getConnection() when OFBiz was starting.  

And I　changed

    public Connection getConnection(GenericHelperInfo helperInfo, JdbcElement abstractJdbc) throws SQLException, GenericEntityException

to

    public synchronized Connection getConnection(GenericHelperInfo helperInfo, JdbcElement abstractJdbc) throws SQLException, GenericEntityException

it then works.


   

> The thread is locked at DBCPConnectionFactory.getConnection() when connects to multiple databases
> -------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-5216
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-5216
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: SVN trunk
>            Reporter: Wei Zhang
>            Assignee: Adrian Crum
>            Priority: Blocker
>
> I connected 5 databases, ofbiz, ofbiz_olap, ofbiz_tenant and 2 MSSQL databases of myself. Three ofbiz databases were created in Postgres. But the the thread will locked at DBCPConnectionFactory.getConnection() when OFBiz was starting.  
> And I　changed
>     public Connection getConnection(GenericHelperInfo helperInfo, JdbcElement abstractJdbc) throws SQLException, GenericEntityException
> to
>     public synchronized Connection getConnection(GenericHelperInfo helperInfo, JdbcElement abstractJdbc) throws SQLException, GenericEntityException
> it then works.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira