I use newest mysql jdbc driver, 5.1.25. I will consider it. Thanks Jacques.
2013/7/6 Jacques Le Roux <jacques.le.r...@les7arts.com> > 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! > -- 叶双明