Use Oracle instead of hypersonic for JBOSS ESB| JBoss.org Content Archive (Read Only)

1. Re: Use Oracle instead of hypersonic for JBOSS ESB

marklittle May 23, 2008 5:06 AM (in response to pushpendu)

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 May 23, 2008 9:24 AM (in response to pushpendu)

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


java:/juddiDB


true


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

marklittle May 23, 2008 9:44 AM (in response to pushpendu)

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

kconner May 28, 2008 5:35 AM (in response to pushpendu)

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

rickylis Jun 11, 2008 5:49 PM (in response to pushpendu)

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

rickylis Jun 11, 2008 6:06 PM (in response to pushpendu)

Btw, this works perfectly fine on 4.3.

7. Re: Use Oracle instead of hypersonic for JBOSS ESB

kconner Jun 12, 2008 11:48 AM (in response to pushpendu)

"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.