1 Reply Latest reply: May 15, 2012 5:42 AM by Roger Lee RSS

Not able to configure ha-local-tx-datasource on JBoss 6.1.0

Lomesh Contractor Newbie

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>