9 Replies Latest reply on Oct 5, 2011 4:26 AM by Wolf-Dieter Fink

    Clustering on JBoss 4.2.3

    vijay krishna Newbie

      Can anyone of you pls help me in clustering on jboss 4.2.3? Need step by step instructions on how to do this ...

       

      Regards,

      Vijay

        • 1. Re: Clustering on JBoss 4.2.3
          Radoslav Husar Master

          Hi Vijay,

           

          here is a clustering guide: http://docs.jboss.org/jbossas/docs/Clustering_Guide/4/html-single/index.html

           

          Depends what you want to cluster, but first start the all profile witch has clustering in it and then make sure you application has <distributable/> tag in its web.xml. If you are using EJB3, make sure you have @Clustered annotation. For messaging, make sure the queues are clustered.

           

          HTH,

          Rado

          • 2. Re: Clustering on JBoss 4.2.3
            vijay krishna Newbie

            Hi,

             

            My application is configured for jboss clustering...now looking for the steps to configure jboss coupled with mysql db...

             

             

            Thanks,

            Vijay

            • 3. Re: Clustering on JBoss 4.2.3
              vijay krishna Newbie

              Can u pls post a detailed instruction on how to configure jboss as a cluster on my local machine?

              • 4. Re: Clustering on JBoss 4.2.3
                Radoslav Husar Master

                The defaults should do, they should be sufficient for your need. If you want to try clustering locally, copy the all profile into 2 and then start on different IP adresses. So something like

                cp -r all all1

                cp -r all all2

                ./bin/run.sh -c all1 -b localhost

                ./bin/run.sh -c all2 -b <eth0_ip_address>

                Also make sure you have UDP working fine, trun of firewall if you cant get it to work.

                • 5. Re: Clustering on JBoss 4.2.3
                  vijay krishna Newbie

                  tried the way u've said...but there was a problem configuring mysql db...Following is the exception log generated.

                   

                  Pls have a look at it and help asap...

                   

                  Regards,

                  Vijay.

                   

                  12:24:31,309 WARN  [ServiceController] Problem starting service jboss.mq:service

                  =PersistenceManager

                  org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions.  Messag

                  e recovery may not be accurate; - nested throwable: (com.mysql.jdbc.exceptions.j

                  dbc4.MySQLSyntaxErrorException: Every derived table must have its own alias)

                          at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Pers

                  istenceManager.java:489)

                          at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceMana

                  ger.java:1842)

                          at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS

                  upport.java:289)

                          at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMB

                  eanSupport.java:245)

                          at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

                          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

                  sorImpl.java:25)

                          at java.lang.reflect.Method.invoke(Method.java:597)

                          at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch

                  er.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(ServiceControl

                  ler.java:978)

                          at $Proxy0.start(Unknown Source)

                          at org.jboss.system.ServiceController.start(ServiceController.java:417)

                          at org.jboss.system.ServiceController.start(ServiceController.java:435)

                          at org.jboss.system.ServiceController.start(ServiceController.java:435)

                          at org.jboss.system.ServiceController.start(ServiceController.java:435)

                          at org.jboss.system.ServiceController.start(ServiceController.java:435)

                          at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)

                          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

                  sorImpl.java:25)

                          at java.lang.reflect.Method.invoke(Method.java:597)

                          at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch

                  er.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:304)

                          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

                  java:39)

                          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

                  sorImpl.java:25)

                          at java.lang.reflect.Method.invoke(Method.java:597)

                          at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch

                  er.java:155)

                          at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

                          at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept

                  or.java:133)

                          at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

                          at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM

                  BeanOperationInterceptor.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 $Proxy51.start(Unknown Source)

                          at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)

                          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 sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

                          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

                  sorImpl.java:25)

                          at java.lang.reflect.Method.invoke(Method.java:597)

                          at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch

                  er.java:155)

                          at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

                          at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept

                  or.java:133)

                          at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

                          at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM

                  BeanOperationInterceptor.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(URLDeploymen

                  tScanner.java:421)

                          at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentS

                  canner.java:634)

                          at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.

                  doScan(AbstractDeploymentScanner.java:263)

                          at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(A

                  bstractDeploymentScanner.java:336)

                          at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS

                  upport.java:289)

                          at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMB

                  eanSupport.java:245)

                          at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

                          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

                  sorImpl.java:25)

                          at java.lang.reflect.Method.invoke(Method.java:597)

                          at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch

                  er.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(ServiceControl

                  ler.java:978)

                          at $Proxy0.start(Unknown Source)

                          at org.jboss.system.ServiceController.start(ServiceController.java:417)

                          at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)

                          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

                  sorImpl.java:25)

                          at java.lang.reflect.Method.invoke(Method.java:597)

                          at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch

                  er.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:304)

                          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(DelegatingMethodAcces

                  sorImpl.java:25)

                          at java.lang.reflect.Method.invoke(Method.java:597)

                          at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch

                  er.java:155)

                          at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

                          at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept

                  or.java:133)

                          at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

                          at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM

                  BeanOperationInterceptor.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:662)

                  Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Every deri

                  ved table must have its own alias

                          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                   

                          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct

                  orAccessorImpl.java:39)

                          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC

                  onstructorAccessorImpl.java:27)

                          at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

                          at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

                          at com.mysql.jdbc.Util.getInstance(Util.java:386)

                          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

                          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)

                          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)

                          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

                          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

                          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)

                          at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

                  va:2119)

                          at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:

                  2281)

                          at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery

                  (WrappedPreparedStatement.java:342)

                          at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Pers

                  istenceManager.java:421)

                          ... 111 more

                  12:24:31,575 INFO  [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../dep

                  loy/jmx-console.war/

                  12:24:32,856 INFO  [EARDeployer] Init J2EE application: file:/D:/jboss-4.2.3.GA/

                  server/cluster1/deploy/Ejb2-0.0.1-SNAPSHOT.ear

                  12:24:46,169 INFO  [JmxKernelAbstraction] creating wrapper delegate for: org.jbo

                  ss.ejb3.entity.PersistenceUnitDeployment

                  12:24:46,169 INFO  [JmxKernelAbstraction] installing MBean: persistence.units:ea

                  r=Ejb2-0.0.1-SNAPSHOT.ear,jar=ejb-0.0.1-SNAPSHOT.jar,unitName=mydb with dependen

                  cies:

                  12:24:46,169 INFO  [JmxKernelAbstraction]       jboss.jca:name=DefaultDS,service

                  =DataSourceBinding

                  12:24:46,184 INFO  [PersistenceUnitDeployment] Starting persistence unit persist

                  ence.units:ear=Ejb2-0.0.1-SNAPSHOT.ear,jar=ejb-0.0.1-SNAPSHOT.jar,unitName=mydb

                  12:24:46,231 INFO  [Version] Hibernate EntityManager 3.2.1.GA

                  12:24:46,247 INFO  [Version] Hibernate Annotations 3.2.1.GA

                  12:24:46,263 INFO  [Environment] Hibernate 3.2.4.sp1

                  12:24:46,278 INFO  [Environment] hibernate.properties not found

                  12:24:46,278 INFO  [Environment] Bytecode provider name : javassist

                  12:24:46,278 INFO  [Environment] using JDK 1.4 java.sql.Timestamp handling

                  12:24:46,450 INFO  [Ejb3Configuration] found EJB3 Entity bean: com.mycompany.app

                  .my_app.domain.AppUsers

                  12:24:46,450 INFO  [Ejb3Configuration] found EJB3 Entity bean: com.mycompany.app

                  .my_app.domain.Location

                  12:24:46,481 WARN  [Ejb3Configuration] Overriding hibernate.transaction.factory_

                  class is dangerous, this might break the EJB3 specification implementation

                  12:24:46,497 INFO  [Configuration] Reading mappings from resource : META-INF/orm

                  .xml

                  12:24:46,497 INFO  [Ejb3Configuration] [PersistenceUnit: mydb] no META-INF/orm.x

                  ml found

                  12:24:46,575 INFO  [AnnotationBinder] Binding entity from annotated class: com.m

                  ycompany.app.my_app.domain.Location

                  12:24:46,653 INFO  [EntityBinder] Bind entity com.mycompany.app.my_app.domain.Lo

                  cation on table location

                  12:24:46,716 INFO  [AnnotationBinder] Binding entity from annotated class: com.m

                  ycompany.app.my_app.domain.AppUsers

                  12:24:46,731 INFO  [EntityBinder] Bind entity com.mycompany.app.my_app.domain.Ap

                  pUsers on table app_users

                  12:24:46,903 INFO  [ConnectionProviderFactory] Initializing connection provider:

                  org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider

                  12:24:46,919 INFO  [InjectedDataSourceConnectionProvider] Using provided datasou

                  rce

                  12:24:46,919 INFO  [SettingsFactory] RDBMS: MySQL, version: 5.0.51b-community-nt

                   

                  12:24:46,919 INFO  [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version:

                  mysql-connector-java-5.1.16 ( Revision: ${bzr.revision-id} )

                  12:24:46,950 INFO  [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect

                  12:24:46,966 INFO  [TransactionFactoryFactory] Transaction strategy: org.hiberna

                  te.transaction.JTATransactionFactory

                  12:24:46,966 INFO  [NamingHelper] JNDI InitialContext properties:{java.naming.fa

                  ctory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.p

                  kgs=org.jboss.naming:org.jnp.interfaces}

                  12:24:46,981 INFO  [TransactionManagerLookupFactory] instantiating TransactionMa

                  nagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup

                  12:24:46,981 INFO  [TransactionManagerLookupFactory] instantiated TransactionMan

                  agerLookup

                  12:24:46,981 INFO  [TransactionManagerLookupFactory] instantiating TransactionMa

                  nagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup

                  12:24:46,981 INFO  [TransactionManagerLookupFactory] instantiated TransactionMan

                  agerLookup

                  12:24:46,981 INFO  [SettingsFactory] Automatic flush during beforeCompletion():

                  disabled

                  12:24:46,997 INFO  [SettingsFactory] Automatic session close at end of transacti

                  on: disabled

                  12:24:46,997 INFO  [SettingsFactory] JDBC batch size: 15

                  12:24:46,997 INFO  [SettingsFactory] JDBC batch updates for versioned data: disa

                  bled

                  12:24:46,997 INFO  [SettingsFactory] Scrollable result sets: enabled

                  12:24:46,997 INFO  [SettingsFactory] JDBC3 getGeneratedKeys(): enabled

                  12:24:46,997 INFO  [SettingsFactory] Connection release mode: auto

                  12:24:47,013 INFO  [SettingsFactory] Maximum outer join fetch depth: 2

                  12:24:47,013 INFO  [SettingsFactory] Default batch fetch size: 1

                  12:24:47,013 INFO  [SettingsFactory] Generate SQL with comments: disabled

                  12:24:47,013 INFO  [SettingsFactory] Order SQL updates by primary key: disabled

                  12:24:47,013 INFO  [SettingsFactory] Order SQL inserts for batching: disabled

                  12:24:47,013 INFO  [SettingsFactory] Query translator: org.hibernate.hql.ast.AST

                  QueryTranslatorFactory

                  12:24:47,013 INFO  [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory

                  12:24:47,028 INFO  [SettingsFactory] Query language substitutions: {}

                  12:24:47,028 INFO  [SettingsFactory] JPA-QL strict compliance: enabled

                  12:24:47,028 INFO  [SettingsFactory] Second-level cache: enabled

                  12:24:47,028 INFO  [SettingsFactory] Query cache: disabled

                  12:24:47,028 INFO  [SettingsFactory] Cache provider: org.hibernate.cache.Hashtab

                  leCacheProvider

                  12:24:47,028 INFO  [SettingsFactory] Optimize cache for minimal puts: disabled

                  12:24:47,028 INFO  [SettingsFactory] Cache region prefix: Ejb2-0_0_1-SNAPSHOT_ea

                  r,ejb-0_0_1-SNAPSHOT_jar,mydb

                  12:24:47,028 INFO  [SettingsFactory] Structured second-level cache entries: disa

                  bled

                  12:24:47,044 INFO  [SettingsFactory] Echoing all SQL to stdout

                  12:24:47,044 INFO  [SettingsFactory] Statistics: disabled

                  12:24:47,044 INFO  [SettingsFactory] Deleted entity synthetic identifier rollbac

                  k: disabled

                  12:24:47,059 INFO  [SettingsFactory] Default entity-mode: pojo

                  12:24:47,059 INFO  [SettingsFactory] Named query checking : enabled

                  12:24:47,122 INFO  [SessionFactoryImpl] building session factory

                  12:24:47,419 INFO  [SessionFactoryObjectFactory] Factory name: persistence.units

                  :ear=Ejb2-0.0.1-SNAPSHOT.ear,jar=ejb-0.0.1-SNAPSHOT.jar,unitName=mydb

                  12:24:47,419 INFO  [NamingHelper] JNDI InitialContext properties:{java.naming.fa

                  ctory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.p

                  kgs=org.jboss.naming:org.jnp.interfaces}

                  12:24:47,419 INFO  [SessionFactoryObjectFactory] Bound factory to JNDI name: per

                  sistence.units:ear=Ejb2-0.0.1-SNAPSHOT.ear,jar=ejb-0.0.1-SNAPSHOT.jar,unitName=m

                  ydb

                  12:24:47,434 WARN  [SessionFactoryObjectFactory] InitialContext did not implemen

                  t EventContext

                  12:24:47,434 INFO  [NamingHelper] JNDI InitialContext properties:{java.naming.fa

                  ctory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.p

                  kgs=org.jboss.naming:org.jnp.interfaces}

                  12:24:47,653 INFO  [JmxKernelAbstraction] creating wrapper delegate for: org.jbo

                  ss.ejb3.stateless.StatelessContainer

                  12:24:47,653 INFO  [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=Ejb2-

                  0.0.1-SNAPSHOT.ear,jar=ejb-0.0.1-SNAPSHOT.jar,name=ApplicationServiceBean,servic

                  e=EJB3 with dependencies:

                  12:24:47,653 INFO  [JmxKernelAbstraction]       persistence.units:ear=Ejb2-0.0.1

                  -SNAPSHOT.ear,jar=ejb-0.0.1-SNAPSHOT.jar,unitName=mydb

                  12:24:47,716 INFO  [EJBContainer] STARTED EJB: com.mycompany.app.my_app.server.e

                  jb.ApplicationServiceBean ejbName: ApplicationServiceBean

                  12:24:47,794 INFO  [EJB3Deployer] Deployed: file:/D:/jboss-4.2.3.GA/server/clust

                  er1/tmp/deploy/tmp9035067708370854060Ejb2-0.0.1-SNAPSHOT.ear-contents/ejb-0.0.1-

                  SNAPSHOT.jar

                  12:24:48,013 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=Ejb2-0.0

                  .1-SNAPSHOT-ejb-0.0.1-SNAPSHOT,endpoint=ApplicationServiceBean

                  12:24:49,966 INFO  [WSDLFilePublisher] WSDL published to: file:/D:/jboss-4.2.3.G

                  A/server/cluster1/data/wsdl/Ejb2-0.0.1-SNAPSHOT.ear/ejb-0.0.1-SNAPSHOT.jar/Appwe

                  bservice5498835399013537251.wsdl

                  12:24:50,091 INFO  [TomcatDeployer] deploy, ctxPath=/Ejb2-0.0.1-SNAPSHOT-ejb-0.0

                  .1-SNAPSHOT, warUrl=.../tmp/deploy/Ejb2-0.0.1-SNAPSHOT.ear-ejb-0.0.1-SNAPSHOT.ja

                  r2397940989753605852.war/

                  12:24:50,513 INFO  [TomcatDeployer] deploy, ctxPath=/myapp, warUrl=.../tmp/deplo

                  y/tmp9035067708370854060Ejb2-0.0.1-SNAPSHOT.ear-contents/my-app-0.0.1-SNAPSHOT-e

                  xp.war/

                  12:24:50,794 INFO  [WebappClassLoader] validateJarFile(D:\jboss-4.2.3.GA\server\

                  cluster1\.\tmp\deploy\tmp9035067708370854060Ejb2-0.0.1-SNAPSHOT.ear-contents\my-

                  app-0.0.1-SNAPSHOT-exp.war\WEB-INF\lib\gwt-user-2.1.1.jar) - jar not loaded. See

                  Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class

                  12:24:50,810 INFO  [WebappClassLoader] validateJarFile(D:\jboss-4.2.3.GA\server\

                  cluster1\.\tmp\deploy\tmp9035067708370854060Ejb2-0.0.1-SNAPSHOT.ear-contents\my-

                  app-0.0.1-SNAPSHOT-exp.war\WEB-INF\lib\javaee-api-5.0-3.jar) - jar not loaded. S

                  ee Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class

                   

                  12:24:51,013 INFO  [JBossCacheManager] Starting JBossManager

                  12:24:51,075 INFO  [EARDeployer] Started J2EE application: file:/D:/jboss-4.2.3.

                  GA/server/cluster1/deploy/Ejb2-0.0.1-SNAPSHOT.ear

                  12:24:51,200 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

                   

                  --- Incompletely deployed packages ---

                  org.jboss.deployment.DeploymentInfo@59b4f3ba { url=file:/D:/jboss-4.2.3.GA/serve

                  r/cluster1/deploy/jms/jbossmq-destinations-service.xml }

                    deployer: org.jboss.deployment.SARDeployer@1b5998f

                    status: Deployment FAILED reason: Trying to install an already registered mbea

                  n: jboss.mq.destination:service=Topic,name=testTopic

                    state: FAILED

                    watch: file:/D:/jboss-4.2.3.GA/server/cluster1/deploy/jms/jbossmq-destinations

                  -service.xml

                    altDD: null

                    lastDeployed: 1317711267887

                    lastModified: 1317711267871

                    mbeans:

                   

                  org.jboss.deployment.DeploymentInfo@8c3f47b0 { url=file:/D:/jboss-4.2.3.GA/serve

                  r/cluster1/deploy/jms/jbossmq-service.xml }

                    deployer: org.jboss.deployment.SARDeployer@1b5998f

                    status: Deployment FAILED reason: Trying to install an already registered mbea

                  n: jboss.mq:service=Invoker

                    state: FAILED

                    watch: file:/D:/jboss-4.2.3.GA/server/cluster1/deploy/jms/jbossmq-service.xml

                    altDD: null

                    lastDeployed: 1317711268043

                    lastModified: 1317711268043

                    mbeans:

                   

                  org.jboss.deployment.DeploymentInfo@a1db380d { url=file:/D:/jboss-4.2.3.GA/serve

                  r/cluster1/deploy/jms/mysql-jdbc-state-service.xml }

                    deployer: org.jboss.deployment.SARDeployer@1b5998f

                    status: Deployment FAILED reason: Trying to install an already registered mbea

                  n: jboss.mq:service=StateManager

                    state: FAILED

                    watch: file:/D:/jboss-4.2.3.GA/server/cluster1/deploy/jms/mysql-jdbc-state-ser

                  vice.xml

                    altDD: null

                    lastDeployed: 1317711268215

                    lastModified: 1317711268215

                    mbeans:

                   

                  org.jboss.deployment.DeploymentInfo@8391ea1 { url=file:/D:/jboss-4.2.3.GA/server

                  /cluster1/deploy/jms/mysql-jdbc2-service.xml }

                    deployer: org.jboss.deployment.SARDeployer@1b5998f

                    status: Deployment FAILED reason: Trying to install an already registered mbea

                  n: jboss.mq:service=DestinationManager

                    state: FAILED

                    watch: file:/D:/jboss-4.2.3.GA/server/cluster1/deploy/jms/mysql-jdbc2-service.

                  xml

                    altDD: null

                    lastDeployed: 1317711268387

                    lastModified: 1317711268371

                    mbeans:

                   

                  --- MBeans waiting for other MBeans ---

                  ObjectName: jboss.mq:service=PersistenceManager

                    State: FAILED

                    Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transaction

                  s.  Message recovery may not be accurate; - nested throwable: (com.mysql.jdbc.ex

                  ceptions.jdbc4.MySQLSyntaxErrorException: Every derived table must have its own

                  alias)

                    I Depend On:

                      jboss.jca:service=DataSourceBinding,name=DefaultDS

                    Depends On Me:

                      jboss.mq:service=DestinationManager

                   

                  --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---

                  ObjectName: jboss.mq:service=PersistenceManager

                    State: FAILED

                    Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transaction

                  s.  Message recovery may not be accurate; - nested throwable: (com.mysql.jdbc.ex

                  ceptions.jdbc4.MySQLSyntaxErrorException: Every derived table must have its own

                  alias)

                    I Depend On:

                      jboss.jca:service=DataSourceBinding,name=DefaultDS

                    Depends On Me:

                      jboss.mq:service=DestinationManager

                   

                   

                  12:24:51,435 INFO  [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8

                  080

                  12:24:51,466 INFO  [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009

                  12:24:51,481 INFO  [Server] JBoss (MX MicroKernel) [4.2.3.GA (build: SVNTag=JBos

                  s_4_2_3_GA date=200807181417)] Started in 52s:423ms

                  • 6. Re: Clustering on JBoss 4.2.3
                    Wolf-Dieter Fink Master

                    Ok, think this will be another issue

                     

                    You change the DefaultDS from hsqldb to mysql.

                    In this case you have to remove the deploy-hasingleton/jms/hsqldb-jdbc-service.xml and use the related mysql service because here are SQL's related to the database.

                    You will find examples in docs/examples/jms.

                     

                    And don't forget all cluster members, because of HA-Singleton it might not fail during startup but in case of failover.

                    • 7. Re: Clustering on JBoss 4.2.3
                      vijay krishna Newbie

                      That has helped me upto some extent ..but there is another issue...wht else might be missing ?

                       

                      Regards,

                      Vijay

                       

                      12:11:15,741 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

                       

                      --- MBeans waiting for other MBeans ---

                      ObjectName: jboss.mq:service=InvocationLayer,type=HTTP

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=Invoker

                          jboss.web:service=WebServer

                       

                      ObjectName: jboss.mq.destination:service=Topic,name=testTopic

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=DestinationManager

                          jboss.mq:service=SecurityManager

                       

                      ObjectName: jboss.mq.destination:service=Topic,name=securedTopic

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=DestinationManager

                          jboss.mq:service=SecurityManager

                       

                      ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=DestinationManager

                          jboss.mq:service=SecurityManager

                       

                      ObjectName: jboss.mq.destination:service=Queue,name=testQueue

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=DestinationManager

                          jboss.mq:service=SecurityManager

                       

                      ObjectName: jboss.mq.destination:service=Queue,name=A

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=DestinationManager

                       

                      ObjectName: jboss.mq.destination:service=Queue,name=B

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=DestinationManager

                       

                      ObjectName: jboss.mq.destination:service=Queue,name=C

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=DestinationManager

                       

                      ObjectName: jboss.mq.destination:service=Queue,name=D

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=DestinationManager

                       

                      ObjectName: jboss.mq.destination:service=Queue,name=ex

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=DestinationManager

                       

                      ObjectName: jboss.mq:service=Invoker

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=TracingInterceptor

                          jboss:service=Naming

                        Depends On Me:

                          jboss.mq:service=InvocationLayer,type=HTTP

                          jboss.mq:service=InvocationLayer,type=JVM

                          jboss.mq:service=InvocationLayer,type=UIL2

                       

                      ObjectName: jboss.mq:service=TracingInterceptor

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=SecurityManager

                        Depends On Me:

                          jboss.mq:service=Invoker

                       

                      ObjectName: jboss.mq:service=SecurityManager

                        State: CONFIGURED

                        I Depend On:

                          jboss.security:service=JaasSecurityManager

                          jboss.mq:service=DestinationManager

                        Depends On Me:

                          jboss.mq.destination:service=Topic,name=testTopic

                          jboss.mq.destination:service=Topic,name=securedTopic

                          jboss.mq.destination:service=Topic,name=testDurableTopic

                          jboss.mq.destination:service=Queue,name=testQueue

                          jboss.mq:service=TracingInterceptor

                          jboss.mq.destination:service=Queue,name=DLQ

                       

                      ObjectName: jboss.mq.destination:service=Queue,name=DLQ

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=DestinationManager

                          jboss.mq:service=SecurityManager

                       

                      ObjectName: jboss.mq:service=InvocationLayer,type=JVM

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=Invoker

                       

                      ObjectName: jboss.mq:service=DestinationManager

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=MessageCache

                          jboss.mq:service=PersistenceManager

                          jboss.mq:service=StateManager

                        Depends On Me:

                          jboss.mq.destination:service=Topic,name=testTopic

                          jboss.mq.destination:service=Topic,name=securedTopic

                          jboss.mq.destination:service=Topic,name=testDurableTopic

                          jboss.mq.destination:service=Queue,name=testQueue

                          jboss.mq.destination:service=Queue,name=A

                          jboss.mq.destination:service=Queue,name=B

                          jboss.mq.destination:service=Queue,name=C

                          jboss.mq.destination:service=Queue,name=D

                          jboss.mq.destination:service=Queue,name=ex

                          jboss.mq:service=SecurityManager

                          jboss.mq.destination:service=Queue,name=DLQ

                       

                      ObjectName: jboss.mq:service=PersistenceManager

                        State: CONFIGURED

                        I Depend On:

                          jboss.jca:service=DataSourceBinding,name=MySqlDS

                        Depends On Me:

                          jboss.mq:service=DestinationManager

                       

                      ObjectName: jboss.mq:service=InvocationLayer,type=UIL2

                        State: CONFIGURED

                        I Depend On:

                          jboss.mq:service=Invoker

                       

                      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---

                      ObjectName: jboss.jca:service=DataSourceBinding,name=MySqlDS

                        State: NOTYETINSTALLED

                        Depends On Me:

                          jboss.mq:service=PersistenceManager

                       

                       

                      12:11:15,991 INFO  [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8

                      080

                      12:11:16,022 INFO  [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009

                      12:11:16,038 INFO  [Server] JBoss (MX MicroKernel) [4.2.3.GA (build: SVNTag=JBos

                      s_4_2_3_GA date=200807181417)] Started in 50s:157ms

                      • 8. Re: Clustering on JBoss 4.2.3
                        vijay krishna Newbie

                        Thanks to all ...it s working now after changing the default datasource in mysql-jdbc2-service.xml (the one that is located in deploy-hasingleton)

                        • 9. Re: Clustering on JBoss 4.2.3
                          Wolf-Dieter Fink Master

                          No problem your welcome.

                          BTW you should mark your thread as 'answered' to reflect the state within the overview