topic Re: Bootstrap failure with java.sql.BatchUpdateException in Alfresco Archive

Bootstrap failure with java.sql.BatchUpdateException

pltim79 — Wed, 10 May 2006 22:50:55 GMT

Hello,I am attempting to get Alfresco running on a development machine with the following configuration:jdk1.5.0_06Tomcat 5.0.28,jakarta-tomcat-5.0.28alfresco-war-1.2.1My paths appear to be set correctly and Tomcat is using the following driver:mysql-connector-java-3.0.14-production-bin.jarI get the

Re: Bootstrap failure with java.sql.BatchUpdateException

pltim79 — Tue, 16 May 2006 16:40:18 GMT

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html contains the following:

As of MySQL 5.0.3, a BIT data type is available for storing bit-field values. (Before 5.0.3, MySQL interprets BIT as TINYINT(1).)

Since I'm using MySQL 5.0.18 I've changed all BIT(1) column types to INTEGER(1) and the application starts up correctly. Pasted below are the table alter scripts:

ALTER TABLE applied_patch MODIFY COLUMN was_executed INTEGER(1);
ALTER TABLE applied_patch MODIFY COLUMN succeeded INTEGER(1);
ALTER TABLE child_assoc MODIFY COLUMN isPrimary INTEGER(1);
ALTER TABLE node_perm_entry MODIFY COLUMN allowed INTEGER(1) NOT NULL;
ALTER TABLE node_permission MODIFY COLUMN inherits INTEGER(1) NOT NULL;
ALTER TABLE node_properties MODIFY COLUMN multi_valued INTEGER(1) NOT NULL;
ALTER TABLE node_properties MODIFY COLUMN boolean_value INTEGER(1);
ALTER TABLE node_status MODIFY COLUMN deleted INTEGER(1) NOT NULL;

Re: Bootstrap failure with java.sql.BatchUpdateException

derek — Wed, 17 May 2006 13:15:53 GMT

Hi,

Thank you for digging this out. We have been testing on MySQL 5.0.20 for a while now and haven't seen the issue. Could you try the later driver, perhaps?


mysql-connector-java-3.1.12-bin.jar
‍‍‍

Regards

Re: Bootstrap failure with java.sql.BatchUpdateException

pltim79 — Wed, 17 May 2006 17:07:44 GMT

Updating the driver to mysql-connector-java-3.1.12-bin.jar has fixed this issue. Alfresco now deploys and runs as expected.

Thanks for your help!