Meaning of localderbyolap and localderbytenant in the

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Meaning of localderbyolap and localderbytenant in the

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

--
[hidden email]

http://rsync.it-infrastrukturen.org


entityengine.xml.template_MySQL (34K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Meaning of localderbyolap and localderbytenant in template files

Mark Schneider
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
>
--
[hidden email]

http://rsync.it-infrastrukturen.org


entityengine.xml.template_MySQL (47K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: Meaning of localderbyolap and localderbytenant in template files

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
[hidden email]



-----Original Message-----
From: Mark Schneider [mailto:[hidden email]]
Sent: Sunday, December 23, 2012 1:41 AM
To: [hidden email]
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
>

--
[hidden email]

http://rsync.it-infrastrukturen.org



Reply | Threaded
Open this post in threaded view
|

Re: Meaning of localderbyolap and localderbytenant in template files / Error loading XML Resource

Mark Schneider
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
[hidden email]



-----Original Message-----
From: Mark Schneider [[hidden email]] 
Sent: Sunday, December 23, 2012 1:41 AM
To: [hidden email]
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

--
[hidden email]

http://rsync.it-infrastrukturen.org





-- 
[hidden email]

http://rsync.it-infrastrukturen.org

sreen_shots.zip (132K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: Meaning of localderbyolap and localderbytenant in template files / Error loading XML Resource

Praveen Agrawal
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

[hidden email]

 

 

From: Mark Schneider [mailto:[hidden email]]
Sent: Sunday, December 23, 2012 10:28 PM
To: [hidden email]
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
[hidden email]
 
 
 
-----Original Message-----
From: Mark Schneider [mailto:[hidden email]]
Sent: Sunday, December 23, 2012 1:41 AM
To: [hidden email]
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
 

 
--
[hidden email]
 
http://rsync.it-infrastrukturen.org
 
 
 






--
[hidden email]
 
http://rsync.it-infrastrukturen.org
Reply | Threaded
Open this post in threaded view
|

RE: Meaning of localderbyolap and localderbytenant in the

lshein
In reply to this post by Mark Schneider
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:[hidden email]]
Sent: Saturday, December 22, 2012 3:05 PM
To: [hidden email]
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

 

--

[hidden email]

 

http://rsync.it-infrastrukturen.org