1 Reply Latest reply on Jan 18, 2007 12:03 PM by Mark Little

    Connection is not possible with the JTA4.2.2

    Subramaniam Venkatachalam Newbie

      I am using trying to use Arjuna Transaction and when i have finished install the transaction manager

      http://labs.jboss.com/file-access/default/members/jbosstm/downloads/4.2.1/notes/jta_install.txt

      I am always getting the error that i am not able to connect to the database.

      I am using Jboss-4.0.3-SP1 and jbossts-full-4.2.2GA.

      I am using datasource and in Spring i am using JDBCTemplate for the DAO.

      Here is the code of Datasource

      <datasources><local-tx-datasource><jndi-name>jdbc/DataSource_1</jndi-name><connection-url>jdbc:oracle:thin:@//XX.XXX.X.XXX:1521/XXXX</connection-url><driver-class>oracle.jdbc.driver.OracleDriver</driver-class><user-name>system</user-name><password>manager</password><min-pool-size>1</min-pool-size><max-pool-size>100</max-pool-size></local-tx-datasource></datasources>


      Here is the code of the DAO
      public class DAO1 extends JdbcDaoSupport {
      public DAO1(DataSource ds) {
       if (ds == null) {
      System.out.println("Datasource is null");
      }
       setDataSource(ds);
      
       }
      
      }

      Code:

      ====================================
      org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection;
      nested exception is org.jboss.util.NestedSQLException: Could not enlist in transaction on entering m
      eta-aware object!;
      - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resou
      rce, see the previous warnings.
      tx=TransactionImple < ac, BasicAction: ac70274:fa2:45af796e:622 status: 3 >); - nested throwable:

      (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware o
      bject!;
      - nested throwable: (javax.transaction.SystemException:
      java.lang.Throwable: Unabled to enlist resource, see the previous warnings.
      tx=TransactionImple < ac, BasicAction: ac70274:fa2:45af796e:622 status: 3 >))
      =====================================




      Can you please tell me why i am getting this exception.

      Thanks & Warm regards,
      Subramaniam V