Need help with setting up database with Duke's Bank

[evil-termite]

I have been working through the Duke's Bank Application chapter of the JBoss 4.0 start guide. I ran into trouble in chapter 4.1.7 when I tried to set up the database. I modified the file hsqldb-ds.xml as it told me to and when I saved it the server gave me this error:


09:36:38,265 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
MBeans waiting for other MBeans:
ObjectName: jboss.ejb:persistencePolicy=database,service=EJBTimerService
state: DESTROYED
I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

Depends On Me:
ObjectName: jboss:service=Ebxmlrr
state: DESTROYED
I Depend On: jboss.web:service=WebServer
jboss.jca:name=DefaultDS,service=DataSourceBinding

Depends On Me:
ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
state: DESTROYED
I Depend On: jboss:service=TransactionManager
jboss.jca:name=DefaultDS,service=DataSourceBinding

Depends On Me:
ObjectName: jboss.mq:service=StateManager
state: DESTROYED
I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

Depends On Me: jboss.mq:service=DestinationManager

ObjectName: jboss.mq:service=DestinationManager
state: DESTROYED
I Depend On: jboss.mq:service=MessageCache
jboss.mq:service=PersistenceManager
jboss.mq:service=StateManager

Depends On Me: jboss.mq.destination:name=testTopic,service=Topic
jboss.mq.destination:name=securedTopic,service=Topic
jboss.mq.destination:name=testDurableTopic,service=Topic
jboss.mq.destination:name=testQueue,service=Queue
jboss.mq.destination:name=A,service=Queue
jboss.mq.destination:name=B,service=Queue
jboss.mq.destination:name=C,service=Queue
jboss.mq.destination:name=D,service=Queue
jboss.mq.destination:name=ex,service=Queue
jboss.mq:service=SecurityManager
jboss.mq.destination:name=DLQ,service=Queue

ObjectName: jboss.mq:service=PersistenceManager
state: DESTROYED
I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

Depends On Me: jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:name=testTopic,service=Topic
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me:
ObjectName: jboss.mq.destination:name=securedTopic,service=Topic
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me:
ObjectName: jboss.mq.destination:name=testDurableTopic,service=Topic
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me:
ObjectName: jboss.mq.destination:name=testQueue,service=Queue
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me:
ObjectName: jboss.mq.destination:name=A,service=Queue
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me:
ObjectName: jboss.mq.destination:name=B,service=Queue
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me:
ObjectName: jboss.mq.destination:name=C,service=Queue
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me:
ObjectName: jboss.mq.destination:name=D,service=Queue
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me:
ObjectName: jboss.mq.destination:name=ex,service=Queue
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me:
ObjectName: jboss.mq:service=Invoker
state: DESTROYED
I Depend On: jboss.mq:service=TracingInterceptor

Depends On Me: jboss.mq:service=InvocationLayer,type=JVM
jboss.mq:service=InvocationLayer,type=UIL2

ObjectName: jboss.mq:service=TracingInterceptor
state: DESTROYED
I Depend On: jboss.mq:service=SecurityManager

Depends On Me: jboss.mq:service=Invoker

ObjectName: jboss.mq:service=SecurityManager
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me: jboss.mq.destination:name=testTopic,service=Topic
jboss.mq.destination:name=securedTopic,service=Topic
jboss.mq.destination:name=testDurableTopic,service=Topic
jboss.mq.destination:name=testQueue,service=Queue
jboss.mq:service=TracingInterceptor
jboss.mq.destination:name=DLQ,service=Queue

ObjectName: jboss.mq.destination:name=DLQ,service=Queue
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me:
ObjectName: jboss.mq:service=InvocationLayer,type=JVM
state: DESTROYED
I Depend On: jboss.mq:service=Invoker

Depends On Me:
ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
state: DESTROYED
I Depend On: jboss.mq:service=Invoker

Depends On Me:
ObjectName: jboss.jca:name=DefaultDS,service=LocalTxCM
state: CONFIGURED
I Depend On: jboss.jca:name=DefaultDS,service=ManagedConnectionPool
jboss.jca:service=CachedConnectionManager
jboss.security:service=JaasSecurityManager
jboss:service=TransactionManager

