Re: Loading Seed and Demo Data into MySQL failing

Si Chen Wed, 26 Jul 2006 12:03:46 -0700

John,

opentaps 0.9 comes with this in driver:
mysql-connector-java-3.0.17-ga-bin.jar


and everything worked out of the box.

Si


On Jul 26, 2006, at 12:00 PM, John Martin wrote:

Hi Si,

I just tried a brand new install on a seperate box (my dev machine).
I downloaded the OpenTaps version 424208 as you recommended.  Here is
the configuration:

Win XP
Java SDK 1.4.2_04
MySQL 5.0.22
MySQL JDBC driver 3.1.13

I'm wondering if the problem is with the JDBC driver.  What version
are you using?

I'm going to try again with a different version verion of the driver.

Any other thoughts?

Thanks,

John

Here is the full exception from the logfile:
---- exception report----------------------------------------------------------
Failure in create operation for entity [UomConversion]:
org.ofbiz.entity.GenericEntityException: Exception while inserting the
following entity:
[GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)]
(while inserting:
[GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
UOM_CONVERSION (UOM_ID, UOM_ID_TO, CONVERSION_FACTOR,
CUSTOM_METHOD_ID, DECIMAL_SCALE, ROUNDING_MODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data truncated for column
'CONVERSION_FACTOR' at row 1))). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity:
[GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)]
(while inserting:
[GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
UOM_CONVERSION (UOM_ID, UOM_ID_TO, CONVERSION_FACTOR,
CUSTOM_METHOD_ID, DECIMAL_SCALE, ROUNDING_MODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data truncated for column
'CONVERSION_FACTOR' at row 1)))
---- stack trace---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the
following entity:
[GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)]
(while inserting:
[GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
UOM_CONVERSION (UOM_ID, UOM_ID_TO, CONVERSION_FACTOR,
CUSTOM_METHOD_ID, DECIMAL_SCALE, ROUNDING_MODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data truncated for column
'CONVERSION_FACTOR' at row 1)))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:130)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1109)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:266)org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:397)
javolution.xml.sax.RealtimeParser.processElement(Unknown Source)
javolution.xml.sax.RealtimeParser.parseContent(Unknown Source)
javolution.xml.sax.RealtimeParser.parse(Unknown Source)
javolution.xml.sax.RealtimeParser.parse(Unknown Source)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:245)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:225)org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:248)org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:80)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
org.ofbiz.base.start.Start.startServer(Start.java:314)
org.ofbiz.base.start.Start.start(Start.java:318)
org.ofbiz.base.start.Start.main(Start.java:404)
org.ofbiz.entity.GenericEntityException: while inserting:
[GenericEntity:UomConversion][conversionFactor,1.0E-10(java.lang.Double)][createdStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][createdTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][lastUpdatedStamp,2006-07-26
14:37:42.132(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-26
14:37:41.851(java.sql.Timestamp)][uomId,LEN_A(java.lang.String)][uomIdTo,LEN_m(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
UOM_CONVERSION (UOM_ID, UOM_ID_TO, CONVERSION_FACTOR,
CUSTOM_METHOD_ID, DECIMAL_SCALE, ROUNDING_MODE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data truncated for column
'CONVERSION_FACTOR' at row 1))
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:185)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1109)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:266)org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:397)
javolution.xml.sax.RealtimeParser.processElement(Unknown Source)
javolution.xml.sax.RealtimeParser.parseContent(Unknown Source)
javolution.xml.sax.RealtimeParser.parse(Unknown Source)
javolution.xml.sax.RealtimeParser.parse(Unknown Source)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:245)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:225)org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:248)org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:80)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
org.ofbiz.base.start.Start.startServer(Start.java:314)
org.ofbiz.base.start.Start.start(Start.java:318)
org.ofbiz.base.start.Start.main(Start.java:404)
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:INSERT INTO UOM_CONVERSION (UOM_ID, UOM_ID_TO,
CONVERSION_FACTOR, CUSTOM_METHOD_ID, DECIMAL_SCALE, ROUNDING_MODE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data
truncation: Data truncated for column 'CONVERSION_FACTOR' at row 1)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:439)org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1109)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:266)org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:397)
javolution.xml.sax.RealtimeParser.processElement(Unknown Source)
javolution.xml.sax.RealtimeParser.parseContent(Unknown Source)
javolution.xml.sax.RealtimeParser.parse(Unknown Source)
javolution.xml.sax.RealtimeParser.parse(Unknown Source)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:245)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:225)org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:248)org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:80)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
org.ofbiz.base.start.Start.startServer(Start.java:314)
org.ofbiz.base.start.Start.start(Start.java:318)
org.ofbiz.base.start.Start.main(Start.java:404)
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated
for column 'CONVERSION_FACTOR' at row 1
com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:709)com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3461)com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1198)com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677)com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:436)org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570)
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1109)
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:266)org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:397)
javolution.xml.sax.RealtimeParser.processElement(Unknown Source)
javolution.xml.sax.RealtimeParser.parseContent(Unknown Source)
javolution.xml.sax.RealtimeParser.parse(Unknown Source)
javolution.xml.sax.RealtimeParser.parse(Unknown Source)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:245)
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205)
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:225)org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:248)org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:80)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
org.ofbiz.base.start.Start.startServer(Start.java:314)
org.ofbiz.base.start.Start.start(Start.java:318)
org.ofbiz.base.start.Start.main(Start.java:404)
--------------------------------------------------------------------------------
1490663[    TransactionUtil.java:276:WARN ]

Re: Loading Seed and Demo Data into MySQL failing

Reply via email to