<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Leo, <br>
<br>
I noticed the following error in your server.log: <br>
<br>
<tt>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</tt><tt><br>
</tt><br>
There are two things I can think of that might be causing this: <br>
<br>
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. <br>
<br>
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. <br>
<br>
Thanks,<br>
Marco<br>
<br>
<br>
</div>
<blockquote cite="mid:507ECFC3.9040708@redhat.com" type="cite"> <br>
-------- Original Message --------
<table class="moz-email-headers-table" border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">Subject:
</th>
<td>Stuck with MySQL db</td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">Date: </th>
<td>Wed, 17 Oct 2012 10:47:24 +0200</td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">From: </th>
<td>Leonardo Carriero <a moz-do-not-send="true"
class="moz-txt-link-rfc2396E"
href="mailto:leo.carriero@gmail.com"><leo.carriero@gmail.com></a></td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">To: </th>
<td><a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:jbpm-dev-owner@lists.jboss.org">jbpm-dev-owner@lists.jboss.org</a></td>
</tr>
</tbody>
</table>
<br>
<br>
<span
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">From: Leonardo
Carriero <<a moz-do-not-send="true"
href="mailto:leo.carriero@gmail.com">leo.carriero@gmail.com</a>></span><br
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">To: <a
moz-do-not-send="true" href="mailto:jbpm-dev@lists.jboss.org">jbpm-dev@lists.jboss.org</a></span><br
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Cc: </span><br
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Date: Wed,
17 Oct 2012 10:44:13 +0200</span><br
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Subject: </span><br
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Hello.</span><br
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">I
have this problem no matters how many times I reboot or
reinstall jbpm 5.3 when I try to set up MySQL db.</span>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">I've
followed the instructions you provided in this guide: <a
moz-do-not-send="true"
href="http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e665"
target="_blank" style="color:rgb(17,85,204)">http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e665</a></div>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">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):<br>
</div>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><br>
</div>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<div>C:\jbpm-installer>ant start.demo.db</div>
<div>Buildfile: C:\jbpm-installer\build.xml</div>
<div><br>
</div>
<div>check.jboss.version:</div>
<div><br>
</div>
<div>download.db.driver.check:</div>
<div> [echo] Checking if db driver jar has been downloaded
...</div>
<div><br>
</div>
<div>download.mysql.driver:</div>
<div> [echo] Getting mysql driver jar ...</div>
<div> [get] Getting: <a moz-do-not-send="true"
href="https://repository.jboss.org/nexus/service/local/repositories/central/content/mysql/mysql-connector-java/5.1.18/mysql-connector-java-5.1.18.jar"
target="_blank" style="color:rgb(17,85,204)">https://repository.jboss.org/nexus/service/local/repositories/central/content/mysql/mysql-connector-java/5.1.18/mysql-connector-java-5.1.18.jar</a></div>
<div> [get] To:
C:\jbpm-installer\db\driver\mysql-connector-java.jar</div>
<div><br>
</div>
<div>install.db.files:</div>
<div> [mkdir] Created dir:
C:\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main</div>
<div> [copy] Copying 1 file to
C:\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main</div>
<div> [copy] Copying 1 file to
C:\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main</div>
<div><br>
</div>
<div>start.jboss:</div>
<div><br>
</div>
<div>check.jboss.version:</div>
<div><br>
</div>
<div>start.jboss5:</div>
<div><br>
</div>
<div>check.jboss.version:</div>
<div><br>
</div>
<div>start.jboss7:</div>
<div><br>
</div>
<div>start.human.task:</div>
<div> [mkdir] Created dir:
C:\jbpm-installer\task-service\target</div>
<div> [javac] C:\jbpm-installer\build.xml:844: warning:
'includeantruntime' was not set, defaulting to
build.sysclasspath=last; set to false for repeatable builds</div>
<div><br>
</div>
<div> [javac] Compiling 1 source file to
C:\jbpm-installer\task-service\target</div>
<div> [copy] Copying 6 files to
C:\jbpm-installer\task-service\target</div>
<div> [java] Task service registered usergroup callback ...</div>
<div> [java] Task service started correctly!</div>
<div> [java] Task service running ...</div>
</div>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><br>
</div>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><br>
</div>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">I've
noticed that he created the tables in the two schemas on the db,
so there must be something else.<br>
In the log, I can't understand what errors it encounters, so I
will attach it.<br>
<br>
Thanks a lot for your time</div>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Best
regards</div>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Leo</div>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
jBPM/Drools developer
Utrecht, the Netherlands</pre>
</body>
</html>