You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Deepak Agarwal <da...@gmail.com> on 2013/06/13 11:31:40 UTC
Multitenant unable to establish connection Error
Hello All,
I followed
https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support but
I am getting following error:
"DatabaseUtil.java:159:ERROR] Unable to establish a connection with the
database for helperName [localmysqlolap#DEMO1]
Unable to establish a connection with the database, no additional
information available.
Could not get table name information from the database, aborting."
and then :
Beginning import from URL:
file:/D:/Project/project/framework/entity/data/TenantDemoData.xml
[java] 2013-06-13 14:57:29,702 [ EntitySaxReader.java:270:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
[java] 2013-06-13 14:57:29,707 [ EntitySaxReader.java:289:INFO ]
Finished 3 values from
file:/D:/Project/project/framework/entity/data/TenantDemoData.xml
[java] 2013-06-13 14:57:29,707 [ EntitySaxReader.java:220:INFO ]
Beginning import from URL:
file:/D:/Project/project/framework/entityext/data/EntityExtTypeData.xml
[java] 2013-06-13 14:57:29,708 [ EntitySaxReader.java:270:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
[java] 2013-06-13 14:57:33,730 [ GenericDelegator.java:1468:ERROR]
[java] ---- exception report
----------------------------------------------------------
[java] Failure in storeAll operation:
org.ofbiz.entity.GenericDataSourceException: Unable to esablish a
connection with the database. (Unable to acquire a new connection from the
pool). Rolling back transaction.
[java] Exception: org.ofbiz.entity.GenericDataSourceException
[java] Message: Unable to esablish a connection with the database.
(Unable to acquire a new connection from the pool)
[java] ---- cause
---------------------------------------------------------------------
[java] Exception: java.sql.SQLException
[java] Message: Unable to acquire a new connection from the pool
[java] ---- cause
---------------------------------------------------------------------
[java] Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
[java] Message: Could not create connection to database server.
Attempted reconnect 3 times. Giving up.
[java] ---- cause
---------------------------------------------------------------------
[java] Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
[java] Message: Access denied for user ''@'localhost' to database
'ofbiz_demo1'
--
Thanks,
Deepak Agarwal,
Mobile: +91 9501190044
Re: Multitenant unable to establish connection Error
Posted by Deepak Agarwal <da...@gmail.com>.
My mistake. Switching db machine b/w linux and windows caused this problem
(Mysql lower_case_file_names settings effect). Deleted the newly created db
and re-installed multitenant.
On Thu, Jun 13, 2013 at 3:01 PM, Deepak Agarwal <da...@gmail.com>wrote:
> Hello All,
>
> I followed
> https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support but
> I am getting following error:
>
> "DatabaseUtil.java:159:ERROR] Unable to establish a connection with the
> database for helperName [localmysqlolap#DEMO1]
> Unable to establish a connection with the database, no additional
> information available.
> Could not get table name information from the database, aborting."
>
> and then :
>
> Beginning import from URL:
> file:/D:/Project/project/framework/entity/data/TenantDemoData.xml
> [java] 2013-06-13 14:57:29,702 [ EntitySaxReader.java:270:INFO ]
> Transaction Timeout set to 2 hours (7200 seconds)
> [java] 2013-06-13 14:57:29,707 [ EntitySaxReader.java:289:INFO ]
> Finished 3 values from
> file:/D:/Project/project/framework/entity/data/TenantDemoData.xml
> [java] 2013-06-13 14:57:29,707 [ EntitySaxReader.java:220:INFO ]
> Beginning import from URL:
> file:/D:/Project/project/framework/entityext/data/EntityExtTypeData.xml
> [java] 2013-06-13 14:57:29,708 [ EntitySaxReader.java:270:INFO ]
> Transaction Timeout set to 2 hours (7200 seconds)
> [java] 2013-06-13 14:57:33,730 [ GenericDelegator.java:1468:ERROR]
> [java] ---- exception report
> ----------------------------------------------------------
> [java] Failure in storeAll operation:
> org.ofbiz.entity.GenericDataSourceException: Unable to esablish a
> connection with the database. (Unable to acquire a new connection from the
> pool). Rolling back transaction.
> [java] Exception: org.ofbiz.entity.GenericDataSourceException
> [java] Message: Unable to esablish a connection with the database.
> (Unable to acquire a new connection from the pool)
> [java] ---- cause
> ---------------------------------------------------------------------
> [java] Exception: java.sql.SQLException
> [java] Message: Unable to acquire a new connection from the pool
> [java] ---- cause
> ---------------------------------------------------------------------
> [java] Exception:
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
> [java] Message: Could not create connection to database server.
> Attempted reconnect 3 times. Giving up.
> [java] ---- cause
> ---------------------------------------------------------------------
> [java] Exception:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
> [java] Message: Access denied for user ''@'localhost' to database
> 'ofbiz_demo1'
>
> --
> Thanks,
> Deepak Agarwal,
>
> Mobile: +91 9501190044
>
--
Thanks,
Deepak Agarwal,
Mobile: +91 9501190044