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&...]