[jboss-user] [Datasource Configuration] - Not able to configure ha-local-tx-datasource

Lomesh Contractor [https://community.jboss.org/people/lomesh] created the discussion "Not able to configure ha-local-tx-datasource" To view the discussion, visit: https://community.jboss.org/message/728046#728046 -------------------------------------------------------------- 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&displayFullT... https://community.jboss.org/thread/73235?decorator=print&displayFullT... and http://docs.jboss.org/jbossas/6/JCA_Guide/en-US/html_single/ 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 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>+ -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/728046#728046] Start a new discussion in Datasource Configuration at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]