It take me a long time to investigate Transaction Manager about hibernate and ejb.It's really simple if you find the right materials,just specify some parameters in hibernate.cfg.xml,here is the result:
[b]<1>[/b]specify a Datesource :
[code]
<property name="hibernate.connection.datasource">
java:MSSQLDS
</property>
[/code]
It's very important to do this.
[b]
<2>[/b]specify some other paramethers
[code]
<property name="hibernate.TransactionManagerLookup">
org.hibernate.transaction.JBossTransactionManagerLookup
</property>
<property name="hibernate.transaction.manager_lookup_class">
org.hibernate.transaction.JBossTransactionManagerLookup
</property>
<property name="hibernate.TransactionManagerLookupStrategy">
org.hibernate.transaction.JBossTransactionManagerLookup
</property>
<property name="hibernate.TransactionStrategy">
org.hibernate.transaction.CMTTransactionFactory
</property>
<property name="hibernate.transaction.factory_class">
org.hibernate.transaction.CMTTransactionFactory
</property>
<property name="hibernate.connection.release_mode">
after_statement
</property>
<property name="hibernate.transaction.auto_close_session">
true
</property>
<property name="hibernate.transaction.flush_before_completion">
true
</property>
<property name="hibernate.default_schema">dbo</property>
[/code]
[b]<1>[/b]specify a Datesource :
[code]
<property name="hibernate.connection.datasource">
java:MSSQLDS
</property>
[/code]
It's very important to do this.
[b]
<2>[/b]specify some other paramethers
[code]
<property name="hibernate.TransactionManagerLookup">
org.hibernate.transaction.JBossTransactionManagerLookup
</property>
<property name="hibernate.transaction.manager_lookup_class">
org.hibernate.transaction.JBossTransactionManagerLookup
</property>
<property name="hibernate.TransactionManagerLookupStrategy">
org.hibernate.transaction.JBossTransactionManagerLookup
</property>
<property name="hibernate.TransactionStrategy">
org.hibernate.transaction.CMTTransactionFactory
</property>
<property name="hibernate.transaction.factory_class">
org.hibernate.transaction.CMTTransactionFactory
</property>
<property name="hibernate.connection.release_mode">
after_statement
</property>
<property name="hibernate.transaction.auto_close_session">
true
</property>
<property name="hibernate.transaction.flush_before_completion">
true
</property>
<property name="hibernate.default_schema">dbo</property>
[/code]