7 Replies Latest reply on Jul 12, 2006 8:01 AM by Steven Dodd

    Need help with setting up database with Duke's Bank

    evil-termite Newbie

      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.

        • 1. Here is some more info on my problem
          evil-termite Newbie

          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?

          • 2. Re: Need help with setting up database with Duke's Bank
            Darran Lofthouse Master

            Post 1 - Have you tried restarting JBoss?

            Post 2 - What error?

            • 3. Re: Need help with setting up database with Duke's Bank
              evil-termite Newbie

              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)

              • 4. Re: Need help with setting up database with Duke's Bank
                Daniel Perez Newbie

                Hi,

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

                Thanks.

                • 5. Re: Need help with setting up database with Duke's Bank
                  Mette Hedin Newbie

                  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!!!

                  • 6. Re: Need help with setting up database with Duke's Bank
                    Mette Hedin Newbie

                    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>


                    • 7. Re: Need help with setting up database with Duke's Bank
                      Steven Dodd Newbie

                      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