Can anyone point me in the direction of some documentation (or provide the information here) about the following tables, created by JBoss 5.1.0 when it starts up?

I know what they are for at a high level, and know why they are there, but I could do with some lower-level documentation about each table's purpose.

The tables are:

hilosequences

timers

jbm_counter

jbm_dual

jbm_id_cache

jbm_msg

jbm_msg_ref

jbm_postoffice

jbm_role

jbm_tx

jbm_user

I know that the first two are associated with uuid-key-generator and the EJB Timer Service respectively, while the rest are associated with JBoss Messaging. What I want to know is something along the lines of "jmg_msg stores each message when it is created...", that kind of thing.

Thanks

Rich

ps: I originally asked this question at ServerFault but didn't get a response

1 Answer
1

hilosequences is used by the uuid-key-generator.sar which provides the jboss:service=KeyGeneratorFactory,type=HiLo service, which basically allows you to have UUID keys consistently across all aplications of an instance

timers is used by ejb2-timer-service.xml, a legacy timer service

and the jbm* tables are used by JBoss Messaging (JMS) to store messages, queues, etc, which is why it's strongly recommended to change the DB from the default (Hypersonic) to a production ready one