6 Replies Latest reply on Jun 2, 2004 11:33 AM by Adrian Brock

    how do I change the "DefaultDS" to other name, like "mySQL"

    Chong Liang Newbie

      I modified standardjbosscmp_jdbc.xml and change the data source name from DefaultDS to mySQL and did the same thing in standardjaws.xml. I got the following error after that:

      javax.ejb.EJBException: jdbc not bound

      Any ideas?

      jboss 3.2.3 and mySQL 4016

        • 1. Re: how do I change the
          Chong Liang Newbie

          Stack Trace
          javax.ejb.EJBException: jdbc not bound
          at crm.application.ejb.ServiceAgreementBean.ejbLoad(ServiceAgreementBean.java:648)
          at org.jboss.ejb.plugins.CMPPersistenceManager.invokeLoad(CMPPersistenceManager.java:501)
          at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:384)
          at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:352)
          at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:239)
          at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
          at org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:71)
          at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:163)
          at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:89)
          at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:54)
          at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
          at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
          at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
          at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
          at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
          at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
          at org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:489)
          at org.jboss.ejb.Container.invoke(Container.java:700)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:324)
          at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
          at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
          at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
          at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
          at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
          at org.jboss.proxy.ejb.EntityInterceptor.invoke(EntityInterceptor.java:97)
          at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
          at $Proxy41.getServiceAgreement(Unknown Source)
          at crm.application.ejb.ServiceAgreementServiceAgreementBusinessFacade.getAllOfServiceAgreementFindByProfileOnKey(ServiceAgreementServiceAgreementBusinessFacade.java:1031)
          at crm.application.ejb.ServiceAgreementServiceAgreementBusinessFacade.retrieveFindByProfileOnKey(ServiceAgreementServiceAgreementBusinessFacade.java:422)
          at crm.application.web.ServiceAgreementBrowseAction.retrieveFindByProfileOnKey(ServiceAgreementBrowseAction.java:303)
          at crm.application.web.ServiceAgreementBrowseAction.doRetrieve(ServiceAgreementBrowseAction.java:186)
          at crm.application.web.ServiceAgreementBrowseAction.execute(ServiceAgreementBrowseAction.java:111)
          at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
          at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
          at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
          at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:432)
          at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:356)
          at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
          at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
          at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
          at crm.application.web.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:157)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
          at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
          at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
          at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
          at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
          at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
          at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
          at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
          at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
          at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
          at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
          at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
          at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
          at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
          at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
          at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
          at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
          at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
          at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
          at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
          at java.lang.Thread.run(Thread.java:534)

          • 2. Re: how do I change the
            Adrian Brock Master

            Your question has been asked at least twice in the last two weeks.

            It is also a question about cmp (note the cunning using of cmp in the config file)
            not jca.

            Begins with "U" and ends with "se Search"

            Or since you are lazy and will probably only complain that you are thin skinned and
            can't take my sacrasm. The answer is you must the global jndi name i.e.
            java:/MySQLDS not the ENC binding.

            • 3. Re: how do I change the
              Chong Liang Newbie

              Adrian,

              I tried java:/MySQLDS but it didn't work, same jdbc not bound error. I found there was a warning when starting JBoss: [EntityContainer] No Resource Manager Found for jdbc/... What is happening?

              • 4. Re: how do I change the
                Adrian Brock Master

                Read the FAQ topic.

                • 5. Re: how do I change the
                  Chong Liang Newbie

                  Adrian,

                  I found the solution by myself, nothing in FAQ helpful for my issue. I created another *-ds.xml to use MySQLDS data source and keep the DefaultDS without any change and it works fine now. It is not possible to change "DefaultDS" to other name since it looks more like "DefaultDS" is hard coded in JBoss settings. Just letting you know: I have done a lot of research before submitting this issue here.

                  • 6. Re: how do I change the
                    Adrian Brock Master

                    If you want to change to jndi binding of MySQL to DefaultDS, there is no problem
                    as long as you are consistent and also update JMS to use the MySQL config from
                    docs/examples/jms.

                    Like I said before you are the third person in a month to ask this question (your efforts at search don't look very exhaustive to me).

                    If you managed to find the previous person's post I asked him to post the steps he took
                    on the WIKI (since he was complaining it wasn't documentated).
                    But I also predicted that he wouldn't, I must be psychic? :-)