ofbiz config errors with MySQL

[lhp001]

Starting from scratch, I'm a newbie.  I've downloaded the latest Trunk (as of 12/18/2006) from svn, build in Eclipse was fine.  
Using MySQL, changed the entityengine.xml to point to it, put the MySQL JDBC driver in \framework\entity\lib\jdbc.  I'm using the versions below on Windows XP, everything is local for now:
 
6454  (main) [       DatabaseUtil.java:765:INFO ] Database Product Name is MySQL
6454  (main) [       DatabaseUtil.java:766:INFO ] Database Product Version is 5.0.27-community-nt
6454  (main) [       DatabaseUtil.java:774:INFO ] Database Driver Name is MySQL-AB JDBC Driver
6454  (main) [       DatabaseUtil.java:775:INFO ] Database Driver Version is mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
6454  (main) [       DatabaseUtil.java:776:INFO ] Database Driver JDBC Version is 3.0
 
Maybe I have an incompatible driver?  I'm getting these errors in the log when I do a command line install in dos:
java -jar ofbiz.jar -install

error one
 DatabaseUtil.java:272:ERROR] WARNING: Column [PERMISSION_ID] of table [SECURITY_PERMISSION] of entity [SecurityPermission] is of type [mediumint] in the database, but is defined as type [VARCHAR] in the entity definition.
21820 (main) [       DatabaseUtil.java:279:WARN ] WARNING: Column [PERMISSION_ID] of table [SECURITY_PERMISSION] of entity [SecurityPermission] has a column size of [9] in the database, but is defined to have a column size of [60] in the entity definition.
21820 (main) [       DatabaseUtil.java:315:WARN ] Column [CLASSNAME] of table [SECURITY_PERMISSION] of entity [SecurityPermission] exists in the database but has no corresponding field
21820 (main) [       DatabaseUtil.java:315:WARN ] Column [NAME] of table [SECURITY_PERMISSION] of entity [SecurityPermission] exists in the database but has no corresponding field
21820 (main) [       DatabaseUtil.java:315:WARN ] Column [ACTIONS] of table [SECURITY_PERMISSION] of entity [SecurityPermission] exists in the database but has no corresponding field
21820 (main) [       DatabaseUtil.java:315:WARN ] Column [CREATION_DATE] of table [SECURITY_PERMISSION] of entity [SecurityPermission] exists in the database but has no corresponding field
21820 (main) [       DatabaseUtil.java:315:WARN ] Column [MODIFIED_DATE] of table [SECURITY_PERMISSION] of entity [SecurityPermission] exists in the database but has no corresponding field
... lots of complaints about missing entities

error 2
---- exception report ----------------------------------------------------------
Failure in create operation for entity [SecurityPermission]: org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:SecurityPermission][createdStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][createdTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][description,Permission to access the WebTools Menu.(java.lang.String)][lastUpdatedStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][lastUpdatedTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][permissionId,OFBTOOLS_VIEW(java.lang.String)] (while inserting: [GenericEntity:SecurityPermission][createdStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][createdTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][description,Permission to access the WebTools Menu.(java.lang.String)][lastUpdatedStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][lastUpdatedTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][permissionId,OFBTOOLS_VIEW(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SECURITY_PERMISSION (PERMISSION_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Field 'CLASSNAME' doesn't have a default value))). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity: [GenericEntity:SecurityPermission][createdStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][createdTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][description,Permission to access the WebTools Menu.(java.lang.String)][lastUpdatedStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][lastUpdatedTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][permissionId,OFBTOOLS_VIEW(java.lang.String)] (while inserting: [GenericEntity:SecurityPermission][createdStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][createdTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][description,Permission to access the WebTools Menu.(java.lang.String)][lastUpdatedStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][lastUpdatedTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][permissionId,OFBTOOLS_VIEW(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SECURITY_PERMISSION (PERMISSION_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Field 'CLASSNAME' doesn't have a default value)))
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:SecurityPermission][createdStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][createdTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][description,Permission to access the WebTools Menu.(java.lang.String)][lastUpdatedStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][lastUpdatedTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][permissionId,OFBTOOLS_VIEW(java.lang.String)] (while inserting: [GenericEntity:SecurityPermission][createdStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][createdTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][description,Permission to access the WebTools Menu.(java.lang.String)][lastUpdatedStamp,2006-12-18 16:07:41.706(java.sql.Timestamp)][lastUpdatedTxStamp,2006-12-18 16:07:41.593(java.sql.Timestamp)][permissionId,OFBTOOLS_VIEW(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SECURITY_PERMISSION (PERMISSION_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (Field 'CLASSNAME' doesn't have a default value)))
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.parse(EntitySaxReader.java:248)
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:89)
org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
org.ofbiz.base.start.Start.startServer(Start.java:323)
org.ofbiz.base.start.Start.start(Start.java:327)
org.ofbiz.base.start.Start.main(Start.java:413)

Things really go downhill from there, but it did create the MySQL database tables, and security_permission does have some of the data.

Please advise, I've not changed anything but the entityengine.xml.

Thanks!

[lhp001]

Figured out the problem, posting what happened for the benefit of others.  I had a previous installation of Jetspeed 2 into the same database, and it was picking up old table definitions instead of recreating them.  I deleted all tables from the database and the install was clean this time.
I just get lots of warnings: "[PROD_CATALOG_INV_FACILITY] exists in the database but has no corresponding entity".