Le 04/06/2014 16:16, Ron Wheeler a écrit :
This is a suggestion to the dev list to try to incorporate all of the
documentation work being done in the ecosystem into the official docs.
In this particular case, the official docs are incomplete, outdated and just plain wrong but there is documentation that could be merged with the
official docs to help fix this problem.
It overlaps with the information that Adrian supplied but has screen shots and
text that would complement Adrian's complete but concse description.
It would be good for those of us who like to see the actual XML as well as the
instructions about how to create it.
Quite frankly, at the moment, if you judge this project by the documentation,
it is a long way from production quality.
I have confidence in the architecture and the functionality that I have had a chance to explore (1 day of investigation so far) but the docs look
like this is still a coding hobby rather than a serious product.
For example, if you look at the docs, it only documents 1 end-to-end process -
eCommerce.
No order entry, no AP process, no financial processes, etc.
Note though that there are books about that. Mmm actually Ruth Hoffman made an effort but it's now discontinued
http://www.aesolves.com/myofbiz/control/main/
Else I guess you know where the references to the books are
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Related+Books
I appears that there is no on-line help.
Actually there is one https://localhost:8443/cmssite/cms/APACHE_OFBIZ_HTML
But it's not much maintained for 3-4 years now
I am not sure about the nature of your comment but I hope that it does not
indicate that documentation is not a dev issue.
Not at all, maintaining the documentation is a daunting task but is indeed part
of developers jobs
There are many levels, you have the API doc, the technical and user docs and
then how much detail in each, etc.
I just would prefer to share more, on the user ML more people are reading, the
more the better
I would suggest that it is the number 1 dev issue that needs to be worked on to
grow the user base.
I totally agree, that why I answer and exchange with you
If I decide to commit to OfBiz, I am willing to help out but if there is no support by the community of architects and programmers, I can not do
anything.
Let's try
Jacques
Ron
On 04/06/2014 4:29 AM, Jacques Le Roux wrote:
Please don't copy this kind of messages to the dev ML
Thanks
Jacques
Le 04/06/2014 07:01, Ron Wheeler a écrit :
The screenshots would make a nice addition to the instructions that Adrian
supplied.
They worked very well and I am now trying to get my head around the actual
functionality.
It appears that everyone likes writing new documentation rather than fixing the
"official" docs.
Ron
On 03/06/2014 6:52 PM, Sergio G Barreros wrote:
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>
--
