7 Replies Latest reply on Jun 12, 2008 11:48 AM by Kevin Conner

    Use Oracle instead of hypersonic for JBOSS ESB

    Pushpendu Chakraborty Newbie

      I'm using oracle-persistence-service.xml for this purpose of using oracle instead of hypersonic . It is creating all the tables required but failing saying "Attribute not found for SupportsBlobOnSelecet"

        • 1. Re: Use Oracle instead of hypersonic for JBOSS ESB
          Mark Little Master

          Sorry, but you're going to have to give us a lot more than this to go on if you want help.

          • 2. Re: Use Oracle instead of hypersonic for JBOSS ESB
            Pushpendu Chakraborty Newbie


            Ok We have JBOSS ESB based application ready to go to production . Now our next big step is to remove hypersonic and use Oracle as Persinetence service .

            I followed these steps :

            Step by step
            1. Remove deploy/hsqldb-ds.xml and add the following in a file named deploy/postgres-ds.xml:
            <?xml version="1.0" encoding="UTF-8"?>

            <local-tx-datasource>
            <jndi-name>DefaultDS</jndi-name>
            <connection-url>jdbc:postgresql://host:port/database</connection-url>
            <driver-class>org.postgresql.Driver</driver-class>
            <user-name>username</user-name>
            password

            <type-mapping>PostgreSQL 7.2</type-mapping>

            <check-valid-connection-sql>select count(*) from jbm_user</check-valid-connection-sql>
            </local-tx-datasource>

            Modify the above to suite your needs, connection parameters and such. Make sure the name of the DS is the same though(DefaultDS)

            2. Replace deploy/jbossesb.sar/juddi-ds.xml with the same configuration in the previous step (change the database name if needed).
            Again make sure the keep the jndi-name(juddiDB).

            3. Replace deploy/jbossesb.esb/message-store-ds.xml with the same configuration in step one (change the database name if needed).
            Again make sure the keep the jndi-name(JBossESBDS).

            4. Replace the database name in the 'message-store-sql' element in deploy/jbossesb.esb/jbossesb-service.xml:

            <?xml version="1.0" encoding="UTF-8"?>



            java:/JBossESBDS
            select * from message

            message-store-sql/postgresql/create_database.sql

            jboss.jca:service=DataSourceBinding,name=JBossESBDS


            5. Edit deploy/jbossesb.sar/esb.uddi.xml, and verify that it has a section that looks like this:
            true

            <!-- jUDDI DataSource to use -->
            java:/juddiDB

            <!-- jUDDI database creation -->
            true

            <!-- JUDDI_ -->
            select * from ${prefix}BUSINESS_ENTITY

            juddi-sql/postgresql/create_database.sql,juddi-sql/postgresql/import.sql
            6. Replace deploy/jboss-messaging/hsqldb-persistence-service.xml with the postgres-persistence-service.xml from the version of JBM that you are running.
            This needs to match the same version and might not work it the versions mismatch. These files can be found in src/etc/server/default/deploy of a JBM distribution.

            7. Copy the database driver to the servers lib directory and fire up the server.



            After this I get this error :

            SQL statement SUPPORTS_BLOB_ON_SELECT is not specified in the SQL properties

            • 3. Re: Use Oracle instead of hypersonic for JBOSS ESB
              Mark Little Master

              Well I know that our QE guys have run the ESB with Oracle as part of the productization of the SOA Platform. So hopefully they can make some suggestions.

              If you're going into production you may want to consider the SOA Platform over the ESB.

              • 4. Re: Use Oracle instead of hypersonic for JBOSS ESB
                Kevin Conner Master

                Can you provide more information around the error message? Is there an associated stacktrace? What occurs before/after in the log file?

                • 5. Re: Use Oracle instead of hypersonic for JBOSS ESB
                  Ricky Newbie

                  Hi Kevin,

                  I am working with Pushpendu on this issue. Here is the rest of the logs. We use 1.4.0 sp3 version of oracle-persistence-service.xml.

                  Thanks,

                  Ricky


                  2008-06-11 17:45:00,872 INFO [main] org.jboss.system.ServiceConfigurator - Problem configuring service jboss.messaging:service=PersistenceManager
                  org.jboss.deployment.DeploymentException: No Attribute found with name: SupportsBlobOnSelect
                  at org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.java:318)
                  at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:460)
                  at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:171)
                  at org.jboss.system.ServiceController.install(ServiceController.java:226)
                  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:585)
                  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                  at $Proxy4.install(Unknown Source)
                  at org.jboss.deployment.SARDeployer.create(SARDeployer.java:249)
                  at org.jboss.deployment.MainDeployer.create(MainDeployer.java:969)
                  at org.jboss.deployment.MainDeployer.create(MainDeployer.java:959)
                  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:818)
                  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                  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:585)
                  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                  at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                  at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                  at $Proxy9.deploy(Unknown Source)
                  at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
                  at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
                  at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
                  at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
                  at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
                  at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
                  at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                  at java.lang.reflect.Method.invoke(Method.java:585)
                  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                  at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
                  at $Proxy0.start(Unknown Source)
                  at org.jboss.system.ServiceController.start(ServiceController.java:417)
                  at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                  at java.lang.reflect.Method.invoke(Method.java:585)
                  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                  at $Proxy4.start(Unknown Source)
                  at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
                  at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                  at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
                  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:585)
                  at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                  at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                  at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                  at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                  at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                  at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                  at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                  at $Proxy5.deploy(Unknown Source)
                  at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
                  at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
                  at org.jboss.Main.boot(Main.java:200)
                  at org.jboss.Main$1.run(Main.java:508)
                  at java.lang.Thread.run(Thread.java:595)
                  2008-06-11 17:45:06,622 INFO [main] jboss.wsf.stack.jbws.ManagedEndpointRegistry - JBoss Web Services - JBossWS
                  2008-06-11 17:45:06,747 INFO [main] jboss.wsf.stack.jbws.ManagedEndpointRegistry - jbossws-native-2.0.0.GA (build=200707051029)
                  2008-06-11 17:45:12,715 INFO [main] jboss.web.tomcat.service.TomcatDeployer - deploy, ctxPath=/, warUrl=.../deploy/jboss-web.deployer/ROOT.war/
                  2008-06-11 17:45:14,137 INFO [main] jboss.web.tomcat.service.TomcatDeployer - deploy, ctxPath=/invoker, warUrl=.../deploy/http-invoker.sar/invoker.war/
                  2008-06-11 17:45:15,294 INFO [main] jboss.web.tomcat.service.TomcatDeployer - deploy, ctxPath=/jbossws, warUrl=.../deploy/jbossws.sar/jbossws-context.war/
                  2008-06-11 17:45:16,247 INFO [main] jboss.web.tomcat.service.TomcatDeployer - deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/
                  2008-06-11 17:45:17,090 INFO [main] org.jboss.mail.MailService - Mail Service bound to java:/Mail
                  2008-06-11 17:45:17,387 INFO [main] org.jboss.resource.deployment.RARDeployment - Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
                  2008-06-11 17:45:17,434 INFO [main] org.jboss.resource.deployment.RARDeployment - Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
                  2008-06-11 17:45:17,481 INFO [main] org.jboss.resource.deployment.RARDeployment - Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
                  2008-06-11 17:45:17,512 INFO [main] org.jboss.resource.connectionmanager.ConnectionFactoryBindingService - Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=juddiDB' to JNDI name 'java:juddiDB'
                  2008-06-11 17:45:17,528 INFO [main] internal.soa.esb.dependencies.JuddiRMIService - starting juddi RMI service
                  2008-06-11 17:45:17,715 INFO [main] org.jboss.resource.deployment.RARDeployment - Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
                  2008-06-11 17:45:17,778 INFO [main] org.jboss.resource.deployment.RARDeployment - Required license terms exist, view META-INF/ra.xml in .../deploy/jms-ra.rar
                  2008-06-11 17:45:17,809 INFO [main] org.jboss.resource.deployment.RARDeployment - Required license terms exist, view META-INF/ra.xml in .../deploy/quartz-ra.rar
                  2008-06-11 17:45:17,840 INFO [main] resource.adapter.quartz.inflow.QuartzResourceAdapter - start quartz!!!
                  2008-06-11 17:45:18,262 INFO [main] org.jboss.resource.connectionmanager.ConnectionFactoryBindingService - Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
                  2008-06-11 17:45:18,981 INFO [main] org.jboss.resource.connectionmanager.ConnectionFactoryBindingService - Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=ManagementDS' to JNDI name 'java:ManagementDS'
                  2008-06-11 17:45:19,090 INFO [main] org.jboss.resource.connectionmanager.ConnectionFactoryBindingService - Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
                  2008-06-11 17:45:20,450 INFO [main] jboss.web.tomcat.service.TomcatDeployer - deploy, ctxPath=/contract, warUrl=.../tmp/deploy/tmp61478contract-exp.war/
                  2008-06-11 17:45:21,825 INFO [main] jboss.web.tomcat.service.TomcatDeployer - deploy, ctxPath=/jboss-profiler, warUrl=.../tmp/deploy/tmp61479jboss-profiler-exp.war/
                  2008-06-11 17:45:22,372 INFO [main] org.jboss.logging.util.LoggerStream - register('-//Apache Software Foundation//DTD Struts Configuration 1.0//EN', 'jar:file:/C:/jboss/server/tibco/tmp/deploy/tmp61479jboss-profiler-exp.war/WEB-INF/lib/struts.jar!/org/apache/struts/resources/struts-config_1_0.dtd'
                  2008-06-11 17:45:22,372 INFO [main] org.jboss.logging.util.LoggerStream - register('-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN', 'jar:file:/C:/jboss/server/tibco/tmp/deploy/tmp61479jboss-profiler-exp.war/WEB-INF/lib/struts.jar!/org/apache/struts/resources/web-app_2_2.dtd'
                  2008-06-11 17:45:22,372 INFO [main] org.jboss.logging.util.LoggerStream - register('-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN', 'jar:file:/C:/jboss/server/tibco/tmp/deploy/tmp61479jboss-profiler-exp.war/WEB-INF/lib/struts.jar!/org/apache/struts/resources/web-app_2_3.dtd'
                  2008-06-11 17:45:22,387 INFO [main] org.jboss.logging.util.LoggerStream - resolveEntity('-//Apache Software Foundation//DTD Struts Configuration 1.0//EN', 'http://jakarta.apache.org/struts/dtds/struts-config_1_0.dtd')
                  2008-06-11 17:45:22,387 INFO [main] org.jboss.logging.util.LoggerStream - Resolving to alternate DTD 'jar:file:/C:/jboss/server/tibco/tmp/deploy/tmp61479jboss-profiler-exp.war/WEB-INF/lib/struts.jar!/org/apache/struts/resources/struts-config_1_0.dtd'
                  2008-06-11 17:45:22,403 INFO [main] org.jboss.logging.util.LoggerStream - New org.apache.struts.action.ActionFormBean
                  2008-06-11 17:45:22,403 INFO [main] org.jboss.logging.util.LoggerStream - Set org.apache.struts.action.ActionFormBean properties
                  2008-06-11 17:45:22,434 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addFormBean(ActionFormBean[filterForm])
                  2008-06-11 17:45:22,450 INFO [main] org.jboss.logging.util.LoggerStream - Pop org.apache.struts.action.ActionFormBean
                  2008-06-11 17:45:22,450 INFO [main] org.jboss.logging.util.LoggerStream - New org.apache.struts.action.ActionForward
                  2008-06-11 17:45:22,465 INFO [main] org.jboss.logging.util.LoggerStream - Set org.apache.struts.action.ActionForward properties
                  2008-06-11 17:45:22,465 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addForward(ActionForward[erro])
                  2008-06-11 17:45:22,481 INFO [main] org.jboss.logging.util.LoggerStream - Pop org.apache.struts.action.ActionForward
                  2008-06-11 17:45:22,497 INFO [main] org.jboss.logging.util.LoggerStream - New org.apache.struts.action.ActionForward
                  2008-06-11 17:45:22,512 INFO [main] org.jboss.logging.util.LoggerStream - Set org.apache.struts.action.ActionForward properties
                  2008-06-11 17:45:22,544 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addForward(ActionForward[home])
                  2008-06-11 17:45:22,544 INFO [main] org.jboss.logging.util.LoggerStream - Pop org.apache.struts.action.ActionForward
                  2008-06-11 17:45:22,544 INFO [main] org.jboss.logging.util.LoggerStream - New org.apache.struts.action.ActionMapping
                  2008-06-11 17:45:22,544 INFO [main] org.jboss.logging.util.LoggerStream - Set org.apache.struts.action.ActionMapping properties
                  2008-06-11 17:45:22,575 INFO [main] org.jboss.logging.util.LoggerStream - New org.apache.struts.action.ActionForward
                  2008-06-11 17:45:22,606 INFO [main] org.jboss.logging.util.LoggerStream - Set org.apache.struts.action.ActionForward properties
                  2008-06-11 17:45:22,606 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionMapping.addForward(ActionForward[selectPID])
                  2008-06-11 17:45:22,606 INFO [main] org.jboss.logging.util.LoggerStream - Pop org.apache.struts.action.ActionForward
                  2008-06-11 17:45:22,606 INFO [main] org.jboss.logging.util.LoggerStream - New org.apache.struts.action.ActionForward
                  2008-06-11 17:45:22,606 INFO [main] org.jboss.logging.util.LoggerStream - Set org.apache.struts.action.ActionForward properties
                  2008-06-11 17:45:22,606 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionMapping.addForward(ActionForward[errorSelection])
                  2008-06-11 17:45:22,622 INFO [main] org.jboss.logging.util.LoggerStream - Pop org.apache.struts.action.ActionForward
                  2008-06-11 17:45:22,622 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addMapping(ActionMapping[path=/filter, type=org.jboss.profiler.web.actions.FilterAction])
                  2008-06-11 17:45:22,622 INFO [main] org.jboss.logging.util.LoggerStream - Pop org.apache.struts.action.ActionMapping
                  2008-06-11 17:45:22,622 INFO [main] org.jboss.logging.util.LoggerStream - register('-//Apache Software Foundation//DTD Struts Configuration 1.0//EN', 'jar:file:/C:/jboss/server/tibco/tmp/deploy/tmp61479jboss-profiler-exp.war/WEB-INF/lib/struts.jar!/org/apache/struts/resources/struts-config_1_0.dtd'
                  2008-06-11 17:45:22,622 INFO [main] org.jboss.logging.util.LoggerStream - register('-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN', 'jar:file:/C:/jboss/server/tibco/tmp/deploy/tmp61479jboss-profiler-exp.war/WEB-INF/lib/struts.jar!/org/apache/struts/resources/web-app_2_2.dtd'
                  2008-06-11 17:45:22,622 INFO [main] org.jboss.logging.util.LoggerStream - register('-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN', 'jar:file:/C:/jboss/server/tibco/tmp/deploy/tmp61479jboss-profiler-exp.war/WEB-INF/lib/struts.jar!/org/apache/struts/resources/web-app_2_3.dtd'
                  2008-06-11 17:45:22,762 INFO [main] org.jboss.logging.util.LoggerStream - resolveEntity('-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN', 'http://java.sun.com/j2ee/dtds/web-app_2_2.dtd')
                  2008-06-11 17:45:22,762 INFO [main] org.jboss.logging.util.LoggerStream - Resolving to alternate DTD 'jar:file:/C:/jboss/server/tibco/tmp/deploy/tmp61479jboss-profiler-exp.war/WEB-INF/lib/struts.jar!/org/apache/struts/resources/web-app_2_2.dtd'
                  2008-06-11 17:45:22,762 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(memoryServlet/java.lang.String,/memory/java.lang.String)
                  2008-06-11 17:45:22,778 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(chartview/java.lang.String,/chartview/java.lang.String)
                  2008-06-11 17:45:22,778 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(action/java.lang.String,/do/*/java.lang.String)
                  2008-06-11 17:45:22,778 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(download/java.lang.String,/download/*/java.lang.String)
                  2008-06-11 17:45:22,778 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(excel/java.lang.String,/excel/*/java.lang.String)
                  2008-06-11 17:45:22,778 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(graphMemoryServer/java.lang.String,/graphMemoryServer/java.lang.String)
                  2008-06-11 17:45:22,778 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(graphServer/java.lang.String,/graphServer/java.lang.String)
                  2008-06-11 17:45:22,794 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(JBPProcess/java.lang.String,/JBPProcess/java.lang.String)
                  2008-06-11 17:45:22,794 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(JBTTransaction/java.lang.String,/JBTTransaction/java.lang.String)
                  2008-06-11 17:45:22,794 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(upload/java.lang.String,/upload/*/java.lang.String)
                  2008-06-11 17:45:22,809 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(uploadFile/java.lang.String,/uploadFile/java.lang.String)
                  2008-06-11 17:45:22,809 INFO [main] org.jboss.logging.util.LoggerStream - Call org.apache.struts.action.ActionServlet.addServletMapping(xmlConsolidated/java.lang.String,/xml/*/java.lang.String)
                  2008-06-11 17:45:22,997 INFO [main] jboss.web.tomcat.service.TomcatDeployer - deploy, ctxPath=/esbconfig, warUrl=.../tmp/deploy/tmp61480jbossesb-config-editor-exp.war/
                  2008-06-11 17:45:23,262 INFO [main] jboss.web.tomcat.service.TomcatDeployer - deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
                  2008-06-11 17:45:24,606 INFO [main] soa.esb.listeners.config.JBoss4ESBDeployer - create esb service, jbossesb.esb
                  2008-06-11 17:45:25,215 INFO [main] org.jboss.resource.connectionmanager.ConnectionFactoryBindingService - Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=JBossESBDS' to JNDI name 'java:JBossESBDS'
                  2008-06-11 17:45:25,309 INFO [main] internal.soa.esb.dependencies.DatabaseInitializer - java:/JBossESBDS datasource is already initialized
                  2008-06-11 17:45:26,372 INFO [main] soa.esb.listeners.config.JBoss4ESBDeployer - create esb service, jbpm.esb
                  2008-06-11 17:45:30,887 INFO [main] org.jboss.resource.connectionmanager.ConnectionFactoryBindingService - Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=JbpmDS' to JNDI name 'java:JbpmDS'
                  2008-06-11 17:45:30,966 INFO [main] internal.soa.esb.dependencies.DatabaseInitializer - java:/JbpmDS datasource is already initialized
                  2008-06-11 17:45:31,044 INFO [main] jboss.web.tomcat.service.TomcatDeployer - deploy, ctxPath=/jbpm-console, warUrl=.../tmp/deploy/tmp61501jbpm-console-exp.war/
                  2008-06-11 17:45:41,434 INFO [main] soa.esb.listeners.config.JBoss4ESBDeployer - create esb service, jbrules.esb
                  2008-06-11 17:45:41,919 INFO [main] soa.esb.listeners.config.JBoss4ESBDeployer - create esb service, management.esb
                  2008-06-11 17:45:42,403 INFO [main] internal.soa.esb.dependencies.DatabaseInitializer - java:/ManagementDS datasource is already initialized
                  2008-06-11 17:45:42,497 INFO [main] jboss.web.tomcat.service.TomcatDeployer - deploy, ctxPath=/jbossesb, warUrl=.../tmp/deploy/tmp61513management.esb-contents/jbossesb-exp.war/
                  2008-06-11 17:45:43,012 INFO [main] soa.esb.listeners.config.JBoss4ESBDeployer - create esb service, smooks.esb
                  2008-06-11 17:45:43,919 INFO [main] soa.esb.listeners.config.JBoss4ESBDeployer - create esb service, soap.esb
                  2008-06-11 17:45:45,044 INFO [main] soa.esb.listeners.config.JBoss4ESBDeployer - create esb service, spring.esb
                  2008-06-11 17:45:45,059 ERROR [main] org.jboss.deployment.scanner.URLDeploymentScanner - Incomplete Deployment listing:

                  --- MBeans waiting for other MBeans ---
                  ObjectName: jboss.messaging.connectionfactory:service=ConnectionFactory
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=Connector,transport=bisocket
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.connectionfactory:service=ClusteredConnectionFactory
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=Connector,transport=bisocket
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=Connector,transport=bisocket
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=DLQ
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=ExpiryQueue
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Topic,name=testTopic
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Topic,name=securedTopic
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Topic,name=testDurableTopic
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=testQueue
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=A
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=B
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=C
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=D
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=ex
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=PrivateDLQ
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=PrivateExpiryQueue
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=QueueWithOwnDLQAndExpiryQueue
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Topic,name=TopicWithOwnDLQAndExpiryQueue
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=QueueWithOwnRedeliveryDelay
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Topic,name=TopicWithOwnRedeliveryDelay
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Queue,name=testDistributedQueue
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging.destination:service=Topic,name=testDistributedTopic
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice

                  ObjectName: jboss.messaging:service=ServerPeer
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=PersistenceManager
                  jboss.messaging:service=JMSUserManager
                  jboss.messaging:service=Connector,transport=bisocket
                  Depends On Me:
                  jboss.messaging.connectionfactory:service=ConnectionFactory
                  jboss.messaging.connectionfactory:service=ClusteredConnectionFactory
                  jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory
                  jboss.messaging.destination:service=Queue,name=DLQ
                  jboss.messaging.destination:service=Queue,name=ExpiryQueue
                  jboss.messaging.destination:service=Topic,name=testTopic
                  jboss.messaging.destination:service=Topic,name=securedTopic
                  jboss.messaging.destination:service=Topic,name=testDurableTopic
                  jboss.messaging.destination:service=Queue,name=testQueue
                  jboss.messaging.destination:service=Queue,name=A
                  jboss.messaging.destination:service=Queue,name=B
                  jboss.messaging.destination:service=Queue,name=C
                  jboss.messaging.destination:service=Queue,name=D
                  jboss.messaging.destination:service=Queue,name=ex
                  jboss.messaging.destination:service=Queue,name=PrivateDLQ
                  jboss.messaging.destination:service=Queue,name=PrivateExpiryQueue
                  jboss.messaging.destination:service=Queue,name=QueueWithOwnDLQAndExpiryQueue
                  jboss.messaging.destination:service=Topic,name=TopicWithOwnDLQAndExpiryQueue
                  jboss.messaging.destination:service=Queue,name=QueueWithOwnRedeliveryDelay
                  jboss.messaging.destination:service=Topic,name=TopicWithOwnRedeliveryDelay
                  jboss.messaging.destination:service=Queue,name=testDistributedQueue
                  jboss.messaging.destination:service=Topic,name=testDistributedTopic
                  jboss.messaging:service=PostOffice
                  jboss.messaging:service=Bootstrap
                  jboss.esb.destination:service=Queue,name=DeadMessageQueueEze
                  jboss.esb.destination:service=Queue,name=DataCollectorQueueEze
                  jboss.esb.destination:service=Queue,name=OperationsCollectorQueueEze
                  jboss.esb.destination:service=Queue,name=OperationsResultCollectorQueueEze
                  jboss.esb.console.destination:service=Queue,name=DataFilerQueue
                  jboss.esb.console.destination:service=Queue,name=OperationsFilerQueue
                  jboss.esb.console.destination:service=Queue,name=InvokerFilerQueue
                  jboss.esb.destination:service=Topic,name=org.jboss.soa.esb.transformation.UpdateEze

                  ObjectName: jboss.messaging:service=PersistenceManager
                  State: FAILED
                  Reason: org.jboss.deployment.DeploymentException: No Attribute found with name: SupportsBlobOnSelect
                  I Depend On:
                  jboss.jca:service=DataSourceBinding,name=DefaultDS
                  jboss:service=TransactionManager
                  Depends On Me:
                  jboss.messaging:service=ServerPeer

                  ObjectName: jboss.messaging:service=PostOffice
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.jca:service=DataSourceBinding,name=DefaultDS
                  jboss:service=TransactionManager
                  Depends On Me:
                  jboss.messaging.connectionfactory:service=ConnectionFactory
                  jboss.messaging.connectionfactory:service=ClusteredConnectionFactory
                  jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory
                  jboss.messaging.destination:service=Queue,name=DLQ
                  jboss.messaging.destination:service=Queue,name=ExpiryQueue
                  jboss.messaging.destination:service=Topic,name=testTopic
                  jboss.messaging.destination:service=Topic,name=securedTopic
                  jboss.messaging.destination:service=Topic,name=testDurableTopic
                  jboss.messaging.destination:service=Queue,name=testQueue
                  jboss.messaging.destination:service=Queue,name=A
                  jboss.messaging.destination:service=Queue,name=B
                  jboss.messaging.destination:service=Queue,name=C
                  jboss.messaging.destination:service=Queue,name=D
                  jboss.messaging.destination:service=Queue,name=ex
                  jboss.messaging.destination:service=Queue,name=PrivateDLQ
                  jboss.messaging.destination:service=Queue,name=PrivateExpiryQueue
                  jboss.messaging.destination:service=Queue,name=QueueWithOwnDLQAndExpiryQueue
                  jboss.messaging.destination:service=Topic,name=TopicWithOwnDLQAndExpiryQueue
                  jboss.messaging.destination:service=Queue,name=QueueWithOwnRedeliveryDelay
                  jboss.messaging.destination:service=Topic,name=TopicWithOwnRedeliveryDelay
                  jboss.messaging.destination:service=Queue,name=testDistributedQueue
                  jboss.messaging.destination:service=Topic,name=testDistributedTopic
                  jboss.esb.console.destination:service=Queue,name=DataFilerQueue
                  jboss.esb.console.destination:service=Queue,name=OperationsFilerQueue
                  jboss.esb.console.destination:service=Queue,name=InvokerFilerQueue

                  ObjectName: jboss.messaging:service=Bootstrap
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer

                  ObjectName: jboss.esb.destination:service=Queue,name=DeadMessageQueueEze
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  Depends On Me:
                  jboss.esb:deployment=jbossesb.esb

                  ObjectName: jboss.esb.destination:service=Queue,name=DataCollectorQueueEze
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer

                  ObjectName: jboss.esb.destination:service=Queue,name=OperationsCollectorQueueEze
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer

                  ObjectName: jboss.esb.destination:service=Queue,name=OperationsResultCollectorQueueEze
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer

                  ObjectName: jboss.esb:deployment=jbossesb.esb
                  State: NOTYETINSTALLED
                  I Depend On:
                  jboss.esb.destination:service=Queue,name=DeadMessageQueueEze
                  jboss.esb:service=MessageStoreDatabaseInitializer
                  jboss.jca:service=DataSourceBinding,name=JBossESBDS
                  Depends On Me:
                  jboss.esb:deployment=jbpm.esb
                  jboss.esb:deployment=jbrules.esb
                  jboss.esb:deployment=management.esb
                  jboss.esb:deployment=smooks.esb
                  jboss.esb:deployment=soap.esb
                  jboss.esb:deployment=spring.esb

                  ObjectName: jboss.esb:deployment=jbpm.esb
                  State: NOTYETINSTALLED
                  I Depend On:
                  jboss.esb:deployment=jbossesb.esb

                  ObjectName: jboss.esb:deployment=jbrules.esb
                  State: NOTYETINSTALLED
                  I Depend On:
                  jboss.esb:deployment=jbossesb.esb

                  ObjectName: jboss.esb.console.destination:service=Queue,name=DataFilerQueue
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice
                  Depends On Me:
                  jboss.esb:deployment=management.esb

                  ObjectName: jboss.esb.console.destination:service=Queue,name=OperationsFilerQueue
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice
                  Depends On Me:
                  jboss.esb:deployment=management.esb

                  ObjectName: jboss.esb.console.destination:service=Queue,name=InvokerFilerQueue
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  jboss.messaging:service=PostOffice
                  Depends On Me:
                  jboss.esb:deployment=management.esb

                  ObjectName: jboss.esb:deployment=management.esb
                  State: NOTYETINSTALLED
                  I Depend On:
                  jboss.esb.console.destination:service=Queue,name=InvokerFilerQueue
                  jboss.esb:deployment=jbossesb.esb
                  jboss.esb.console.destination:service=Queue,name=OperationsFilerQueue
                  jboss.esb.console.destination:service=Queue,name=DataFilerQueue
                  jboss.jca:service=DataSourceBinding,name=ManagementDS
                  jboss.jca:service=DataSourceBinding,name=juddiDB

                  ObjectName: jboss.esb.destination:service=Topic,name=org.jboss.soa.esb.transformation.UpdateEze
                  State: CONFIGURED
                  I Depend On:
                  jboss.messaging:service=ServerPeer
                  Depends On Me:
                  jboss.esb:service=SmooksService
                  jboss.esb:deployment=smooks.esb

                  ObjectName: jboss.esb:service=SmooksService
                  State: CONFIGURED
                  I Depend On:
                  jboss.esb.destination:service=Topic,name=org.jboss.soa.esb.transformation.UpdateEze

                  ObjectName: jboss.esb:deployment=smooks.esb
                  State: NOTYETINSTALLED
                  I Depend On:
                  jboss.esb.destination:service=Topic,name=org.jboss.soa.esb.transformation.UpdateEze
                  jboss.esb:deployment=jbossesb.esb

                  ObjectName: jboss.esb:deployment=soap.esb
                  State: NOTYETINSTALLED
                  I Depend On:
                  jboss.esb:deployment=jbossesb.esb

                  ObjectName: jboss.esb:deployment=spring.esb
                  State: NOTYETINSTALLED
                  I Depend On:
                  jboss.esb:deployment=jbossesb.esb

                  --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
                  ObjectName: jboss.messaging:service=PersistenceManager
                  State: FAILED
                  Reason: org.jboss.deployment.DeploymentException: No Attribute found with name: SupportsBlobOnSelect
                  I Depend On:
                  jboss.jca:service=DataSourceBinding,name=DefaultDS
                  jboss:service=TransactionManager
                  Depends On Me:
                  jboss.messaging:service=ServerPeer


                  2008-06-11 17:45:45,825 INFO [main] org.jboss.system.server.ServerImpl - JBoss (MX MicroKernel) [4.2.1.GA (build: SVNTag=JBoss_4_2_1_GA date=200707131605)] Started in 1m:5s:172ms
                  2008-06-11 17:45:54,716 ERROR [DefaultQuartzScheduler_Worker-0] soa.esb.monitoring.server.DataFilerJob -
                  org.jboss.soa.esb.services.registry.ServiceNotFoundException: Could not find service with category=JBossESB-Internal and serviceName=DataCollectorService
                  at org.jboss.internal.soa.esb.services.registry.JAXRRegistryImpl.findEPRs(JAXRRegistryImpl.java:340)
                  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:585)
                  at org.jboss.internal.soa.esb.services.registry.RegistryService$1.invoke(RegistryService.java:61)
                  at $Proxy24.findEPRs(Unknown Source)
                  at org.jboss.soa.esb.listeners.RegistryUtil.getEprs(RegistryUtil.java:216)
                  at org.jboss.soa.esb.monitoring.server.DataFilerJob.execute(DataFilerJob.java:70)
                  at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                  at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

                  • 6. Re: Use Oracle instead of hypersonic for JBOSS ESB
                    Ricky Newbie

                    Btw, this works perfectly fine on 4.3.

                    • 7. Re: Use Oracle instead of hypersonic for JBOSS ESB
                      Kevin Conner Master

                       

                      "rickylis" wrote:
                      2008-06-11 17:45:00,872 INFO [main] org.jboss.system.ServiceConfigurator - Problem configuring service jboss.messaging:service=PersistenceManager
                      org.jboss.deployment.DeploymentException: No Attribute found with name: SupportsBlobOnSelect


                      This would seem to be the issue. It looks like the version of JBoss Messaging you are using does not have the appropriate attribute on the MBean. Which version do you have installed?

                      You would have to update to a version which does support this attribute or remove the attribute from the configuration. My suggestion would be the former, i.e. update JBoss Messaging.