[ 
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

Reply via email to