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

[Lomesh Contractor]

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&displayFullThread=true https://community.jboss.org/thread/73235?decorator=print&displayFullThread=true 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&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120403/c2c2a6f8/attachment-0001.html