JBoss AS 6.0.0.Final (Hypersonic) System tables

[pi4630]

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.

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?

Some thoughts:

1. 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?
2. 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?
3. Is there documentation about these tables, i.e. how their fields are defined and how they're used? (Size, n° of growth, ecc.)

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.

Thank you in advance

~ pasquale

[wdfink]

You might use DefaultDS for all. I prefere two different datasources.

If you use JBossMessaging the JMS messages might be stored in the database, HornetQ (the default) does not need a database

Also the EJB timers, juddi ... use the DefaultDS, you might remove the services if you do not need it.

http://community.jboss.org/wiki/JBoss5xTuningSlimming and  http://community.jboss.org/wiki/JBoss6xTuningSlimming

You might also remove the grant, for the first start you might get the table structure from a test DB (if the DBadmin prefere no CREATE grant )

I think there is no documentation for the tables. But if you do not use the former JBossMessaging and ejb timers the tables are not used.