Return-Path: 
 <user-return-43243-apmail-ofbiz-user-archive=ofbiz.apache.org@ofbiz.apache.org>
X-Original-To: apmail-ofbiz-user-archive@www.apache.org
Delivered-To: apmail-ofbiz-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 5E12F10CCA
	for <apmail-ofbiz-user-archive@www.apache.org>;
 Sat,  6 Jul 2013 08:19:07 +0000 (UTC)
Received: (qmail 53417 invoked by uid 500); 6 Jul 2013 08:19:06 -0000
Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org
Received: (qmail 53190 invoked by uid 500); 6 Jul 2013 08:19:06 -0000
Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@ofbiz.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@ofbiz.apache.org>
List-Post: <mailto:user@ofbiz.apache.org>
List-Id: <user.ofbiz.apache.org>
Reply-To: user@ofbiz.apache.org
Delivered-To: mailing list user@ofbiz.apache.org
Received: (qmail 53181 invoked by uid 99); 6 Jul 2013 08:19:06 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 06 Jul 2013 08:19:06 +0000
X-ASF-Spam-Status: No, hits=0.0 required=5.0
	tests=RCVD_IN_DNSWL_NONE
X-Spam-Check-By: apache.org
Received-SPF: error (nike.apache.org: local policy)
Received: from [93.17.128.82] (HELO smtp24.services.sfr.fr) (93.17.128.82)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 06 Jul 2013 08:18:59 +0000
Received: from filter.sfr.fr (localhost [127.0.0.1])
	by msfrf2409.sfr.fr (SMTP Server) with ESMTP id C4F9170000AB
	for <user@ofbiz.apache.org>; Sat,  6 Jul 2013 10:18:18 +0200 (CEST)
Received: from inspiron530 (21.68.14.81.rev.sfr.net [81.14.68.21])
	by msfrf2409.sfr.fr (SMTP Server) with SMTP id 8219370000A8
	for <user@ofbiz.apache.org>; Sat,  6 Jul 2013 10:18:18 +0200 (CEST)
X-SFR-UUID: 20130706081818533.8219370000A8@msfrf2409.sfr.fr
Message-ID: <95D796A1377A4A1F83DBB7B812BA31F9@inspiron530>
From: Jacques Le Roux <jacques.le.roux@les7arts.com>
To: user@ofbiz.apache.org
References: 
 <CAHKAdaUYeh3yOqr1NqY87gTKmXJQEkZnhJm_5heS9=M2MNRN6Q@mail.gmail.com>
Subject: Re: Problem use extend-entity under mysql 5.1.41
Date: Sat, 6 Jul 2013 10:18:04 +0200
Organization: Les Arts Informatiques
MIME-Version: 1.0
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
X-Virus-Checked: Checked by ClamAV on apache.org

This is more likely an issue with the JDBC driver, try to update it if =
possible, but no guarantees...=20
Anyway, if you can, I'd recommend to use Postgres, for few other reasons

Jacques

=E5=8F=B6=E5=8F=8C=E6=98=8E wrote:
> Hi all,
> I extend an entity after table has been created, like this:
> <extend-entity entity-name=3D"ProductPromoCodeParty">
> <field name=3D"statusId" type=3D"id"></field>
> <field name=3D"useDate" type=3D"date-time"></field>
> <relation type=3D"one" fk-name=3D"PROD_PRCDP_PCD_STTS"
> rel-entity-name=3D"StatusItem" >
>          <key-map field-name=3D"statusId"/>
>        </relation>
> </extend-entity>
> , and add  check-fk-indices-on-start=3D"true" =
check-fks-on-start=3D"true" to
> node datasource in entityengine.xml.
>=20
> 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.
>=20
> Is a issue of mysql or ofbiz?
>=20
> And, When i test it with postgreSQL, everything is ok!