Hi, I downloaded ofbiz from source via svn last week and was able to using the application with the Derby database. I'm now working on integrating it with our other applications and migrating ofBiz to MySQL. When I go to run the initialization as described at http://www.opentaps.org/index.php?option=com_content&task=view&id=37&Itemid=62 I'm getting certain errors.
We are current using mysql 5.0.18-nt. The majority of the data is loading and I'm able to run the app but here are my problems: 1. While loading uom_conversion, mySQL is bombing on with a conversion error: Data truncation: Data truncated for column 'CONVERSION_FACTOR' the data in the GenericEntity for that column is set to: [conversionFactor,1.0E-10(java.lang.Double)] in the database, the table/column is defined as decimal(18,6). I've tried changing the size of the field to no avail. It seems that the value is passed to the prepared statement in the exponential format and mysql is bitch'n. The field type defined for uom_convers.conversion_factor is: field name="conversionFactor" type="floating-point" while the mysql field definition for floating-point is: field-type-def type="floating-point" sql-type="DECIMAL(18,6)" java-type="Double" The Mysql docs mention Decimal should map to java type BigDecimal: http://dev.mysql.com/doc/refman/5.0/en/cj-type-conversions.html The truncation also occurred with data inserted into supplier_product.last_price where the value being inserted was 1.4975 (Double) I've tried using the import data webtool to load framework/common/data/UnitData.xml and it fails consistently. Anybody got any suggestions? 2. There are a few tables that try insert data but there are foreign key constraints that are failing. Examples are: - facility, facility_contact and facility_contact_mech_purpose missing contact_mech foreign key - product_store_survey_appl missing prod_store foreign key - product_category_rollup, tax_authority_category missing product_category - contact_list_party and facility_contact_mech_purpose missing party "DemoCustCompany". It seems to me that the order that some of the data might have dependencies and before I dig into it, I wanted to see if anybody else has seen this problem? Thanks, John
