<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
jBPM5 Demo - Trying to view Demo Human Task Server schema
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/jemmerling">jemmerling</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/646481#646481">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I modified build.xml so that it launches the H2 Web Console.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Having done that, and logging in to the H2 Console using the credentials from the persistence.xml used by the Demo Task Service, I see what appears to be an empty DB. Both before and after running the Human Task Example.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>-TABLE_CATALOG is MYDB (but that is implied by the URL used to connect).</p><p>-Only system tables are visible.</p><p>-A query against any of the application tables that should have been created by Hibernate indicates the table does not exist (e.g. TASK).</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I tried changing hibernate.show_sql to true so I can see the SQL output to the console where the server was launched. This SQL seems to suggest that these tables should exist (and when connected as "sa" should not require any prefix to query against them). I will admit I have no prior experience with H2 although substantial experience with a number of other RDBMSs.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I tried changing hibernate.connection.autocommit to true (although this is not something I would ordinarily change) without any different result.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>To log into the H2 Console I am using <a class="jive-link-external-small" href="http://localhost:8082/">http://localhost:8082/</a> and <a class="jive-link-external-small" href="http://127.0.0.1:8082">http://127.0.0.1:8082/</a> (in addition to the URL that is created automatically when H2 is started).</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Does anybody know why I can see nothing in the H2 Console or can suggest a different (free) approach e.g. an Eclipse plug-in?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks!</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>--JE</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/646481#646481">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>