Re: Users - Validating imported data

Posted by Ray Barlow on Apr 01, 2006; 2:07am
URL: http://ofbiz.116.s1.nabble.com/Users-Validating-imported-data-tp138294p138297.html

To be clear the entity engine in ofbiz does not validate data against
foreign key constraints. It will create the FK constraints in the
database, but it is then down to the DB to enforce which is where not
all DBs are equal.

Ray

Kenneth Porter wrote:

>On Friday, March 31, 2006 10:45 PM +0200 David Welton
><[hidden email]> wrote:
>
>  
>
>>Be careful with Mysql... it won't validate some kinds of data.  I've
>>had bad experiences with it personally:
>>
>>http://journal.dedasys.com/articles/2006/03/17/mysql
>>    
>>
>
>My presumption was that the required OFBiz constraints weren't entirely
>reflected in the underlying DB, and were partly encapsulated in the data
>entry routines, so if one inserted data directly into the DB, some kind of
>validation would have to be run to ensure that the data met the
>expectations of the code.
>
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
>  
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users