OFBiz › OFBiz - User

problem during deploy ofbiz.ear

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

4 messages Options

g.fitini

problem during deploy ofbiz.ear

Hi to everyone, i’ve tried to follow this guide,
https://cwiki.apache.org/confluence/display/OFBTECH/Glassfish+v2.1 to generate my ofbiz.ear, using the autogenerate deploy.sh

My ofbiz.ear is done by every war component of the application, and my custom component in hot-deploy application

In attachment the structure of my ofbiz.ear.
Are anyone see something wrong??

And in my framework\entity\config\ folder, i’ve find 3 files :

entityengine.xml
entityengine.xml.rej
entityengine.xml.orig

i’ve look just the entityengine.xml,and it seem strange.... :

<datasource name="derby"

helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"

schema-name="ofbiz"

field-type-name="derby"

check-on-start="true"

add-missing-on-start="true"

use-pk-constraint-names="false"

use-indices-unique="false"

alias-view-columns="false">

<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="org.apache.derby.jdbc.ClientDriver"

jdbc-uri="jdbc:derby://localhost:1527/ofbiz;create=true"

jdbc-username="ofbiz"

jdbc-password="ofbiz"

isolation-level="ReadCommitted"

pool-minsize="2"

pool-maxsize="250"/>

</datasource>

And another connection to datasource derbyolap.

it is strange, because my personal entity engine, have the connection with mysql database. Any suggestion??

Jacques Le Roux

Re: problem during deploy ofbiz.ear

Administrator

Attachments don't make through to ASF MLs, use rather Nabble user forum or any mean you like for that

II don't remember all the details of the autogenerate deploy.sh. You could try to use an OOTB entityengine.xml file

Also you say
>it is strange, because my personal entity engine, have the connection with mysql database. Any suggestion??

What do you mean exactly by that? Could you simply copy in your anwser the patch content between your working copy and OFBIz repo for entityengine.xml file only?

Jacques
----- Original Message -----
From: [hidden email]
To: [hidden email]
Sent: Monday, October 14, 2013 6:14 PM
Subject: problem during deploy ofbiz.ear

Hi to everyone, i’ve tried to follow this guide,
https://cwiki.apache.org/confluence/display/OFBTECH/Glassfish+v2.1 to generate my ofbiz.ear, using the autogenerate deploy.sh

My ofbiz.ear is done by every war component of the application, and my custom component in hot-deploy application

In attachment the structure of my ofbiz.ear.
Are anyone see something wrong??

And in my framework\entity\config\ folder, i’ve find 3 files :

entityengine.xml
entityengine.xml.rej
entityengine.xml.orig

i’ve look just the entityengine.xml,and it seem strange.... :

<datasource name="derby"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
schema-name="ofbiz"
field-type-name="derby"
check-on-start="true"
add-missing-on-start="true"
use-pk-constraint-names="false"
use-indices-unique="false"
alias-view-columns="false">
<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="org.apache.derby.jdbc.ClientDriver"
jdbc-uri="jdbc:derby://localhost:1527/ofbiz;create=true"
jdbc-username="ofbiz"
jdbc-password="ofbiz"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"/>

</datasource>

And another connection to datasource derbyolap.

it is strange, because my personal entity engine, have the connection with mysql database. Any suggestion??

g.fitini

Re: problem during deploy ofbiz.ear

Ok, this is the content of my entityengine.xml.patch that i've found in my setup/glassfish21 folder:

> <group-map group-name="org.ofbiz" datasource-name="derby"/>
> <group-map group-name="org.ofbiz.olap" datasource-name="derbyolap"/>
55a56,57
>
>
123a126,176
>
> <datasource name="derby"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> schema-name="ofbiz"
> field-type-name="derby"
> check-on-start="true"
> add-missing-on-start="true"
> use-pk-constraint-names="false"
> use-indices-unique="false"
> alias-view-columns="false">
> <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="org.apache.derby.jdbc.ClientDriver"
> jdbc-uri="jdbc:derby://localhost:1527/ofbiz;create=true"
> jdbc-username="ofbiz"
> jdbc-password="ofbiz"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"/>
>
> </datasource>
>
>
> <datasource name="derbyolap"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> schema-name="ofbiz"
> field-type-name="derby"
> check-on-start="true"
> add-missing-on-start="true"
> use-pk-constraint-names="false"
> use-indices-unique="false"
> alias-view-columns="false">
> <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="org.apache.derby.jdbc.ClientDriver"
> jdbc-uri="jdbc:derby://localhost:1527/ofbiz;create=true"
> jdbc-username="ofbiz"
> jdbc-password="ofbiz"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"/>
>
> </datasource>
>

