You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Wei Zhang (JIRA)" <ji...@apache.org> on 2013/06/09 10:42:20 UTC

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

    [ https://issues.apache.org/jira/browse/OFBIZ-5216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678972#comment-13678972 ] 

Wei Zhang edited comment on OFBIZ-5216 at 6/9/13 8:41 AM:
----------------------------------------------------------

1. I think it should be line 57 in DBCPConnectionFactory.java, lease see my jconsole screen
2. yes, it works if remove the MSSQL databases
                
      was (Author: tzngvi):
    1. I think it should be line 57 in DBCPConnectionFactory.java
2. Please see my jconsole screen
                  
> 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
>             Fix For: SVN trunk
>
>         Attachments: entityengine.xml, jsconsole.png, jtds-1.2.5.jar, OFBIZ-5216.zip, postgresql-9.0-801.jdbc4.jar, screen.png
>
>
> 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