This is what I always use and it's very easy to follow.
http://lj4newbies.blogspot.com/2008/06/setup-mysql-with-ofbiz.html
Regards,
Sergio
On Tue, Jun 3, 2014 at 3:54 AM, Ron Wheeler
<rwhee...@artifact-software.com
<mailto:rwhee...@artifact-software.com>> wrote:
There is a description about how to add the database connector but
it is different and more complicated.
If necessary, put the correct JDBC driver in:
${ofbiz install dir}/framework/entity/lib/jdbc
replacing the old or incorrect version of the driver there (ie
copy in with same name to avoid problems with update restoring the
old driver later)
On 03/06/2014 12:31 AM, Deepak Dixit wrote:
One more step:
Don't forgot to put the mySql drive.
Use "./ant download-mySQL-JDBC" to download the mysql driver.
Thanks & Regards
---
Deepak Dixit
On Jun 3, 2014, at 3:10 AM, Adrian Crum
<adrian.c...@sandglass-software.com
<mailto:adrian.c...@sandglass-software.com>> wrote:
Here is what I recommend:
1. Restore the original file.
2. Modify the "localmysql" datasource element to connect
to your database.
3. Modify the "default" delegator element:
Change
<group-map group-name="org.ofbiz"
datasource-name="localderby"/>
to
<group-map group-name="org.ofbiz"
datasource-name="localmysql"/>
The OLAP and Tenant data sources will still use Derby. If
you want to change those to use MySQL also, then:
1. Modify the "localmysqlolap" datasource element to
connect to your OLAP database.
2. Modify the "localmysqltenant" datasource element to
connect to your Tenant database.
3. Modify the "default" delegator element:
Change
<group-map group-name="org.ofbiz.olap"
datasource-name="localderbyolap"/>
to
<group-map group-name="org.ofbiz.olap"
datasource-name="localmysqlolap"/>
Change
<group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
to
<group-map group-name="org.ofbiz.tenant"
datasource-name="localmysqltenant"/>
Finally, run:
ant load-demo
Adrian Crum
Sandglass Software
www.sandglass-software.com
<http://www.sandglass-software.com>
On 6/2/2014 2:26 PM, Ron Wheeler wrote:
In entityengine.xml, I removed the databases that I
am not using just
to make it clearer.
As OfBiz is distributed there seems to be several
group-map entries that
are active and some commented out.
There seemed to be several different group-names in
use.
Did I understand the instructions incorrectly or have
I screwed up
somewhere else?
The ofbiz database exists and the ofbiz user has all
privs on it.
A null pointer usually means that I promised to
provide an object and I
didn't rather than a database security error.
I have not touched any other configuration files.
<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"/>
</delegator>
.
.
.
<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="latin1"
collate="latin1_general_cs">
<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/ofbiz?autoReconnect=true
<http://127.0.0.1/ofbiz?autoReconnect=true>"
jdbc-username="ofbiz"
jdbc-password="mylittlesecret"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"
time-between-eviction-runs-millis="600000"/>
</datasource>
Gives me:
[java] 2014-06-02 17:14:05,843 (main) [
ModelViewEntity.java:551:WARN ] [ExampleStatusDetail]:
Conversion for
complex-alias needs to be implemented for cache and
in-memory eval stuff
to work correctly, will not work for alias: statusDelay
[java] 2014-06-02 17:14:06,202 (main) [
ModelReader.java:436:INFO
] FINISHED LOADING ENTITIES - ALL FILES; #Entities=863
#ViewEntities=300
#Fields=9049 #Relationships=2961
#AutoRelationships=2186
[java] 2014-06-02 17:14:06,297 (main) [
GenericDelegator.java:234:INFO ] Doing entity
definition check...
[java] 2014-06-02 17:14:06,317 (main) [
ModelEntityChecker.java:508:INFO ] [initReservedWords]
array length=1023
[java] java.lang.NullPointerException
[java] at
org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:541)
[java] at
org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:107)
[java] at
org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:235)
[java] at
org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33)
[java] at
org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25)
[java] at
org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202)
[java] at
org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:51)
[java] at
org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:272)
[java] at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:236)
[java] at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:230)
[java] at
org.ofbiz.base.start.Start.startStartLoaders(Start.java:362)
[java] at
org.ofbiz.base.start.Start.start(Start.java:337)
[java] at
org.ofbiz.base.start.Start.main(Start.java:139)
[java] 2014-06-02 17:14:07,337 (Thread-0) [
ContainerLoader.java:246:INFO ] Shutting down
containers
[java] Java Result: 99
BUILD SUCCESSFUL
Total time: 31 seconds
On 02/06/2014 4:26 PM, Adrian Crum wrote:
The correct steps are there:
Modify an existing datasource (near the bottom of
the file) or create
a new one by copying one of the sample datasources
already there and
giving it a new unique name
If using the default OFBiz transaction manager
and connection
pool, update the data URI, username and password
in the inline-jdbc tag
If you want your OFBiz tables in a special
schema first create
that schema in your database, then set the
schema-name attribute on
the datasource tag
Find the "default" delegator near the top of
the file and change
the datasource-name attribute value in the
group-map tag under it to
the name of the data source you modified or
created.
Adrian Crum
Sandglass Software
www.sandglass-software.com
<http://www.sandglass-software.com>
On 6/2/2014 1:01 PM, Ron Wheeler wrote:
It appears that there is a missing step in the
description about how to
run OfBiz with a database other than Derby.
https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide
talks about changing the "default" delegator
but it does not mention
anywhere that I can find, how you tell OfBiz
that you want to use the
delegator associated with My SQL.
I am getting a null pointer which I think is
caused by OfBiz still
trying to use Derby which no longer has a
delegator sice it is commented
out and the MySQL one is uncommented.
What is the secret step tat I need to to to
make the instructions work?
Ron
-- Ron Wheeler
President
Artifact Software Inc
email: rwhee...@artifact-software.com
<mailto:rwhee...@artifact-software.com>
skype: ronaldmwheeler
phone: 866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