while, in my entityengine in apache-ofbiz-12.04.01/framework/entity/config folder, i've done :

......
.....
<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="localmysql"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localmysqlolap"/>
<group-map group-name="org.ofbiz.tenant" datasource-name="localmysqltenant"/>

</delegator>

...the same for default-no-eca ....and modify

<datasource name="localmysql"
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://<h2>192.168.111.248/pcm_ppaf?autoReconnect=true"
jdbc-username="pcm"
jdbc-password="pcm"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"
time-between-eviction-runs-millis="600000"/>

</datasource>

...the same thing for localmysqlolap, and localmysqltenant

So, i though that in my entityengine.xml.patch i had to find something about my changes.
PS : sorry for my bad english

g.fitini

Re: problem during deploy ofbiz.ear

In reply to this post by Jacques Le Roux

>
> <datasource name="derby"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> schema-name="ofbiz"
> field-type-name="derby"
> check-on-start="true"
> add-missing-on-start="true"
> use-pk-constraint-names="false"
> use-indices-unique="false"
> alias-view-columns="false">
> <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="org.apache.derby.jdbc.ClientDriver"
> jdbc-uri="jdbc:derby://localhost:1527/ofbiz;create=true"
> jdbc-username="ofbiz"
> jdbc-password="ofbiz"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"/>
>
> </datasource>
>
>
> <datasource name="derbyolap"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> schema-name="ofbiz"
> field-type-name="derby"
> check-on-start="true"
> add-missing-on-start="true"
> use-pk-constraint-names="false"
> use-indices-unique="false"
> alias-view-columns="false">
> <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="org.apache.derby.jdbc.ClientDriver"
> jdbc-uri="jdbc:derby://localhost:1527/ofbiz;create=true"
> jdbc-username="ofbiz"
> jdbc-password="ofbiz"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"/>
>
> </datasource>
>

while, in my entityengine in apache-ofbiz-12.04.01/framework/entity/config
folder, i've done :

......
.....
<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="localmysql"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localmysqlolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="localmysqltenant"/>

</delegator>

...the same for default-no-eca ....and modify

<datasource name="localmysql"
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://<h2>192.168.111.248/pcm_ppaf?autoReconnect=true"
jdbc-username="pcm"
jdbc-password="pcm"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"
time-between-eviction-runs-millis="600000"/>

</datasource>

...the same thing for localmysqlolap, and localmysqltenant

So, i though that in my entityengine.xml.patch i had to find something about
my changes.
PS : sorry for my bad english

-----Original Message-----
From: Jacques Le Roux
Sent: Tuesday, October 15, 2013 9:06 AM
To: [hidden email]
Subject: Re: problem during deploy ofbiz.ear

Attachments don't make through to ASF MLs, use rather Nabble user forum or
any mean you like for that

II don't remember all the details of the autogenerate deploy.sh. You could
try to use an OOTB entityengine.xml file

Also you say
>it is strange, because my personal entity engine, have the connection with
>mysql database. Any suggestion??

What do you mean exactly by that? Could you simply copy in your anwser the
patch content between your working copy and OFBIz repo for entityengine.xml
file only?

Jacques
----- Original Message -----
From: [hidden email]
To: [hidden email]
Sent: Monday, October 14, 2013 6:14 PM
Subject: problem during deploy ofbiz.ear

Hi to everyone, i’ve tried to follow this guide,
https://cwiki.apache.org/confluence/display/OFBTECH/Glassfish+v2.1 to
generate my ofbiz.ear, using the autogenerate deploy.sh

My ofbiz.ear is done by every war component of the application, and my
custom component in hot-deploy application

In attachment the structure of my ofbiz.ear.
Are anyone see something wrong??

And in my framework\entity\config\ folder, i’ve find 3 files :

entityengine.xml
entityengine.xml.rej
entityengine.xml.orig

i’ve look just the entityengine.xml,and it seem strange.... :

<datasource name="derby"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
schema-name="ofbiz"
field-type-name="derby"
check-on-start="true"
add-missing-on-start="true"
use-pk-constraint-names="false"
use-indices-unique="false"
alias-view-columns="false">
<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="org.apache.derby.jdbc.ClientDriver"
jdbc-uri="jdbc:derby://localhost:1527/ofbiz;create=true"
jdbc-username="ofbiz"
jdbc-password="ofbiz"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"/>

</datasource>

And another connection to datasource derbyolap.

it is strange, because my personal entity engine, have the connection with
mysql database. Any suggestion??