You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Ron Wheeler <rw...@artifact-software.com> on 2014/06/03 09:54:38 UTC
Re: Getting Started using MySQL
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 <ad...@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
>>
>> 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"
>>> 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
>>>>
>>>> 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: rwheeler@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
Re: Getting Started using MySQL
Posted by Jacques Le Roux <ja...@les7arts.com>.
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 <rwheeler@artifact-software.com <ma...@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.crum@sandglass-software.com
>>>> <ma...@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: rwheeler@artifact-software.com
>>>> <ma...@artifact-software.com>
>>>> skype: ronaldmwheeler
>>>> phone: 866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
>>>>
>>>>
>>>
>>>
>>
>
>
--
Re: Getting Started using MySQL
Posted by Ron Wheeler <rw...@artifact-software.com>.
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.
I appears that there is no on-line help.
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.
I would suggest that it is the number 1 dev issue that needs to be
worked on to grow the user base.
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.
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
>>> <rwheeler@artifact-software.com
>>> <ma...@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.crum@sandglass-software.com
>>> <ma...@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: rwheeler@artifact-software.com
>>> <ma...@artifact-software.com>
>>> skype: ronaldmwheeler
>>> phone: 866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
>>>
>>>
>>
>>
>
--
Ron Wheeler
President
Artifact Software Inc
email: rwheeler@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
Re: Getting Started using MySQL
Posted by Jacques Le Roux <ja...@les7arts.com>.
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 <rwheeler@artifact-software.com <ma...@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.crum@sandglass-software.com
>> <ma...@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: rwheeler@artifact-software.com
>> <ma...@artifact-software.com>
>> skype: ronaldmwheeler
>> phone: 866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
>>
>>
>
>
--
Re: Getting Started using MySQL
Posted by Jacques Le Roux <ja...@les7arts.com>.
Le 04/06/2014 17:05, Ron Wheeler a écrit :
> I do get worked up over documentation!
>
> It is a bit like living in a house where everyone wants to cook but no one will wash the pots and pans!
> The food is great for a while but eventually no one trusts the food after they see the kitchen.
Good analogy :D
>
> Trying to get people to clean up the docs while they write the code is a challenge but it is part of the project management process.
> Asking people to write docs in their second or third language is hard but perhaps might be easier if they knew that an editor would fix the English.
> I can help smooth out phrasing, clean up grammar, etc. but if the software developers don't provide the facts, I can not make them up.
>
> For example, the person who changed the Ant build has to fix the docs, no one else knows what changed.
Yes, as often, it's a matter of human resources
>
> Does the project have a group in charge of documentation?
No, it's all benevolent work and it's hard to organise things because we have to earn a living outside and the situation is continuously changing
(most of active volunters are independent or working for companies who did a great effort at some point but, I guess, have also to fight everyday to
keep on their paths
> Does this group have the same control over releases as the coders?
>
> This is hard to do in an open source project but if the basic documentation being wrong or incomplete is not a blocker on the release it will never
> get fixed.
That's quite an idea, I'd love to see it applied. But it might be only a dream too few people among committers and even PMC feel concerned nowadays.
And this same PMC is reluctant to invite new people, afraid of the quality their help could offer (there are already some experience about that)
https://cwiki.apache.org/confluence/display/OFBADMIN/Apache+OFBiz+PMC+%28Project+Management+Committee%29+Members+and+Committers
>
> OfBiz looks like a 0.6 release level from the outside.
Hold on, it looks at least like a 0.9 to me from this perspective :p
> Once you get into it, it is clearly a highly functional project but the apparent quality is low.
> I am not sure what impact that this has on adoption but I suspect that it is a big deterrent.
>
I so much agree
> For some people, this is probably just more ranting but the state of the docs is important and needs to be a bigger concern for all of the developers.
Could developers listen to you...
Jacques
>
> Ron
>
>
>
> On 04/06/2014 4:29 AM, Jacques Le Roux wrote:
>> You are welcome to help... Rants never do...
>>
>> 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 <rwheeler@artifact-software.com <ma...@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.crum@sandglass-software.com
>>>> <ma...@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: rwheeler@artifact-software.com
>>>> <ma...@artifact-software.com>
>>>> skype: ronaldmwheeler
>>>> phone: 866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
>>>>
>>>>
>>>
>>>
>>
>
>
--
Re: Getting Started using MySQL
Posted by Ron Wheeler <rw...@artifact-software.com>.
I do get worked up over documentation!
It is a bit like living in a house where everyone wants to cook but no
one will wash the pots and pans!
The food is great for a while but eventually no one trusts the food
after they see the kitchen.
Trying to get people to clean up the docs while they write the code is a
challenge but it is part of the project management process.
Asking people to write docs in their second or third language is hard
but perhaps might be easier if they knew that an editor would fix the
English.
I can help smooth out phrasing, clean up grammar, etc. but if the
software developers don't provide the facts, I can not make them up.
For example, the person who changed the Ant build has to fix the docs,
no one else knows what changed.
Does the project have a group in charge of documentation?
Does this group have the same control over releases as the coders?
This is hard to do in an open source project but if the basic
documentation being wrong or incomplete is not a blocker on the release
it will never get fixed.
OfBiz looks like a 0.6 release level from the outside.
Once you get into it, it is clearly a highly functional project but the
apparent quality is low.
I am not sure what impact that this has on adoption but I suspect that
it is a big deterrent.
For some people, this is probably just more ranting but the state of
the docs is important and needs to be a bigger concern for all of the
developers.
Ron
On 04/06/2014 4:29 AM, Jacques Le Roux wrote:
> You are welcome to help... Rants never do...
>
> 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
>>> <rwheeler@artifact-software.com
>>> <ma...@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.crum@sandglass-software.com
>>> <ma...@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: rwheeler@artifact-software.com
>>> <ma...@artifact-software.com>
>>> skype: ronaldmwheeler
>>> phone: 866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
>>>
>>>
>>
>>
>
--
Ron Wheeler
President
Artifact Software Inc
email: rwheeler@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
Re: Getting Started using MySQL
Posted by Jacques Le Roux <ja...@les7arts.com>.
You are welcome to help... Rants never do...
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 <rwheeler@artifact-software.com <ma...@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.crum@sandglass-software.com
>> <ma...@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: rwheeler@artifact-software.com
>> <ma...@artifact-software.com>
>> skype: ronaldmwheeler
>> phone: 866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
>>
>>
>
>
--
Re: Getting Started using MySQL
Posted by Ron Wheeler <rw...@artifact-software.com>.
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
> <rwheeler@artifact-software.com
> <ma...@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.crum@sandglass-software.com
> <ma...@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: rwheeler@artifact-software.com
> <ma...@artifact-software.com>
> skype: ronaldmwheeler
> phone: 866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
>
>
--
Ron Wheeler
President
Artifact Software Inc
email: rwheeler@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
Re: Getting Started using MySQL
Posted by Ron Wheeler <rw...@artifact-software.com>.
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
> <rwheeler@artifact-software.com
> <ma...@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.crum@sandglass-software.com
> <ma...@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: rwheeler@artifact-software.com
> <ma...@artifact-software.com>
> skype: ronaldmwheeler
> phone: 866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
>
>
--
Ron Wheeler
President
Artifact Software Inc
email: rwheeler@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
Re: Getting Started using MySQL
Posted by Sergio G Barreros <sg...@gmail.com>.
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 <rw...@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.crum@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
>>>
>>> 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"
>>>> 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
>>>>>
>>>>> 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: rwheeler@artifact-software.com
> skype: ronaldmwheeler
> phone: 866-970-2435, ext 102
>
>