'We need to tweak persistence.xml I belive to let Tomcat locate datasource and also persistemce.xml uses "org.hibernate.transaction.JBossTransactionManagerLookup" may be this lookup class should be changed.
Let me know if you have any fix/suggestion for this.'
Which transaction manager you are using?
For example, if you are using Bitronix, you the set the value as follows in persistence.xml :
<property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.BTMTransactionManagerLookup" />
You also need to add the following libraries in Tomcat/lib if you are using Bitronix:
e.g,
btm-tomcat55-lifecycle-1.3.3.jar
slf4j-api-1.5.2.jar
slf4j-jdk14-1.5.2.jar
btm-1.3.1.jar
geronimo-jta_1.0.1B_spec-1.0.1.jar
' I tried adding "context.xml" in META-INF with resource entry but that didn't help.'
This is not required if you define the Global datasource at the Tomcat level as all the web applications can access the JNDI.