Re: Can't install to MySQL 5 database
On Sat, Oct 9, 2010 at 12:14 PM, Shereen wrote: > > Would anyone please tell me the right to steps to use mysql database > instead > of derby? > I know that I should change the entityengine.xml as exmply did what else > should i do? > add the jdbc library to framework/entity/lib/jdbc > also I have another question can I use external mysql server instead of > localmysql? > Yes Bilgin > > > exmbly wrote: > > > > Hi, Mridul, > > > > I only made changes to the delegator and localmysql > > datasource/inline-jdbc. > > > > Here's my delegators. I set things to localmysql datasourc and commented > > out the olap stuff. I wasn't sure about the default-no-eca so I changed > > that to localmysql datasource as well. Same for test. > > > > > entity-group-reader="main" entity-eca-reader="main" > > distributed-cache-clear-enabled="false"> > > > > > > > > > entity-group-reader="main" entity-eca-reader="main" > > entity-eca-enabled="false" distributed-cache-clear-enabled="false"> > > > > > > > > > > > > > entity-group-reader="main" entity-eca-reader="main"> > > > > > > > > > entity-group-reader="main" entity-eca-reader="main"> > > > datasource-name="localpostgres"/> > > > > > > The only other change I made was to the localmysql datasource inline-jdbc > > element to point to my instance of MySQL with my username and password. I > > created the ofbiz schema in MySQL as well. > > > > > jdbc-driver="com.mysql.jdbc.Driver" > > jdbc-uri="jdbc:mysql:// > 127.0.0.1/ofbiz?autoReconnect=true" > > jdbc-username="" > > jdbc-password="" > > isolation-level="ReadCommitted" > > pool-minsize="2" > > pool-maxsize="250"/> > > > > Do you think I did something wrong here? > > > > Thanks for your help. > > > > Glenn... > > > > Mridul Pathak-2 wrote: > >> > >> Can you please share your entityengine.xml file, there might be some > >> problem > >> in the configurations you have done. > >> -- > >> Thanks & Regards > >> Mridul Pathak > >> Hotwax Media > >> http://www.hotwaxmedia.com > >> mridul.pat...@hotwaxmedia.com > >> > >> On Wed, Sep 2, 2009 at 10:49 PM, exmbly wrote: > >> > >>> > >>> I get the following error running ant run-install after changing to a > >>> MySQL > >>> 5 > >>> database ( installing the jdbc driver and modifying entityengine.xml): > >>> > >>> [java] 2009-09-02 10:03:59,809 (main) [ > ModelEntityChecker.java:501:INFO > >>> ] > >>> [initReservedWords] array length=1023 > >>> [java] Exception in thread "main" java.lang.NullPointerException > >>> [java] at > >>> > org.ofbiz.entity.DelegatorImpl.getEntityFieldType(DelegatorImpl.java:1480) > >>> [java] at > >>> > >>> > org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) > >>> [java] at > >>> org.ofbiz.entity.DelegatorImpl.(DelegatorImpl.java:171) > >>> [java] at > >>> > >>> > org.ofbiz.entity.DelegatorFactory.getGenericDelegator(DelegatorFactory.java:40) > >>> [java] at > >>> > >>> > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:228) > >>> [java] at > >>> > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) > >>> [java] at > >>> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) > >>> [java] at > org.ofbiz.base.start.Start.startServer(Start.java:322) > >>> [java] at org.ofbiz.base.start.Start.start(Start.java:326) > >>> [java] at org.ofbiz.base.start.Start.main(Start.java:409) > >>> [java] 2009-09-02 10:03:59,856 (OFBiz_Shutdown_Hook) [ > >>> ContainerLoader.java:114:INFO ] Shutting down containers > >>> [java] Java Result: 1 > >>> > >>> > >>> -- > >>> View this message in context: > >>> > http://www.nabble.com/Can%27t-install-to-MySQL-5-database-tp25261762p25261762.html > >>> Sent from the OFBiz - User mailing list archive at Nabble.com. > >>> > >>> > >> > >> > > > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Can-t-install-to-MySQL-5-database-tp163486p2969472.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
Re: Can't install to MySQL 5 database
Would anyone please tell me the right to steps to use mysql database instead of derby? I know that I should change the entityengine.xml as exmply did what else should i do? also I have another question can I use external mysql server instead of localmysql? exmbly wrote: > > Hi, Mridul, > > I only made changes to the delegator and localmysql > datasource/inline-jdbc. > > Here's my delegators. I set things to localmysql datasourc and commented > out the olap stuff. I wasn't sure about the default-no-eca so I changed > that to localmysql datasource as well. Same for test. > > entity-group-reader="main" entity-eca-reader="main" > distributed-cache-clear-enabled="false"> > > > > entity-group-reader="main" entity-eca-reader="main" > entity-eca-enabled="false" distributed-cache-clear-enabled="false"> > > > > > > entity-group-reader="main" entity-eca-reader="main"> > > > > entity-group-reader="main" entity-eca-reader="main"> > datasource-name="localpostgres"/> > > > The only other change I made was to the localmysql datasource inline-jdbc > element to point to my instance of MySQL with my username and password. I > created the ofbiz schema in MySQL as well. > > jdbc-driver="com.mysql.jdbc.Driver" > jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true" > jdbc-username="" > jdbc-password="" > isolation-level="ReadCommitted" > pool-minsize="2" > pool-maxsize="250"/> > > Do you think I did something wrong here? > > Thanks for your help. > > Glenn... > > Mridul Pathak-2 wrote: >> >> Can you please share your entityengine.xml file, there might be some >> problem >> in the configurations you have done. >> -- >> Thanks & Regards >> Mridul Pathak >> Hotwax Media >> http://www.hotwaxmedia.com >> mridul.pat...@hotwaxmedia.com >> >> On Wed, Sep 2, 2009 at 10:49 PM, exmbly wrote: >> >>> >>> I get the following error running ant run-install after changing to a >>> MySQL >>> 5 >>> database ( installing the jdbc driver and modifying entityengine.xml): >>> >>> [java] 2009-09-02 10:03:59,809 (main) [ ModelEntityChecker.java:501:INFO >>> ] >>> [initReservedWords] array length=1023 >>> [java] Exception in thread "main" java.lang.NullPointerException >>> [java] at >>> org.ofbiz.entity.DelegatorImpl.getEntityFieldType(DelegatorImpl.java:1480) >>> [java] at >>> >>> org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) >>> [java] at >>> org.ofbiz.entity.DelegatorImpl.(DelegatorImpl.java:171) >>> [java] at >>> >>> org.ofbiz.entity.DelegatorFactory.getGenericDelegator(DelegatorFactory.java:40) >>> [java] at >>> >>> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:228) >>> [java] at >>> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) >>> [java] at >>> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) >>> [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) >>> [java] at org.ofbiz.base.start.Start.start(Start.java:326) >>> [java] at org.ofbiz.base.start.Start.main(Start.java:409) >>> [java] 2009-09-02 10:03:59,856 (OFBiz_Shutdown_Hook) [ >>> ContainerLoader.java:114:INFO ] Shutting down containers >>> [java] Java Result: 1 >>> >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Can%27t-install-to-MySQL-5-database-tp25261762p25261762.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >>> >> >> > > -- View this message in context: http://ofbiz.135035.n4.nabble.com/Can-t-install-to-MySQL-5-database-tp163486p2969472.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can't install to MySQL 5 database
Hi, Mridul, I only made changes to the delegator and localmysql datasource/inline-jdbc. Here's my delegators. I set things to localmysql datasourc and commented out the olap stuff. I wasn't sure about the default-no-eca so I changed that to localmysql datasource as well. Same for test. The only other change I made was to the localmysql datasource inline-jdbc element to point to my instance of MySQL with my username and password. I created the ofbiz schema in MySQL as well. Do you think I did something wrong here? Thanks for your help. Glenn... Mridul Pathak-2 wrote: > > Can you please share your entityengine.xml file, there might be some > problem > in the configurations you have done. > -- > Thanks & Regards > Mridul Pathak > Hotwax Media > http://www.hotwaxmedia.com > mridul.pat...@hotwaxmedia.com > > On Wed, Sep 2, 2009 at 10:49 PM, exmbly wrote: > >> >> I get the following error running ant run-install after changing to a >> MySQL >> 5 >> database ( installing the jdbc driver and modifying entityengine.xml): >> >> [java] 2009-09-02 10:03:59,809 (main) [ ModelEntityChecker.java:501:INFO >> ] >> [initReservedWords] array length=1023 >> [java] Exception in thread "main" java.lang.NullPointerException >> [java] at >> org.ofbiz.entity.DelegatorImpl.getEntityFieldType(DelegatorImpl.java:1480) >> [java] at >> >> org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) >> [java] at >> org.ofbiz.entity.DelegatorImpl.(DelegatorImpl.java:171) >> [java] at >> >> org.ofbiz.entity.DelegatorFactory.getGenericDelegator(DelegatorFactory.java:40) >> [java] at >> >> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:228) >> [java] at >> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) >> [java] at >> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) >> [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) >> [java] at org.ofbiz.base.start.Start.start(Start.java:326) >> [java] at org.ofbiz.base.start.Start.main(Start.java:409) >> [java] 2009-09-02 10:03:59,856 (OFBiz_Shutdown_Hook) [ >> ContainerLoader.java:114:INFO ] Shutting down containers >> [java] Java Result: 1 >> >> >> -- >> View this message in context: >> http://www.nabble.com/Can%27t-install-to-MySQL-5-database-tp25261762p25261762.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> >> > > -- View this message in context: http://www.nabble.com/Can%27t-install-to-MySQL-5-database-tp25261762p25279126.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can't install to MySQL 5 database
Can you please share your entityengine.xml file, there might be some problem in the configurations you have done. -- Thanks & Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com mridul.pat...@hotwaxmedia.com On Wed, Sep 2, 2009 at 10:49 PM, exmbly wrote: > > I get the following error running ant run-install after changing to a MySQL > 5 > database ( installing the jdbc driver and modifying entityengine.xml): > > [java] 2009-09-02 10:03:59,809 (main) [ ModelEntityChecker.java:501:INFO ] > [initReservedWords] array length=1023 > [java] Exception in thread "main" java.lang.NullPointerException > [java] at > org.ofbiz.entity.DelegatorImpl.getEntityFieldType(DelegatorImpl.java:1480) > [java] at > > org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) > [java] at > org.ofbiz.entity.DelegatorImpl.(DelegatorImpl.java:171) > [java] at > > org.ofbiz.entity.DelegatorFactory.getGenericDelegator(DelegatorFactory.java:40) > [java] at > > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:228) > [java] at > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) > [java] at > org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) > [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) > [java] at org.ofbiz.base.start.Start.start(Start.java:326) > [java] at org.ofbiz.base.start.Start.main(Start.java:409) > [java] 2009-09-02 10:03:59,856 (OFBiz_Shutdown_Hook) [ > ContainerLoader.java:114:INFO ] Shutting down containers > [java] Java Result: 1 > > > -- > View this message in context: > http://www.nabble.com/Can%27t-install-to-MySQL-5-database-tp25261762p25261762.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > >
Can't install to MySQL 5 database
I get the following error running ant run-install after changing to a MySQL 5 database ( installing the jdbc driver and modifying entityengine.xml): [java] 2009-09-02 10:03:59,809 (main) [ ModelEntityChecker.java:501:INFO ] [initReservedWords] array length=1023 [java] Exception in thread "main" java.lang.NullPointerException [java] at org.ofbiz.entity.DelegatorImpl.getEntityFieldType(DelegatorImpl.java:1480) [java] at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) [java] at org.ofbiz.entity.DelegatorImpl.(DelegatorImpl.java:171) [java] at org.ofbiz.entity.DelegatorFactory.getGenericDelegator(DelegatorFactory.java:40) [java] at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:228) [java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101) [java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) [java] at org.ofbiz.base.start.Start.start(Start.java:326) [java] at org.ofbiz.base.start.Start.main(Start.java:409) [java] 2009-09-02 10:03:59,856 (OFBiz_Shutdown_Hook) [ ContainerLoader.java:114:INFO ] Shutting down containers [java] Java Result: 1 -- View this message in context: http://www.nabble.com/Can%27t-install-to-MySQL-5-database-tp25261762p25261762.html Sent from the OFBiz - User mailing list archive at Nabble.com.