Re: Problem use extend-entity under mysql 5.1.41

2013-07-15 Thread Rishi Solanki
I'm not sure but if you rename the fk-name="PROD_PRCDP_PCD_STTS" to fk-name="PPCP_STTS" i.e less than 18 character then it should work. Came across the similar problem, Mysql uses one extra character for some internal usage and that is why you got it worked for postgres. Hope it helps! Rishi Sol

Re: Problem use extend-entity under mysql 5.1.41

2013-07-06 Thread 叶双明
I use newest mysql jdbc driver, 5.1.25. I will consider it. Thanks Jacques. 2013/7/6 Jacques Le Roux > 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

Re: Problem use extend-entity under mysql 5.1.41

2013-07-06 Thread Jacques Le Roux
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: > > > > rel-entity-name="

Problem use extend-entity under mysql 5.1.41

2013-07-06 Thread 叶双明
Hi all, I extend an entity after table has been created, like this: , 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,