Depends On Me: jboss.jca:name=DefaultDS,service=DataSourceBinding

ObjectName: jboss.jca:name=DefaultDS,service=ManagedConnectionPool
state: CONFIGURED
I Depend On: jboss.jca:name=DefaultDS,service=ManagedConnectionFactory

Depends On Me: jboss.jca:name=DefaultDS,service=LocalTxCM

ObjectName: jboss.jca:name=DefaultDS,service=ManagedConnectionFactory
state: CONFIGURED
I Depend On: jboss:database=localDB,service=Hypersonic
jboss.jca:name='jboss-local-jdbc.rar',service=RARDeployment

Depends On Me: jboss.jca:name=DefaultDS,service=ManagedConnectionPool

ObjectName: jboss.jca:name=DefaultDS,service=DataSourceBinding
state: CONFIGURED
I Depend On: jboss.jca:name=DefaultDS,service=LocalTxCM
jboss:service=invoker,type=jrmp

Depends On Me: jboss.ejb:persistencePolicy=database,service=EJBTimerService
jboss:service=Ebxmlrr
jboss:service=KeyGeneratorFactory,type=HiLo
jboss.mq:service=StateManager
jboss.mq:service=PersistenceManager


MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss:database=localDB,service=Hypersonic
state: NOTYETINSTALLED
I Depend On:
Depends On Me: jboss.jca:name=DefaultDS,service=ManagedConnectionFactory



I am really not sure what to do at this point. Any help would be nice. Thanks.

[evil-termite]

I continued on with the tutorial even though I had the previous error. When I go to the jmx console I get the service=hypersonic link. I went to that and invoked startDatabaseManager() and that part worked. It had the duke's bank tables there with and would let me query.

However, when I start up the Duke's Bank web app and log in as user 200 and try to view accounts, the JBoss console gives me errors that say it was unable to connect to the database. I'm not sure if it has to do with the error from my first post or not. Any Ideas?

[darranl]

Post 1 - Have you tried restarting JBoss?

Post 2 - What error?

[evil-termite]

post 1: I did try restarting JBoss many times. That same Error message comes up. After the error, Jboss completes its startup routein.

post 2: Here is what comes up in the server console when I put in the userID and password for Dukes Bank.

13:16:05,374 INFO [STDOUT] Debug: Creating bean manager.
13:16:05,514 INFO [STDOUT] Debug: CustomerControllerBean ejbCreate
13:16:05,561 INFO [STDOUT] Debug: AccountControllerBean ejbCreate
13:16:05,592 INFO [STDOUT] Debug: TxControllerBean ejbCreate
13:16:05,608 INFO [STDOUT] Debug: /main
13:16:05,608 INFO [STDOUT] Debug: Forwarding to template.
13:16:05,873 INFO [STDOUT] Debug: AccountControllerBean getAccountsOfCustomer
13:16:05,905 INFO [STDOUT] Debug: AccountBean setEntityContext
13:16:05,920 INFO [STDOUT] Debug: AccountBean ejbFindByCustomerId
13:16:05,920 INFO [STDOUT] Debug: AccountBean selectByCustomerId
13:16:05,920 INFO [STDOUT] Debug: AccountBean makeConnection
13:16:05,920 ERROR [LogInterceptor] EJBException in method: public abstract java
.util.Collection com.sun.ebank.ejb.account.AccountHome.findByCustomerId(java.lan
g.String) throws javax.ejb.FinderException:
javax.ejb.EJBException: ejbFindByCustomerId Unable to connect to database. Could
not dereference object
at com.sun.ebank.ejb.account.AccountBean.ejbFindByCustomerId(AccountBean
.java:181)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersi
stenceManager.java:615)
at org.jboss.ejb.plugins.BMPPersistenceManager.findEntities(BMPPersisten
ceManager.java:320)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.find
Entities(CachedConnectionInterceptor.java:321)
at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:649)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityC
ontainer.java:1113)
at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(Ent
itySynchronizationInterceptor.java:192)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo
keHome(CachedConnectionInterceptor.java:212)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractIntercep
tor.java:90)
at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInst
anceInterceptor.java:113)
at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInte
rceptor.java:61)
at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCrea
tionInterceptor.java:28)
at org.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(CallValida
tionInterceptor.java:41)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInte
rceptor.java:109)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep
torCMT.java:283)
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.ja
va:129)
at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityIntercep
tor.java:106)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:1
20)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyF
actoryFinderInterceptor.java:93)
at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java
:508)
at org.jboss.ejb.Container.invoke(Container.java:876)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLoca
lProxyFactory.java:342)
at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java
:118)
at $Proxy71.findByCustomerId(Unknown Source)
at com.sun.ebank.ejb.account.AccountControllerBean.getAccountsOfCustomer
(AccountControllerBean.java:260)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(St
atefulSessionContainer.java:521)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.
java:128)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo
ke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidation
Interceptor.java:48)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInte
rceptor.java:105)
at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxI
nterceptorBMT.java:153)
at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:6
2)
at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(State
fulSessionInstanceInterceptor.java:294)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFacto
ryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:6
24)
at org.jboss.ejb.Container.invoke(Container.java:854)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
er.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
java:242)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(Loca
lInvoker.java:155)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)

