Re: Problem: mysql with ofbiz 10.4

[Rakesh_Ists]

Hi

I have put the mysql jar at location   /opt/Radical/ofbiz/framework/entity/lib/jdbc  version  mysql-connector-java-5.1.6-bin.jar.

Following are the  the entityengine.xml

<?xml version="1.0" encoding="UTF-8" ?>

<entity-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entity-config.xsd">
    <resource-loader name="fieldfile" class="org.ofbiz.base.config.FileLoader"
            prepend-env="ofbiz.home" prefix="/framework/entity/fieldtype/"/>

   
   
    <transaction-factory class="org.ofbiz.geronimo.GeronimoTransactionFactory"/>

   
   
   

   
    <connection-factory class="org.ofbiz.entity.connection.DBCPConnectionFactory"/>

    <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="odbcmysql"/>
             
    </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="odbcmysql"/>
 </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"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="odbcmysql"/>
    </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>

   
    <entity-model-reader name="main"/>

   
    <entity-group-reader name="main"/>

   
    <entity-eca-reader name="main"/>

   
   
    <entity-data-reader name="seed"/>
    <entity-data-reader name="seed-initial"/>
    <entity-data-reader name="demo"/>
    <entity-data-reader name="ext"/>
    <entity-data-reader name="ext-test"/>
    <entity-data-reader name="ext-demo"/>

    <field-type name="hsql" loader="fieldfile" location="fieldtypehsql.xml"/>
    <field-type name="derby" loader="fieldfile" location="fieldtypederby.xml"/>
    <field-type name="cloudscape" loader="fieldfile" location="fieldtypecloudscape.xml"/>
    <field-type name="daffodil" loader="fieldfile" location="fieldtypedaffodil.xml"/>
    <field-type name="axion" loader="fieldfile" location="fieldtypeaxion.xml"/>
    <field-type name="mysql" loader="fieldfile" location="fieldtypemysql.xml"/>
    <field-type name="postgres" loader="fieldfile" location="fieldtypepostgres.xml"/>
    <field-type name="postnew" loader="fieldfile" location="fieldtypepostnew.xml"/>
    <field-type name="oracle" loader="fieldfile" location="fieldtypeoracle.xml"/>
    <field-type name="sapdb" loader="fieldfile" location="fieldtypesapdb.xml"/>
    <field-type name="sybase" loader="fieldfile" location="fieldtypesybase.xml"/>
    <field-type name="firebird" loader="fieldfile" location="fieldtypefirebird.xml"/>
    <field-type name="mssql" loader="fieldfile" location="fieldtypemssql.xml"/>
    <field-type name="advantage" loader="fieldfile" location="fieldtypeadvantage.xml"/>

   
 

    <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="utf8"
            collate="utf8_general_ci">
        <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="root"
                jdbc-password="ists"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="250"/>
       
    </datasource>
    <datasource name="odbcmysql"
            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="utf8"
            collate="utf8_general_ci">
        <read-data reader-name="seed"/>
        <inline-jdbc
                jdbc-driver="com.mysql.jdbc.Driver"
                jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=true"
                jdbc-username="root"
                jdbc-password="ists"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="250"/>
        </datasource>
 
</entity-config>

But when I run  ./ant run-install command, I got the following error


to work correctly, will not work for alias: totQuantityAvailable of view-entity OrderItemAndShipGrpInvResAndItemSum
     [java] 2011-06-27 20:17:08,978 (main) [        ModelReader.java:389:INFO ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=849 #ViewEntities=267 #Fields=8870 #Relationships=2925 #AutoRelationships=2157
     [java] 2011-06-27 20:17:08,989 (main) [   GenericDelegator.java:244:INFO ] Doing entity definition check...
     [java] 2011-06-27 20:17:08,994 (main) [ ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023
     [java] Exception in thread "main" java.lang.NullPointerException
     [java]     at org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548)
     [java]     at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101)
     [java]     at org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:245)
     [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:47)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100)
     [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:411)
     [java] 2011-06-27 20:17:09,050 (OFBiz_Shutdown_Hook) [    ContainerLoader.java:113:INFO ] Shutting down containers
     [java] Java Result: 1

BUILD SUCCESSFUL



Could you please help me to come out of this problem.


Regards,
Rakesh