Can't install to MySQL 5 database

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Can't install to MySQL 5 database

exmbly
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.<init>(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

Reply | Threaded
Open this post in threaded view
|

Re: Can't install to MySQL 5 database

Mridul Pathak-2
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
[hidden email]

On Wed, Sep 2, 2009 at 10:49 PM, exmbly <[hidden email]> 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.<init>(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.
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Can't install to MySQL 5 database

exmbly
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.

<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>
    <delegator name="default-no-eca" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" entity-eca-enabled="false" distributed-cache-clear-enabled="false">
        <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
       
    </delegator>

   
    <delegator name="test" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main">
        <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
       
    </delegator>
    <delegator name="other" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main">
        <group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
    </delegator>

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.

<inline-jdbc
                jdbc-driver="com.mysql.jdbc.Driver"
                jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"
                jdbc-username="<myusername>"
                jdbc-password="<mypassword>"
                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.pathak@hotwaxmedia.com

On Wed, Sep 2, 2009 at 10:49 PM, exmbly <glenn@exmbly.com> 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.<init>(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.
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Can't install to MySQL 5 database

Shereen
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.

<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>
    <delegator name="default-no-eca" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" entity-eca-enabled="false" distributed-cache-clear-enabled="false">
        <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
       
    </delegator>

   
    <delegator name="test" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main">
        <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
       
    </delegator>
    <delegator name="other" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main">
        <group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
    </delegator>

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.

<inline-jdbc
                jdbc-driver="com.mysql.jdbc.Driver"
                jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true"
                jdbc-username="<myusername>"
                jdbc-password="<mypassword>"
                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.pathak@hotwaxmedia.com

On Wed, Sep 2, 2009 at 10:49 PM, exmbly <glenn@exmbly.com> 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.<init>(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.
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Can't install to MySQL 5 database

Bilgin Ibryam-2
On Sat, Oct 9, 2010 at 12:14 PM, Shereen <[hidden email]> 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.
> >
> > <delegator name="default" entity-model-reader="main"
> > entity-group-reader="main" entity-eca-reader="main"
> > distributed-cache-clear-enabled="false">
> >         <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
> >         <!-- <group-map group-name="org.ofbiz.olap"
> > datasource-name="localderbyolap"/>-->
> >     </delegator>
> >     <delegator name="default-no-eca" entity-model-reader="main"
> > entity-group-reader="main" entity-eca-reader="main"
> > entity-eca-enabled="false" distributed-cache-clear-enabled="false">
> >         <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
> >         <!-- <group-map group-name="org.ofbiz.olap"
> > datasource-name="localderbyolap"/>-->
> >     </delegator>
> >
> >     <!-- be sure that your default delegator (or the one you use) uses
> the
> > same datasource for test. You must run "ant run-install" before running
> > "ant run-tests" -->
> >     <delegator name="test" entity-model-reader="main"
> > entity-group-reader="main" entity-eca-reader="main">
> >         <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
> >         <!-- <group-map group-name="org.ofbiz.olap"
> > datasource-name="localderbyolap"/>-->
> >     </delegator>
> >     <delegator name="other" entity-model-reader="main"
> > entity-group-reader="main" entity-eca-reader="main">
> >         <group-map group-name="org.ofbiz"
> > datasource-name="localpostgres"/>
> >     </delegator>
> >
> > 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.
> >
> > <inline-jdbc
> >                 jdbc-driver="com.mysql.jdbc.Driver"
> >                 jdbc-uri="jdbc:mysql://
> 127.0.0.1/ofbiz?autoReconnect=true"
> >                 jdbc-username="<myusername>"
> >                 jdbc-password="<mypassword>"
> >                 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
> >> [hidden email]
> >>
> >> On Wed, Sep 2, 2009 at 10:49 PM, exmbly <[hidden email]> 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.<init>(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.
>