Installation fails on MySQL5.5

[paul]

When starting a repository for the first time on a MySQL 5.5 DB creation of the jbpm tables fail.
Stacktrace as attachment

[paul]

stacktrace

[paul.baclace@…]

I see the same problem with mysql 5.1. The 3.1.12 mysql driver was not working, so I changed it to 5.1.10 (removing old driver) and re-inited the repo. I found that I had to add the driver to the classpaths in the install/daisy-* scripts. After repo init, I had to edit the repo/conf/myconfig.xml since it ended up referencing the old driver anyway (hardwired?). After all that, starting the repo server from ${DAISY_HOME/}daisy-repository-server/bin with ./daisy-repository-server /full/path/to/repo produces an exception (summarized below). The table in question (daisyrepository.JBPM_PROCESSDEFINITION) is not defined. Adding the jdbc param useServerPrepStmts=false to the mysql URI in conf/myconfig.xml did not change the result.

org.hibernate.exception.SQLGrammarException: could not execute query

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'daisyrepository.JBPM_PROCESSDEFINITION' doesn't exist

org.outerj.daisy.runtime.DaisyRTException: Error constructing component container defined at /home/daisy/daisy-2.4.1/lib/daisy/daisy-workflow-server-impl/2.4.1/daisy-workflow-server-impl-2.4.1.jar

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'wfManager' defined in DAISY-INF/spring/applicationContext.xml in /home/daisy/daisy-2.4.1/lib/daisy/daisy-workflow-server-impl/2.4.1/daisy-workflow-server-impl-2.4.1.jar: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.outerj.daisy.workflow.serverimpl.CommonWorkflowManager]: Constructor threw exception; nested exception is org.outerj.daisy.workflow.WorkflowException: Error checking or installing workflow database schema or workflow samples.

Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.outerj.daisy.workflow.serverimpl.CommonWorkflowManager]: Constructor threw exception; nested exception is org.outerj.daisy.workflow.WorkflowException: Error checking or installing workflow database schema or workflow samples.

Caused by: org.outerj.daisy.workflow.WorkflowException: Error checking or installing workflow database schema or workflow samples.

Caused by: org.jbpm.JbpmException: couldn't find process definition 'review'

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'daisyrepository.JBPM_PROCESSDEFINITION' doesn't exist

I don't know what to try next to have daisy work with MySQL 5.1.x with InnoDB as default table type.

[anonymous]

Does anyone have a resolution for this problem yet? I have the same problem as this.

Daisy version = 2.4.2
MYSQL version = 5.5.17

[karel]

Could be related to case sensitivity in mysql.
​http://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html

[karel]

In [5926]:

Use MySQL5InnoDBDialect for mysql 5.x databases.

fixes #836
fixes #858