ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques Le Roux <jacques.le.r...@les7arts.com>
Subject Re: Problem use extend-entity under mysql 5.1.41
Date Sat, 06 Jul 2013 08:18:04 GMT
This is more likely an issue with the JDBC driver, try to update it if possible, but no guarantees...

Anyway, if you can, I'd recommend to use Postgres, for few other reasons

Jacques

叶双明 wrote:
> Hi all,
> I extend an entity after table has been created, like this:
> <extend-entity entity-name="ProductPromoCodeParty">
> <field name="statusId" type="id"></field>
> <field name="useDate" type="date-time"></field>
> <relation type="one" fk-name="PROD_PRCDP_PCD_STTS"
> rel-entity-name="StatusItem" >
>          <key-map field-name="statusId"/>
>        </relation>
> </extend-entity>
> , and add  check-fk-indices-on-start="true" check-fks-on-start="true" to
> node datasource in entityengine.xml.
> 
> after restart ofbiz, field statusId and useDate is appear in the
> table product_promo_code_party, but no PROD_PRCDP_PCD_STTS.
> found in error.log:
> 2013-07-06 14:14:33,796 (OFBiz-config-0) [
> DatabaseUtil.java:1439:ERROR] Error getting fk reference meta data Error
> was:java.sql.SQLException: Table not specified.. Not checking fk refs.
> 
> Is a issue of mysql or ofbiz?
> 
> And, When i test it with postgreSQL, everything is ok!

Mime
View raw message