You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by g....@telecgt.it on 2014/02/11 14:53:31 UTC
How to Create a new database??
Hi to everyone, i’m using Apache-ofbiz 12.04.01, and i’m tring to create a new database following some little instruction taken on the book apache Ofbiz Cookbook. So, i’ve tried to create a custom data source like that :
<datasource name="localmysqlCustom"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
field-type-name="mysql"
check-on-start="true"
add-missing-on-start="true"
check-pks-on-start="false"
use-foreign-keys="true"
join-style="ansi-no-parenthesis"
alias-view-columns="false"
drop-fk-use-foreign-key-keyword="true"
table-type="InnoDB"
character-set="utf8"
collate="utf8_general_ci">
<read-data reader-name="tenant"/>
<read-data reader-name="seed"/>
<read-data reader-name="seed-initial"/>
<!-- read-data reader-name="demo"/ -->
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="com.mysql.jdbc.Driver"
jdbc-uri="jdbc:mysql://127.0.0.1/myDbCustom?autoReconnect=true"
jdbc-username="pcm"
jdbc-password="pcm"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"
time-between-eviction-runs-millis="600000"/>
<!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
</datasource>
and i’ve create a new ‘delegator’ like this :
<delegator name="custom" 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="localmysqlCustom"/>
</delegator>
so i’ve tried to run ant load-demo (ant run-install) but nothing happen.
Anyone have a suggestion on how to create a new database via ‘ant’ commands.
Or what i’ve to do.
Thank you.
Re: How to Create a new database??
Posted by g....@telecgt.it.
Thanks
-----Original Message-----
From: Adrian Crum
Sent: Tuesday, February 11, 2014 3:41 PM
To: user@ofbiz.apache.org
Subject: Re: How to Create a new database??
You must create an empty database in MySQL first, before running the ant
data load commands.
Adrian Crum
Sandglass Software
www.sandglass-software.com
On 2/11/2014 5:53 AM, g.fitini@telecgt.it wrote:
> Hi to everyone, i’m using Apache-ofbiz 12.04.01, and i’m tring to
> create a new database following some little instruction taken on the book
> apache Ofbiz Cookbook. So, i’ve tried to create a custom data source like
> that :
>
>
>
> <datasource name="localmysqlCustom"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> field-type-name="mysql"
> check-on-start="true"
> add-missing-on-start="true"
> check-pks-on-start="false"
> use-foreign-keys="true"
> join-style="ansi-no-parenthesis"
> alias-view-columns="false"
> drop-fk-use-foreign-key-keyword="true"
> table-type="InnoDB"
> character-set="utf8"
> collate="utf8_general_ci">
> <read-data reader-name="tenant"/>
> <read-data reader-name="seed"/>
> <read-data reader-name="seed-initial"/>
> <!-- read-data reader-name="demo"/ -->
> <read-data reader-name="ext"/>
> <inline-jdbc
> jdbc-driver="com.mysql.jdbc.Driver"
>
> jdbc-uri="jdbc:mysql://127.0.0.1/myDbCustom?autoReconnect=true"
> jdbc-username="pcm"
> jdbc-password="pcm"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"
> time-between-eviction-runs-millis="600000"/>
> <!-- <jndi-jdbc jndi-server-name="localjndi"
> jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
> </datasource>
>
>
> and i’ve create a new ‘delegator’ like this :
>
> <delegator name="custom" 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="localmysqlCustom"/>
> </delegator>
>
> so i’ve tried to run ant load-demo (ant run-install) but nothing happen.
>
> Anyone have a suggestion on how to create a new database via ‘ant’
> commands.
>
> Or what i’ve to do.
>
> Thank you.
>
Re: How to Create a new database??
Posted by Adrian Crum <ad...@sandglass-software.com>.
You must create an empty database in MySQL first, before running the ant
data load commands.
Adrian Crum
Sandglass Software
www.sandglass-software.com
On 2/11/2014 5:53 AM, g.fitini@telecgt.it wrote:
> Hi to everyone, i’m using Apache-ofbiz 12.04.01, and i’m tring to create a new database following some little instruction taken on the book apache Ofbiz Cookbook. So, i’ve tried to create a custom data source like that :
>
>
>
> <datasource name="localmysqlCustom"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> field-type-name="mysql"
> check-on-start="true"
> add-missing-on-start="true"
> check-pks-on-start="false"
> use-foreign-keys="true"
> join-style="ansi-no-parenthesis"
> alias-view-columns="false"
> drop-fk-use-foreign-key-keyword="true"
> table-type="InnoDB"
> character-set="utf8"
> collate="utf8_general_ci">
> <read-data reader-name="tenant"/>
> <read-data reader-name="seed"/>
> <read-data reader-name="seed-initial"/>
> <!-- read-data reader-name="demo"/ -->
> <read-data reader-name="ext"/>
> <inline-jdbc
> jdbc-driver="com.mysql.jdbc.Driver"
> jdbc-uri="jdbc:mysql://127.0.0.1/myDbCustom?autoReconnect=true"
> jdbc-username="pcm"
> jdbc-password="pcm"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"
> time-between-eviction-runs-millis="600000"/>
> <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
> </datasource>
>
>
> and i’ve create a new ‘delegator’ like this :
>
> <delegator name="custom" 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="localmysqlCustom"/>
> </delegator>
>
> so i’ve tried to run ant load-demo (ant run-install) but nothing happen.
>
> Anyone have a suggestion on how to create a new database via ‘ant’ commands.
>
> Or what i’ve to do.
>
> Thank you.
>