Hi Leo,

I noticed the following error in your server.log:

10:34:08,826 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/jbpm-human-task-war]] (MSC service thread 1-5) Servlet /jbpm-human-task-war threw load() exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jbpm5.task' doesn't exist
There are two things I can think of that might be causing this:

1. The (human-task) schema hasn't been created. Could you check the hbm2ddl.auto setting in your persistence.xml? You'll need to either set it to "update" ("create" or "create-drop" are also possible, but "update" is the usually the most convenient) or otherwise make sure to create the schema yourself. Unfortunately, we're still working on providing DDL scripts, so creating the schema yourself is a little bit tricky at the moment.

2. What's also possible is that there's what I call a "schema-overlap" problem: sometimes Hibernate finds, for example, the "Schema1.task" table while the user/schema being used is actually "Schema2". This type of error is then thrown after the hbm2ddl code from Hibernate has checked the code and when Hibernate is actually really doing something (or updating) with the schema/tables.

Thanks,
Marco

-------- Original Message --------

Subject: Stuck with MySQL db

Date: Wed, 17 Oct 2012 10:47:24 +0200

From: Leonardo Carriero <leo.carriero@gmail.com>

To: jbpm-dev-owner@lists.jboss.org

From: Leonardo Carriero <leo.carriero@gmail.com>
To: jbpm-dev@lists.jboss.org
Cc:
Date: Wed, 17 Oct 2012 10:44:13 +0200
Subject:
Hello.
I have this problem no matters how many times I reboot or reinstall jbpm 5.3 when I try to set up MySQL db.
I've followed the instructions you provided in this guide: http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e665

I've (as I said) tried to reboot, clean and reinstall, download a clean file and started everything over again but it still freezes on this (when i run ant start.demo.db):

C:\jbpm-installer>ant start.demo.db

Buildfile: C:\jbpm-installer\build.xml

check.jboss.version:

download.db.driver.check:

[echo] Checking if db driver jar has been downloaded ...

download.mysql.driver:

[echo] Getting mysql driver jar ...

[get] Getting: https://repository.jboss.org/nexus/service/local/repositories/central/content/mysql/mysql-connector-java/5.1.18/mysql-connector-java-5.1.18.jar

[get] To: C:\jbpm-installer\db\driver\mysql-connector-java.jar

install.db.files:

[mkdir] Created dir: C:\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main

[copy] Copying 1 file to C:\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main

[copy] Copying 1 file to C:\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main

start.jboss:

check.jboss.version:

start.jboss5:

check.jboss.version:

start.jboss7:

start.human.task:

[mkdir] Created dir: C:\jbpm-installer\task-service\target

[javac] C:\jbpm-installer\build.xml:844: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds

[javac] Compiling 1 source file to C:\jbpm-installer\task-service\target

[copy] Copying 6 files to C:\jbpm-installer\task-service\target

[java] Task service registered usergroup callback ...

[java] Task service started correctly!

[java] Task service running ...

I've noticed that he created the tables in the two schemas on the db, so there must be something else.
In the log, I can't understand what errors it encounters, so I will attach it.

Thanks a lot for your time

Best regards

Leo

-- 
jBPM/Drools developer
Utrecht, the Netherlands