Hi Nicklas,
Thanks for the reply.
I have 6 peristent-units like below in my persistence.xml. So Please advise! How to change the code as you mentioned above.
---------------------------------------------------------
<persistence-unit name="pricingEE" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:jboss/jdbc/pricingDS</jta-data-source>
<exclude-unlisted-classes>true</exclude-unlisted-classes>
<class>com.agcs.pricing.entity.parameter.ParameterTable</class>
<class>com.agcs.pricing.entity.parameter.ParameterTableGroup</class>
<class>com.agcs.pricing.entity.tool.AptTool</class>
<class>com.agcs.pricing.entity.tool.AptToolAdmissionRule</class>
<class>com.agcs.pricing.entity.tool.AptEnvironment</class>
<exclude-unlisted-classes>true</exclude-unlisted-classes>
<properties>
<property name="hibernate.show_sql" value="false" />
<property name="hibernate.format_sql" value="false" />
<property name="hibernate.jdbc.batch_size" value="100"/>
<!-- These are the default for JBoss EJB3, but not for HEM: -->
<property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
<!--property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider" /-->
<property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
<property name="jboss.entity.manager.factory.jndi.name" value="java:emf/prEm" />
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />
<property name="hibernate.temp.use_jdbc_metadata_defaults" value="false" />
</properties>
</persistence-unit>
<persistence-unit name="pricingRMSEE" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:jboss/jdbc/pricingRMSDS</jta-data-source>
<class>com.agcs.pricing.rms.db.RmsLocationLevelCoverage</class>
<class>com.agcs.pricing.rms.db.RmsPolicyLevelCoverage</class>
<exclude-unlisted-classes>true</exclude-unlisted-classes>
<properties>
<property name="hibernate.show_sql" value="false" />
<property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
<property name="jboss.entity.manager.factory.jndi.name" value="java:emf/prRMSEm" />
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />
<property name="hibernate.temp.use_jdbc_metadata_defaults" value="false" />
</properties>
</persistence-unit>
---------------------------------------------------------