9 Replies Latest reply on Oct 5, 2011 4:26 AM by wdfink

Clustering on JBoss 4.2.3

vijaykriishna Oct 3, 2011 8:15 AM

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

rhusar Oct 3, 2011 9:04 AM (in response to vijaykriishna)

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
Actions
2. Re: Clustering on JBoss 4.2.3

vijaykriishna Oct 3, 2011 9:07 AM (in response to rhusar)

Hi,

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

Thanks,
Vijay
Actions
3. Re: Clustering on JBoss 4.2.3

vijaykriishna Oct 3, 2011 9:08 AM (in response to vijaykriishna)

Can u pls post a detailed instruction on how to configure jboss as a cluster on my local machine?
Actions
4. Re: Clustering on JBoss 4.2.3

rhusar Oct 3, 2011 9:38 AM (in response to vijaykriishna)

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.
Actions
5. Re: Clustering on JBoss 4.2.3

vijaykriishna Oct 4, 2011 2:59 AM (in response to rhusar)

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
Actions
6. Re: Clustering on JBoss 4.2.3

wdfink Oct 4, 2011 11:37 AM (in response to vijaykriishna)

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.
Actions
7. Re: Clustering on JBoss 4.2.3

vijaykriishna Oct 5, 2011 2:47 AM (in response to wdfink)

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
Actions
8. Re: Clustering on JBoss 4.2.3

vijaykriishna Oct 5, 2011 3:28 AM (in response to vijaykriishna)

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)
Actions
9. Re: Clustering on JBoss 4.2.3

wdfink Oct 5, 2011 4:26 AM (in response to vijaykriishna)

No problem your welcome.
BTW you should mark your thread as 'answered' to reflect the state within the overview
Actions

Go to original post