We are using JBoss in our organization but only for hosting servlets and JSPs (no EJBs, JMB, JTA, etc.). However, we're running into this error when starting JBoss in the production environment:
java.sql.SQLException: The database is already in use by another process:
I think that the fact that we're installing to a shared NFS mount may be the problem. I understand that JBoss strongly recommends against using the embedded Hypersonic database in production. However, I'm wondering if we need a database at all if we're only using the servlet container (Tomcat) portion of JBoss. If not, is there a way to completely disable all persistence rather than switching to a different database? Or does JBoss require a persistent data store to run basic servlet/JSP applications?
You will first have to trim down the app server configuration and remove all of the services that use Hypersonic. That would include messaging and the uuid generator. Grep for 'DefaultDS' - every config file containing that must be removed. Only then can you remove the hsqldb-ds.xml file.
Here is the slimming wiki: