Hi Si, Guess what, the problem is with the JDBC driver. I downgraded from the 3.1.13 Connector/J 3.1 to the 3.0.17 as you mentioned and everything worked fine.
The correct driver is available at: http://dev.mysql.com/downloads/connector/j/3.0.html Thanks for your help. John On 7/26/06, Si Chen <[EMAIL PROTECTED]> wrote:
John, I've followed those instructinos and loaded successfully with MySQL 5.0.13 and 5.0.19, so I'm not sure why you're having this problem. Are you installing opentaps -0.9.1 or the SVN version of OFBiz? if the latter, can you see if the same problem happens if you used opentaps-0.9.1? Si On Jul 25, 2006, at 12:41 PM, John Martin wrote: > 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
