We are using jboss-4.0.4.GA as our application server, the default installation contains uuid-key-generator.sar in the default/deploy folder. uuid-key-generator.sar uses "DefaultDS" data source inside their its implementation.
My issues is, I changed the DefaultDS to our database which is Oracle. The reason I kept the data source name same as we are using the JBoss messaging and most of the config scripts use the DefalutDS as data source name.
But uuid-key-generator.sar internally drops and recreates the HILOSEQUENCE table whenever the JBoss server restarts. Generally we don't see this is an issue as JBoss uses hsqldb, in my case I changed hsqldb to oracle and the oracle user id I use does not have drop and recreate privileges. Because of this I do see the following error on start up:
[org.jboss.system.ServiceController.start:] Problem starting service jboss:service=KeyGeneratorFactory,type=HiLo
java.sql.SQLException: ORA-00942: table or view does not exist
There are couple of things I can think of to address this issue:
1. Remove the uuid-key-generator.sar from the deploy folder, however, I am not sure what are other implications the JBoss server will have by removing it.
2. Keep the hsqldb and configure the DefaultDS to point to hsqldb and rename my oracle data source to somethign else.
Can I safely remove uuid-key-generator.sar from JBoss deploy folder and won't have any issues?