You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Mark Schneider <ms...@it-infrastrukturen.org> on 2012/12/22 21:05:24 UTC
Meaning of localderbyolap and localderbytenant in the
Hello
BigFish example use a template file for entityengine.xml.
Is it required to modify localderbyolap and localderbytenant to let say
localmysqlolap and localmysqltentant when using MySQL (or MariaDB) as
database and define appriopriate sections for them in entityengine.xml?
(see attachment)
./osafe_deployment/ofbiz/framework/entity/config/entityengine.xml.template
.
<!-- the connection factory class to use, one is needed for obtaining
connections/pools for defined resources -->
<connection-factory
class="org.ofbiz.entity.connection.DBCPConnectionFactory"/>
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="@main.datasource.name@"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="@main.datasource.name@"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
</delegator>
<!-- be sure that your default delegator (or the one you use) uses the
same datasource for test. You must run "ant run-install" before running
"ant run-tests" -->
<delegator name="test" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="@main.datasource.name@"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
</delegator>
Thank you in advance for any hints.
regards, Mark
--
ms@it-infrastrukturen.org
http://rsync.it-infrastrukturen.org
RE: Meaning of localderbyolap and localderbytenant in template files / Error loading XML Resource
Posted by Praveen Agrawal <pa...@salmonllc.com>.
Hi Mark,
Yes, I was referring "./osafe_deployment/client-deployment.properties’ file.
The error that you are seeing on ‘ant run-install-seed’ command is due to not configuring the *olap datasource. Since the ProductDimension entity is in ‘org.ofbiz.olap’ group and this group is not configured in enityengine.xml template.
But those errors would not create any problem to run Bigfish and definitely we would be looking into this.
I think this would help you. Please feel free to ask if any concern.
Thanks,
Praveen Agrawal
pagrawal@salmonllc.com
From: Mark Schneider [mailto:ms@it-infrastrukturen.org]
Sent: Sunday, December 23, 2012 10:28 PM
To: user@ofbiz.apache.org
Subject: Re: Meaning of localderbyolap and localderbytenant in template files / Error loading XML Resource
HI Praveen,
Thanks a lot for your kind hints.
There are two such files after installation of BigFish-eCommerce-v1.08.zip:
:~/apache-ofbiz-10.04.04$ find ./ -name client-deployment.properties
./osafe_deployment/client-deployment.properties
./hot-deploy/osafe/config/client-deployment.properties
~/apache-ofbiz-10.04.04$ diff ./hot-deploy/osafe/config/client-deployment.properties ./osafe_deployment/client-deployment.properties
11,12c11,12
< jdbc.username=root
< jdbc.password=root
---
> jdbc.username=bigfish
> jdbc.password=bigfish
53c53
< port.jndi=1095
---
> port.jndi=1092
I guess you mean "./osafe_deployment/client-deployment.properties"
I used following commangs to create the MySQL database:
MariaDB [(none)]> create database bigfishdemo;
MariaDB [(none)]> CREATE USER 'bigfish'@'localhost' IDENTIFIED BY 'bigfish';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON bigfishdemo.* TO bigfish @'%' IDENTIFIED BY 'bigfish';
MariaDB [(none)]> FLUSH PRIVILEGES;
~/apache-ofbiz-10.04.04$ mysql -u root -p
MariaDB [(none)]> select Host,User,Password from mysql.user;
+-----------+------------------+-------------------------------------------+
| Host | User | Password |
+-----------+------------------+-------------------------------------------+
| localhost | root | |
| wheezy | root | |
| 127.0.0.1 | root | |
| ::1 | root | |
| localhost | debian-sys-maint | *9A3E21ACF2BEF1D3908CD1EBDC497ADC90FBF6EA |
| localhost | bigfish | *F2AB1B6DA9A13BDF7E260CA4C847230F29134D47 |
| % | bigfish | *F2AB1B6DA9A13BDF7E260CA4C847230F29134D47 |
+-----------+------------------+-------------------------------------------+
~$ mysql -u bigfish -p
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| bigfishdemo |
+--------------------+
When I run "ant run-install-seed" there is the following error message:
# ---
.
[java] 2012-12-23 16:16:10,683 (main) [EntityDataLoadContainer.java:397:INFO ] 00116 of 122131 from file:/home/ironm/apache-ofbiz-10.04.04/hot-deploy/osafeadmin/data/OsafeAdminSecurityData.xml <file:///\\home\ironm\apache-ofbiz-10.04.04\hot-deploy\osafeadmin\data\OsafeAdminSecurityData.xml>
[java] 2012-12-23 16:16:10,683 (main) [EntityDataLoadContainer.java:397:INFO ] 00065 of 122196 from file:/home/ironm/apache-ofbiz-10.04.04/hot-deploy/osafeadmin/data/OsafeAdminHomePageSeedData.xml <file:///\\home\ironm\apache-ofbiz-10.04.04\hot-deploy\osafeadmin\data\OsafeAdminHomePageSeedData.xml>
[java] 2012-12-23 16:16:10,684 (main) [EntityDataLoadContainer.java:402:INFO ] The following errors occured in the data load:
[java] 2012-12-23 16:16:10,684 (main) [EntityDataLoadContainer.java:404:INFO ] [install.loadData]: Error loading XML Resource <file:///\\home\ironm\apache-ofbiz-10.04.04\framework\common\data\DimensionTypeData.xml> "file:/home/ironm/apache-ofbiz-10.04.04/framework/common/data/DimensionTypeData.xml"; Error was: A transaction error occurred reading data
[java] 2012-12-23 16:16:10,684 (main) [EntityDataLoadContainer.java:404:INFO ] [install.loadData]: Error loading XML Resource <file:///\\home\ironm\apache-ofbiz-10.04.04\applications\product\data\DimensionTypeData.xml> "file:/home/ironm/apache-ofbiz-10.04.04/applications/product/data/DimensionTypeData.xml"; Error was: A transaction error occurred reading data
[java] 2012-12-23 16:16:10,684 (main) [EntityDataLoadContainer.java:408:INFO ] =-=-=-=-=-=-= Finished the data load with 122196 rows changed.
[java] 2012-12-23 16:16:10,684 (main) [ ContainerLoader.java:113:INFO ] Shutting down containers
BUILD SUCCESSFUL
Total time: 2 minutes 4 seconds
# ---
Tables are created:
MariaDB [bigfishdemo]> show tables;
.
829 rows in set (0.01 sec)
I can't find any errors in mysql.log
I am not sure it this issue is MariaDB/MySQL specific or something else.
Is it possible (just for the test) to use localderby instead? .. or PostgreSQL?
I have followed <http://bigfish.salmonllc.com/bfDownload.html> "http://bigfish.salmonllc.com/bfDownload.html" and tested it on wheezy debian linux with JDK7u9 (amd64).
~/apache-ofbiz-10.04.04$ ./startofbiz.sh
bash: ./startofbiz.sh: /bin/sh^M: Defekter Interpreter: Datei oder Verzeichnis nicht gefunden
~/apache-ofbiz-10.04.04$ dos2unix startofbiz.sh
dos2unix: Datei startofbiz.sh wird ins Unix-Format umgewandelt ...
~/apache-ofbiz-10.04.04$ ./startofbiz.sh
sreen_shots.zip
Thank you in advance for any hints.
regards, Mark
Am 23.12.2012 08:59, schrieb Praveen Agrawal:
Hi Mark,
To run bigfish it's not required to modify localderbyolap and localderbytenant through entityengine.xml.template.
You can set the following DB properties in client-deployment.properties file.
main.datasource.name
database.name
database.server
database.serverPort
jdbc.driver
jdbc.username
jdbc.password
after settings properties, the ant command will modify the entityengine.xml file using template.
There is no need of multiple DB's to run bigfish. Only one Database is required.
Thanks,
Praveen Agrawal
pagrawal@salmonllc.com
-----Original Message-----
From: Mark Schneider [mailto:ms@it-infrastrukturen.org]
Sent: Sunday, December 23, 2012 1:41 AM
To: user@ofbiz.apache.org
Subject: Re: Meaning of localderbyolap and localderbytenant in template files
Just small correction in the subject line
Am 22.12.2012 21:05, schrieb Mark Schneider:
Hello
BigFish example use a template file for entityengine.xml.
Is it required to modify localderbyolap and localderbytenant to let
say localmysqlolap and localmysqltentant when using MySQL (or MariaDB)
as database and define appriopriate sections for them in
entityengine.xml? (see attachment)
./osafe_deployment/ofbiz/framework/entity/config/entityengine.xml.temp
late
.
<!-- the connection factory class to use, one is needed for obtaining
connections/pools for defined resources --> <connection-factory
class="org.ofbiz.entity.connection.DBCPConnectionFactory"/>
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz"
datasource-name="@main.datasource.name@"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localderbyolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz"
datasource-name="@main.datasource.name@"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localderbyolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
</delegator>
<!-- be sure that your default delegator (or the one you use) uses the
same datasource for test. You must run "ant run-install" before
running "ant run-tests" --> <delegator name="test"
entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"> <group-map
group-name="org.ofbiz"
datasource-name="@main.datasource.name@"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localderbyolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
</delegator>
Thank you in advance for any hints.
regards, Mark
--
ms@it-infrastrukturen.org
http://rsync.it-infrastrukturen.org
--
ms@it-infrastrukturen.org
http://rsync.it-infrastrukturen.org
Re: Meaning of localderbyolap and localderbytenant in template files
/ Error loading XML Resource
Posted by Mark Schneider <ms...@it-infrastrukturen.org>.
HI Praveen,
Thanks a lot for your kind hints.
There are two such files after installation of BigFish-eCommerce-v1.08.zip:
:~/apache-ofbiz-10.04.04$ find ./ -name client-deployment.properties
./osafe_deployment/client-deployment.properties
./hot-deploy/osafe/config/client-deployment.properties
~/apache-ofbiz-10.04.04$ diff
./hot-deploy/osafe/config/client-deployment.properties
./osafe_deployment/client-deployment.properties
11,12c11,12
< jdbc.username=root
< jdbc.password=root
---
> jdbc.username=bigfish
> jdbc.password=bigfish
53c53
< port.jndi=1095
---
> port.jndi=1092
I guess you mean "./osafe_deployment/client-deployment.properties"
I used following commangs to create the MySQL database:
MariaDB [(none)]> create database bigfishdemo;
MariaDB [(none)]> CREATE USER 'bigfish'@'localhost' IDENTIFIED BY
'bigfish';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON bigfishdemo.* TO bigfish @'%'
IDENTIFIED BY 'bigfish';
MariaDB [(none)]> FLUSH PRIVILEGES;
~/apache-ofbiz-10.04.04$ mysql -u root -p
MariaDB [(none)]> select Host,User,Password from mysql.user;
+-----------+------------------+-------------------------------------------+
| Host | User | Password |
+-----------+------------------+-------------------------------------------+
| localhost | root | |
| wheezy | root | |
| 127.0.0.1 | root | |
| ::1 | root | |
| localhost | debian-sys-maint | *9A3E21ACF2BEF1D3908CD1EBDC497ADC90FBF6EA |
| localhost | bigfish | *F2AB1B6DA9A13BDF7E260CA4C847230F29134D47 |
| % | bigfish | *F2AB1B6DA9A13BDF7E260CA4C847230F29134D47 |
+-----------+------------------+-------------------------------------------+
~$ mysql -u bigfish -p
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| bigfishdemo |
+--------------------+
When I run "ant run-install-seed" there is the following error message:
# ---
.
[java] 2012-12-23 16:16:10,683 (main)
[EntityDataLoadContainer.java:397:INFO ] 00116 of 122131 from
file:/home/ironm/apache-ofbiz-10.04.04/hot-deploy/osafeadmin/data/OsafeAdminSecurityData.xml
[java] 2012-12-23 16:16:10,683 (main)
[EntityDataLoadContainer.java:397:INFO ] 00065 of 122196 from
file:/home/ironm/apache-ofbiz-10.04.04/hot-deploy/osafeadmin/data/OsafeAdminHomePageSeedData.xml
[java] 2012-12-23 16:16:10,684 (main)
[EntityDataLoadContainer.java:402:INFO ] The following errors occured in
the data load:
[java] 2012-12-23 16:16:10,684 (main)
[EntityDataLoadContainer.java:404:INFO ] [install.loadData]: *Error
loading XML Resource*
"file:/home/ironm/apache-ofbiz-10.04.04/framework/common/data/DimensionTypeData.xml";
Error was: A transaction error occurred reading data
[java] 2012-12-23 16:16:10,684 (main)
[EntityDataLoadContainer.java:404:INFO ] [install.loadData]: *Error
loading XML Resource*
"file:/home/ironm/apache-ofbiz-10.04.04/applications/product/data/DimensionTypeData.xml";
Error was: A transaction error occurred reading data
[java] 2012-12-23 16:16:10,684 (main)
[EntityDataLoadContainer.java:408:INFO ] =-=-=-=-=-=-= Finished the data
load with 122196 rows changed.
[java] 2012-12-23 16:16:10,684 (main) [
ContainerLoader.java:113:INFO ] Shutting down containers
BUILD SUCCESSFUL
Total time: 2 minutes 4 seconds
# ---
Tables are created:
MariaDB [bigfishdemo]> show tables;
.
829 rows in set (0.01 sec)
I can't find any errors in mysql.log
I am not sure it this issue is MariaDB/MySQL specific or something else.
Is it possible (just for the test) to use localderby instead? .. or
PostgreSQL?
I have followed "http://bigfish.salmonllc.com/bfDownload.html" and
tested it on wheezy debian linux with JDK7u9 (amd64).
~/apache-ofbiz-10.04.04$ *./startofbiz.sh*
bash: ./startofbiz.sh: /bin/sh*^M*: Defekter Interpreter: Datei oder
Verzeichnis nicht gefunden
~/apache-ofbiz-10.04.04$ *dos2unix* startofbiz.sh
dos2unix: Datei startofbiz.sh wird ins Unix-Format umgewandelt ...
~/apache-ofbiz-10.04.04$ *./startofbiz.sh*
sreen_shots.zip
Thank you in advance for any hints.
regards, Mark
Am 23.12.2012 08:59, schrieb Praveen Agrawal:
> Hi Mark,
>
> To run bigfish it's not required to modify localderbyolap and localderbytenant through entityengine.xml.template.
> You can set the following DB properties in client-deployment.properties file.
>
> main.datasource.name
> database.name
> database.server
> database.serverPort
> jdbc.driver
> jdbc.username
> jdbc.password
>
> after settings properties, the ant command will modify the entityengine.xml file using template.
>
> There is no need of multiple DB's to run bigfish. Only one Database is required.
>
> Thanks,
> Praveen Agrawal
> pagrawal@salmonllc.com
>
>
>
> -----Original Message-----
> From: Mark Schneider [mailto:ms@it-infrastrukturen.org]
> Sent: Sunday, December 23, 2012 1:41 AM
> To: user@ofbiz.apache.org
> Subject: Re: Meaning of localderbyolap and localderbytenant in template files
>
> Just small correction in the subject line
>
> Am 22.12.2012 21:05, schrieb Mark Schneider:
>> Hello
>>
>> BigFish example use a template file for entityengine.xml.
>>
>> Is it required to modify localderbyolap and localderbytenant to let
>> say localmysqlolap and localmysqltentant when using MySQL (or MariaDB)
>> as database and define appriopriate sections for them in
>> entityengine.xml? (see attachment)
>>
>> ./osafe_deployment/ofbiz/framework/entity/config/entityengine.xml.temp
>> late
>>
>> .
>> <!-- the connection factory class to use, one is needed for obtaining
>> connections/pools for defined resources --> <connection-factory
>> class="org.ofbiz.entity.connection.DBCPConnectionFactory"/>
>>
>> <delegator name="default" entity-model-reader="main"
>> entity-group-reader="main" entity-eca-reader="main"
>> distributed-cache-clear-enabled="false">
>> <group-map group-name="org.ofbiz"
>> datasource-name="@main.datasource.name@"/>
>> <group-map group-name="org.ofbiz.olap"
>> datasource-name="localderbyolap"/>
>> <group-map group-name="org.ofbiz.tenant"
>> datasource-name="localderbytenant"/>
>> </delegator>
>> <delegator name="default-no-eca" entity-model-reader="main"
>> entity-group-reader="main" entity-eca-reader="main"
>> entity-eca-enabled="false" distributed-cache-clear-enabled="false">
>> <group-map group-name="org.ofbiz"
>> datasource-name="@main.datasource.name@"/>
>> <group-map group-name="org.ofbiz.olap"
>> datasource-name="localderbyolap"/>
>> <group-map group-name="org.ofbiz.tenant"
>> datasource-name="localderbytenant"/>
>> </delegator>
>>
>> <!-- be sure that your default delegator (or the one you use) uses the
>> same datasource for test. You must run "ant run-install" before
>> running "ant run-tests" --> <delegator name="test"
>> entity-model-reader="main"
>> entity-group-reader="main" entity-eca-reader="main"> <group-map
>> group-name="org.ofbiz"
>> datasource-name="@main.datasource.name@"/>
>> <group-map group-name="org.ofbiz.olap"
>> datasource-name="localderbyolap"/>
>> <group-map group-name="org.ofbiz.tenant"
>> datasource-name="localderbytenant"/>
>> </delegator>
>>
>> Thank you in advance for any hints.
>>
>> regards, Mark
>>
> --
> ms@it-infrastrukturen.org
>
> http://rsync.it-infrastrukturen.org
>
>
>
--
ms@it-infrastrukturen.org
http://rsync.it-infrastrukturen.org
RE: Meaning of localderbyolap and localderbytenant in template files
Posted by Praveen Agrawal <pa...@salmonllc.com>.
Hi Mark,
To run bigfish it's not required to modify localderbyolap and localderbytenant through entityengine.xml.template.
You can set the following DB properties in client-deployment.properties file.
main.datasource.name
database.name
database.server
database.serverPort
jdbc.driver
jdbc.username
jdbc.password
after settings properties, the ant command will modify the entityengine.xml file using template.
There is no need of multiple DB's to run bigfish. Only one Database is required.
Thanks,
Praveen Agrawal
pagrawal@salmonllc.com
-----Original Message-----
From: Mark Schneider [mailto:ms@it-infrastrukturen.org]
Sent: Sunday, December 23, 2012 1:41 AM
To: user@ofbiz.apache.org
Subject: Re: Meaning of localderbyolap and localderbytenant in template files
Just small correction in the subject line
Am 22.12.2012 21:05, schrieb Mark Schneider:
> Hello
>
> BigFish example use a template file for entityengine.xml.
>
> Is it required to modify localderbyolap and localderbytenant to let
> say localmysqlolap and localmysqltentant when using MySQL (or MariaDB)
> as database and define appriopriate sections for them in
> entityengine.xml? (see attachment)
>
> ./osafe_deployment/ofbiz/framework/entity/config/entityengine.xml.temp
> late
>
> .
> <!-- the connection factory class to use, one is needed for obtaining
> connections/pools for defined resources --> <connection-factory
> class="org.ofbiz.entity.connection.DBCPConnectionFactory"/>
>
> <delegator name="default" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"
> distributed-cache-clear-enabled="false">
> <group-map group-name="org.ofbiz"
> datasource-name="@main.datasource.name@"/>
> <group-map group-name="org.ofbiz.olap"
> datasource-name="localderbyolap"/>
> <group-map group-name="org.ofbiz.tenant"
> datasource-name="localderbytenant"/>
> </delegator>
> <delegator name="default-no-eca" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"
> entity-eca-enabled="false" distributed-cache-clear-enabled="false">
> <group-map group-name="org.ofbiz"
> datasource-name="@main.datasource.name@"/>
> <group-map group-name="org.ofbiz.olap"
> datasource-name="localderbyolap"/>
> <group-map group-name="org.ofbiz.tenant"
> datasource-name="localderbytenant"/>
> </delegator>
>
> <!-- be sure that your default delegator (or the one you use) uses the
> same datasource for test. You must run "ant run-install" before
> running "ant run-tests" --> <delegator name="test"
> entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"> <group-map
> group-name="org.ofbiz"
> datasource-name="@main.datasource.name@"/>
> <group-map group-name="org.ofbiz.olap"
> datasource-name="localderbyolap"/>
> <group-map group-name="org.ofbiz.tenant"
> datasource-name="localderbytenant"/>
> </delegator>
>
> Thank you in advance for any hints.
>
> regards, Mark
>
--
ms@it-infrastrukturen.org
http://rsync.it-infrastrukturen.org
Re: Meaning of localderbyolap and localderbytenant in template files
Posted by Mark Schneider <ms...@it-infrastrukturen.org>.
Just small correction in the subject line
Am 22.12.2012 21:05, schrieb Mark Schneider:
> Hello
>
> BigFish example use a template file for entityengine.xml.
>
> Is it required to modify localderbyolap and localderbytenant to let
> say localmysqlolap and localmysqltentant when using MySQL (or MariaDB)
> as database and define appriopriate sections for them in
> entityengine.xml? (see attachment)
>
> ./osafe_deployment/ofbiz/framework/entity/config/entityengine.xml.template
>
> .
> <!-- the connection factory class to use, one is needed for obtaining
> connections/pools for defined resources -->
> <connection-factory
> class="org.ofbiz.entity.connection.DBCPConnectionFactory"/>
>
> <delegator name="default" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"
> distributed-cache-clear-enabled="false">
> <group-map group-name="org.ofbiz"
> datasource-name="@main.datasource.name@"/>
> <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
> <group-map group-name="org.ofbiz.tenant"
> datasource-name="localderbytenant"/>
> </delegator>
> <delegator name="default-no-eca" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"
> entity-eca-enabled="false" distributed-cache-clear-enabled="false">
> <group-map group-name="org.ofbiz"
> datasource-name="@main.datasource.name@"/>
> <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
> <group-map group-name="org.ofbiz.tenant"
> datasource-name="localderbytenant"/>
> </delegator>
>
> <!-- be sure that your default delegator (or the one you use) uses the
> same datasource for test. You must run "ant run-install" before
> running "ant run-tests" -->
> <delegator name="test" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main">
> <group-map group-name="org.ofbiz"
> datasource-name="@main.datasource.name@"/>
> <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
> <group-map group-name="org.ofbiz.tenant"
> datasource-name="localderbytenant"/>
> </delegator>
>
> Thank you in advance for any hints.
>
> regards, Mark
>
--
ms@it-infrastrukturen.org
http://rsync.it-infrastrukturen.org
RE: Meaning of localderbyolap and localderbytenant in the
Posted by Len Shein <ls...@salmonllc.com>.
Mark,
In running Bigfish to a MySql DB you do NOT need to create three database
names nor do you need to modify the entityEngine.xml and or the template
file.
The BigFish module has a client-deployment.properties file where you define
all of your DB parameters which on ant build will populate the
entityEngine.template file respectively and move the template file into
Ofbiz directories accordingly. This process was put in place to alleviate
making many changes to different property files in Ofbiz to configure a
given instance.
To configure your instance to run against MySql update the properties in the
following section of your osafe-deployment/client-deployment.properties
file:
####################################################################
# Database Properties : EntityEngine.xml
#
# Ofbiz File : framework/entity/config/entityengine.xml
####################################################################
main.datasource.name=localmysql
* Standard Ofbiz datasource name; other options (localsybase,
localoracle, etc...)
database.name=moda_may
* The name of the DB you want this instance to connect to.
database.server=127.0.0.1
* The server where your DB is located.
database.serverPort=3306
* The port number of the server where your DB is located.
jdbc.driver=com.mysql.jdbc.Driver
* The driver to connect to your DB
jdbc.username=bigfish
jdbc.password=bigfish
Username and password to connect to your DB.
* This user should already be by your DB administrator and given the
proper access rights to your DB.
Regards
Len
-----Original Message-----
From: Mark Schneider [mailto:ms@it-infrastrukturen.org]
Sent: Saturday, December 22, 2012 3:05 PM
To: user@ofbiz.apache.org
Subject: Meaning of localderbyolap and localderbytenant in the
Hello
BigFish example use a template file for entityengine.xml.
Is it required to modify localderbyolap and localderbytenant to let say
localmysqlolap and localmysqltentant when using MySQL (or MariaDB) as
database and define appriopriate sections for them in entityengine.xml?
(see attachment)
./osafe_deployment/ofbiz/framework/entity/config/entityengine.xml.template
.
<!-- the connection factory class to use, one is needed for obtaining
connections/pools for defined resources -->
<connection-factory
class="org.ofbiz.entity.connection.DBCPConnectionFactory"/>
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="@main.datasource.name@"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="@main.datasource.name@"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
</delegator>
<!-- be sure that your default delegator (or the one you use) uses the
same datasource for test. You must run "ant run-install" before running
"ant run-tests" -->
<delegator name="test" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="@main.datasource.name@"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
</delegator>
Thank you in advance for any hints.
regards, Mark
--
ms@it-infrastrukturen.org
http://rsync.it-infrastrukturen.org