HibernateService with multiple datasources

[Syed Muhammad Ali Naqvi]

Hello to All. I am using multiple datasources in my jboss-service.xml file. When I do the lookup for specific datasource (e.g java:/pcountsDS) it looks it up but overwrite it with the later one. So when my HQL is executed I get the results from second(last) datasource. It always loads the last datasource connection on the file for instance in my case it always loads java:/pcountsDS no matter what datasource I looked for.

Thanks
Syed Muhammad Ali Naqvi

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE server PUBLIC "-//JBoss//DTD MBean Service 4.0//EN" "http://www.jboss.org/j2ee/dtd/jboss-service_4_0.dtd">

<server>
  <mbean code="org.hibernate.jmx.HibernateService" name="jboss.jca:service=HibernateFactory, name=HibernateFactory2">
    <attribute name="JndiName" replace="true" trim="true" serialDataType="text">java:/hibernate/SessionFactory</attribute>
    <attribute name="Datasource" replace="true" trim="true" serialDataType="text">java:/pcountsDS2</attribute>
    <attribute name="Datasource" replace="true" trim="true" serialDataType="text">java:/pcountsDS</attribute>
    <attribute name="Dialect" replace="true" trim="true" serialDataType="text">org.hibernate.dialect.MySQLInnoDBDialect</attribute>
    <attribute name="TransactionStrategy" replace="true" trim="true" serialDataType="text">org.hibernate.transaction.JTATransactionFactory</attribute>
    <attribute name="TransactionManagerLookupStrategy" replace="true" trim="true" serialDataType="text">org.hibernate.transaction.JBossTransactionManagerLookup</attribute>
    <attribute name="ShowSqlEnabled" replace="true" trim="true" serialDataType="text">false</attribute>

    <!--     Second-level caching
    <attribute name="SecondLevelCacheEnabled">true</attribute>
    <attribute name="CacheProviderClass">org.hibernate.cache.EhCacheProvider</attribute>
    <attribute name="QueryCacheEnabled">true</attribute>-->

    <attribute name="MapResources" replace="true" trim="true" serialDataType="text">
    com/samp/hibernate/pojo/Emp.hbm.xml,
    com/samp/hibernate/pojo/Dept.hbm.xml
    </attribute>
    <depends>jboss.jca:service=RARDeployer</depends>
    <depends>jboss.jca:service=XATxCM,name=pcountsDS2</depends>
    <depends>jboss.jca:service=XATxCM,name=pcountsDS</depends>
    <depends>jboss:service=TransactionManager</depends>
    <!-- Make it deploy ONLY after DataSource had been started -->
  </mbean>
</server>

[Jaikiran Pai]

<attribute name="Datasource" replace="true" trim="true" serialDataType="text">java:/pcountsDS2</attribute>  
<attribute name="Datasource" replace="true" trim="true" serialDataType="text">java:/pcountsDS</attribute>  

Setting that attribute twice is just going to the value that was last set, since it's just one single property after all. What exactly are you trying to do?