Hello,
I tried to integrate Tomcat(6.0.26)+JbossTS(4_11_0_Final)+MySQL(latest)+JPA 2 over Hibernate(latest)+HornetQ(latest).
Web application is running as long as I put the datasource configuration in the below way.
<Resource name="jdbc/TestDBGlobal" auth="Container"
type="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"
factory="com.mysql.jdbc.jdbc2.optional.MysqlDataSourceFactory"
user="root"
password="root"
serverName="localhost"
databaseName="hrms"
url="jdbc:mysql://localhost:3306/hrms"/>
but I get nested transaction exception when I follow the way Jonathan Halliday described in his tomcat integration article(by a custom TransactionalResourceFactory).
It works for the example servlet but not when I tried to integrate with the frameworks I mentioned above.
My question is:
1.With respect to the above datasource configuration, are the connections pooled by the JBossTS?
If not how to attach a appropriate connection pool for the above XA datasource that will work seemlessly with JBossTS.
2.As I don't have indepth knowledge of JBossTS,Would it be possible for somebody to have a look at the transaction log and
validate if JBossTS is working as desired or there are recovery issues.
Note: This log has taken with the above datasource.
I would really appreciate help.
Thanks,
SPC