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
-----Original Message-----
From: Jacques Le Roux
Sent: Tuesday, October 15, 2013 9:06 AM
To: user@ofbiz.apache.org
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: g.fit...@telecgt.it
To: user@ofbiz.apache.org
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"/>
<!-- <jndi-jdbc jndi-server-name="localjndi"
jndi-name="java:/DerbyDataSource" isolation-level="ReadCommitted"/> -->
</datasource>
And another connection to datasource derbyolap.
it is strange, because my personal entity engine, have the connection with
mysql database. Any suggestion??