Not able to configure ha-local-tx-datasource on JBoss 6.1.0
Hi,
I am trying to configure ha-local-tx-datasource with JBoss 6.1.0 on my dev environment. But, I am facing below issues:
1. I could not find any ha*.rar files in the JBoss installation
2. I followed all the steps given at https://community.jboss.org/thread/73235?decorator=print&displayFullThread=true and http://docs.jboss.org/jbossas/6/JCA_Guide/en-US/html_single/ But no luck.
I am getting below mentioned exception on JBoss console, which says my datasource (sdp-model-datasource) is not available. I used JMX console and looked in JNDI tree for datasource, but could not find it.
Could you pls help here out?
20:19:50,508 ERROR [ProfileServiceBootstrap] Failed to load profile:: org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary
of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):
DEPLOYMENTS MISSING DEPENDENCIES:
Deployment "persistence.unit:unitName=sdp-model-ear-2.0.1.1.ear/sdp-model-entities-2.0.1.1.jar#sdp-model" is missing the following depende
ncies:
Dependency "jboss.jca:name=sdp-model-datasource,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NO
T FOUND Depends on 'jboss.jca:name=sdp-model-datasource,service=DataSourceBinding' **")
DEPLOYMENTS IN ERROR:
Deployment "jboss.jca:name=sdp-model-datasource,service=DataSourceBinding" is in error due to the following reason(s): ** NOT FOUND Depend
s on 'jboss.jca:name=sdp-model-datasource,service=DataSourceBinding' **
at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(DeployersImpl.java:1228) [:2.2.2.GA]
at org.jboss.deployers.plugins.main.MainDeployerImpl.checkComplete(MainDeployerImpl.java:905) [:2.2.2.GA]
at org.jboss.system.server.profileservice.deployers.MainDeployerPlugin.checkComplete(MainDeployerPlugin.java:87) [:6.1.0.Final]
at org.jboss.profileservice.deployment.ProfileDeployerPluginRegistry.checkAllComplete(ProfileDeployerPluginRegistry.java:107) [:0.2.
2]
at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:135) [:6.1.
0.Final]
at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:56) [:6.1.0
.Final]
at org.jboss.bootstrap.impl.base.server.AbstractServer.startBootstraps(AbstractServer.java:827) [jboss-bootstrap-impl-base.jar:2.1.0
-alpha-6]
at org.jboss.bootstrap.impl.base.server.AbstractServer$StartServerTask.run(AbstractServer.java:417) [jboss-bootstrap-impl-base.jar:2
.1.0-alpha-6]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_27]
20:19:50,629 INFO [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
20:19:50,639 INFO [org.apache.coyote.ajp.AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
20:19:50,642 INFO [org.jboss.bootstrap.impl.base.server.AbstractServer] JBossAS [6.1.0.Final "Neo"] Started in 1m:4s:875ms
My -ds.xml content:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE datasources PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
"http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">
<datasources>
<ha-local-tx-datasource>
<jndi-name>sdp-model-datasource</jndi-name>
<use-java-context>true</use-java-context>
<connection-url>jdbc:mysql://localhost:3306/db1|jdbc:mysql://172.25.53.129:3306/db1</connection-url>
<url-delimeter>|</url-delimeter>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<connection-property name="autoReconnect">true</connection-property>
<connection-property name="maxReconnects">10</connection-property>
<connection-property name="initialTimeout">10</connection-property>
<user-name>xxxx</user-name>
<password>xxxx</password>
<min-pool-size>1</min-pool-size>
<max-pool-size>30</max-pool-size>
<blocking-timeout-millis>60000</blocking-timeout-millis>
<idle-timeout-minutes>10</idle-timeout-minutes>
<prepared-statement-cache-size>100</prepared-statement-cache-size>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<check-valid-connection-sql>select count(*) from user</check-valid-connection-sql>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</ha-local-tx-datasource>
</datasources>