at org.jboss.invocation.MarshallingInvokerInterceptor.invoke(Marshalling
InvokerInterceptor.java:55)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.
java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:5
5)
at org.jboss.proxy.ejb.StatefulSessionInterceptor.invoke(StatefulSession
Interceptor.java:106)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
at $Proxy72.getAccountsOfCustomer(Unknown Source)
at com.sun.ebank.web.CustomerBean.getAccounts(CustomerBean.java:107)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.commons.el.ArraySuffix.evaluate(ArraySuffix.java:314)
at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)
at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEval
uatorImpl.java:263)
at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEval
uatorImpl.java:190)
at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageCon
textImpl.java:899)
at org.apache.jsp.template.links_jsp._jspx_meth_c_set_0(links_jsp.java:1
61)
at org.apache.jsp.template.links_jsp._jspService(links_jsp.java:84)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
92)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:704)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:590)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:510)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary
.java:966)
at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.jav
a:581)
at com.sun.ebank.web.template.InsertTag.doTag(InsertTag.java:83)
at org.apache.jsp.template.template_jsp._jspx_meth_tt_insert_2(template_
jsp.java:897)
at org.apache.jsp.template.template_jsp._jspService(template_jsp.java:87
)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
92)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:704)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
tionDispatcher.java:474)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:409)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:312)
at com.sun.ebank.web.Dispatcher.doGet(Dispatcher.java:95)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
ContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrinc
ipalValve.java:44)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:102)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:540)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:102)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:169)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16
0)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:683)
at java.lang.Thread.run(Thread.java:534)

[daniel_perez]

Hi,

I am running into the same problem. Any help would be appreciated!

Thanks.

[mette]

I too ran into the same problem. It seems the default setting in the hsql file changed, and the documentation did not keep up. There is in fact a third item you also have to change to make it work.

Change:
jboss:service=Hypersonic,database=localDB
to
jboss:service=Hypersonic

This is because the mbean element that was enabled at the end of the file uses the first name and the one you enable uses the second. It would be good if the documentation was updated!!!

[mette]

I forgot to escape the XML tags, what I mean was,

Change

<depends>jboss:service=Hypersonic,database=localDB</depends>

to

<depends>jboss:service=Hypersonic</depends>

[stevendodd]

I also encountered this problem:

The docs neglect to tell you that you also need to comment out the reference above the MBean declaration

<!-- When using in-process (standalone) mode -->
<!-- jboss:service=Hypersonic,database=localDB -->
<!-- Uncomment when using hsqldb in server mode -->
jboss:service=Hypersonic

Did that as well and it all worked fine