<!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="http://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;">
JBoss AS 6.0.0.Final (Hypersonic) System tables
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/pi4630">Pasquale Imbemba</a> in <i>Beginner's Corner</i> - <a href="http://community.jboss.org/message/639518#639518">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>It's time to go into production soon for my pilot project on EJB 3. Up to now, I've been using the HsqlDB Datasource (where JBoss has its tables and relations) and my enterprise datasource, where the enterprise tables and relations are stored. That is, my JBoss starts with two ds-es.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I don't want to use Hypersonic in production, so it would be time to switch to one datasource only. How do I achieve this?</p><p>Some thoughts:</p><ol><li>Should I declare the enterprise datasource as DefaultDS, granting create table rights to the connection user and let JBoss do the job of creating the tables for me first time it starts up after the change?</li><li>If yes, after that, can I revoke the create table grants to the db connection user used by JBoss6 or will this "break" somehow the AS?</li><li>Is there documentation about these tables, i.e. how their fields are defined and how they're used? (Size, n° of growth, ecc.)</li></ol><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>My DBA badly wants info about this, but it's a topic I didn't encounter so far from a EJB programming point of view.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thank you in advance</p><p>~ pasquale</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/639518#639518">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Beginner's Corner at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>