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:[email protected]] Sent: Saturday, December 22, 2012 3:05 PM To: [email protected] 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 -- [email protected] http://rsync.it-infrastrukturen.org
