OFBiz › OFBiz - User

How to Create a new database??

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

g.fitini

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="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"/>

</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.

Adrian Crum-3

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, [hidden email] 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="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"/>
> 
> </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.
>

g.fitini

Re: How to Create a new database??

Thanks

-----Original Message-----
From: Adrian Crum
Sent: Tuesday, February 11, 2014 3:41 PM
To: [hidden email]
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, [hidden email] 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="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"/>
> 
> </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.
>