0 Replies Latest reply on Jul 22, 2010 12:58 AM by Satyajit Prasad

    XA Datasource Pooling Related.

    Satyajit Prasad Newbie

      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