You can create your own statements using your own DDL scripts. The ones supplied by JBoss are just "examples". Once you have it set up, you can tell JBoss not to create the tables upon start-up.
This is re: JMS. The other J2EE tables I don't know much about, but I suspect work in the same way.
I seem to getting the same problem with using Oracle with JMS. My execption is
MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
I Depend On:
Depends On Me: jboss.ejb:persistencePolicy=database,service=EJBTimerService
which seems most likely because of the table HILO.
Could somebody tell me how to work around this?
This is not entirely to do with JMS, so you should post to a different forum. Likely, you'll see a more detailed error earlier in the logs.