If someone hasn't suggested it already then get rid of this section:
> <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>

You don't have a localpostgres datasource defined so you're going to get errors 
there.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 27/06/2011, at 7:33 PM, Rakesh_Ists wrote:

> Hi,
> 
> It started proper with derby.
> 
> my entityEngine.xml look likes as folows
> 
> <?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="abc"
>                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="abc"
>                isolation-level="ReadCommitted"
>                pool-minsize="2"
>                pool-maxsize="250"/>
>       </datasource>
> 
> </entity-config>
> 
> 
> --
> View this message in context: 
> http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3627126.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to