Hi, i´m working with jboss 4.0.1 and i want to kwon how can i do to have two mbean instantiated for hibernate.

I want one of this for an XAOracle connection, and the other one to have an XASqlServer connection.

I´m working with a n-tier architecture, and the transacctions are managed in EJB with JTA.

Thanks...

in your hibernate-service.xml you should make the name of your mbean unique and the "SessionFactoryName" should also be unique.

Ben

Hi... Thanks for ask...
Excuse me, i dont understand you...

this is my jboss-service.xml


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE server>
<!-- Generated file - Do not edit! -->
<server>
<mbean code="net.sf.hibernate.jmx.HibernateService" name="jboss.jca:service=Hibernate1">
<depends>jboss.jca:service=RARDeployer</depends>
<attribute name="MapResources"></attribute>
<attribute name="JndiName">java:/hibernate/HibernateFactoryXA</attribute>
<attribute name="Datasource">java:/XAOracleDS</attribute>
<attribute name="Dialect">net.sf.hibernate.dialect.OracleDialect</attribute>
<attribute name="UseOuterJoin">false</attribute>
<attribute name="ShowSql">true</attribute>
<attribute name="TransactionStrategy">net.sf.hibernate.transaction.JTATransactionFactory</attribute>
</mbean>
</server>

and this is my hibernate-service.xml


<server>
<mbean code="org.jboss.hibernate.jmx.Hibernate"
name="jboss.har:service=Hibernate1">
<attribute name="DatasourceName">java:/XAOracleDS</attribute>
<attribute name="Dialect">net.sf.hibernate.dialect.OracleDialect</attribute>
<attribute name="SessionFactoryName">java:/hibernate/XASessionFactoryCOMEX</attribute>
<attribute name="CacheProviderClass">
net.sf.hibernate.cache.HashtableCacheProvider
</attribute>
<!-- <attribute name="Hbm2ddlAuto">create-drop</attribute> -->
</mbean>
</server>


what thins must i have to add for a correct configuration???

thancks again...!!!

Are you intending that one use the generic (Hibernate-provided) MBean while the other uses the JBoss-specific MBean?

Thank you.
This is my final solution. It Works.

<server>
<mbean code="org.jboss.hibernate.jmx.Hibernate" name="jboss.har:service=Hibernate1">
<attribute name="DatasourceName">java:/XAOracleDS</attribute>
<attribute name="Dialect">net.sf.hibernate.dialect.OracleDialect</attribute>
<attribute name="SessionFactoryName">java:/hibernate/XASessionFactoryCOMEX</attribute>
<attribute name="CacheProviderClass">net.sf.hibernate.cache.HashtableCacheProvider</attribute>
</mbean>
<mbean code="org.jboss.hibernate.jmx.Hibernate" name="jboss.har:service=Hibernate2">
<attribute name="DatasourceName">java:/OracleDS</attribute>
<attribute name="Dialect">net.sf.hibernate.dialect.OracleDialect</attribute>
<attribute name="SessionFactoryName">java:/hibernate/SessionFactoryCOMEX</attribute>
<attribute name="CacheProviderClass">net.sf.hibernate.cache.HashtableCacheProvider</attribute>
</mbean>
</server>