Description of problem:

When using jBPM with a MySQL back-end on Linux the task list page returns errors. In MySQL table names on Linux are case-sensitive and the queries from the workbench when displaying the task list are case-insensitive. See stack traces below.

Version-Release number of selected component (if applicable):

jBPM 6.3.0.Final
MySQL 5.5 back-end on Ubuntu 12.04 with default configuration

How reproducible:


Steps to Reproduce:
1. Configure jBPM demo installation with a MySQL back-end according to install guide
2. Create/upload a process, start some instances
3. When accessing the task list in the workbench an error pops up:

DataSet with UUID [ jbpmHumanTasks ] error: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmHumanTasksWithUser

Server stack trace:

2015-10-01 19:21:53,508 ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (default task-70) SELECT COUNT(*) FROM (SELECT * FROM (select  t.activationtime, t.actualowner, t.createdby, t.createdon, t.deploymentid, t.description, t.duedate, t.name, t.parentid, t.priority, t.p
rocessid, t.processinstanceid, t.processsessionid, t.status, t.taskid, t.workitemid, oe.id oeid from AuditTaskImpl t, peopleassignments_potowners po, organizationalentity oe where t.id = po.task_id and po.entity_id = oe.id) AS `dbSQL`) AS `dbSQL`
2015-10-01 19:21:53,521 ERROR [org.dashbuilder.dataset.backend.exception.ExceptionManager] (default task-70) Can't get metadata on specified data set: jbpmHumanTasksWithUser: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmHum
anTasksWithUser
        at org.dashbuilder.dataset.backend.BackendDataSetManager.getDataSetMetadata(BackendDataSetManager.java:156) [dashbuilder-dataset-core-0.3.3.Final.jar:0.3.3.Final]
        at org.dashbuilder.dataset.backend.BackendDataSetManager$Proxy$_$$_WeldClientProxy.getDataSetMetadata(Unknown Source) [dashbuilder-dataset-core-0.3.3.Final.jar:0.3.3.Final]
        at org.dashbuilder.dataset.backend.DataSetLookupServicesImpl.lookupDataSetMetadata(DataSetLookupServicesImpl.java:98) [dashbuilder-services-0.3.3.Final.jar:0.3.3.Final]
        at org.dashbuilder.dataset.backend.DataSetLookupServicesImpl$Proxy$_$$_WeldClientProxy.lookupDataSetMetadata(Unknown Source) [dashbuilder-services-0.3.3.Final.jar:0.3.3.Final]
        at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source) [:1.7.0_79]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79]
        at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79]
.........
.........

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jbpm_dev.peopleassignments_potowners' doesn't exist
        at sun.reflect.GeneratedConstructorAccessor195.newInstance(Unknown Source) [:1.7.0_79]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_79]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526) [rt.jar:1.7.0_79]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [mysql-connector-java-5.1.18.jar:]


Additional info:

This is very similar to bug 1213906