0 Replies Latest reply on Feb 13, 2003 7:46 PM by Shafei Jomohat

    Help with Local Transactions

    Shafei Jomohat Newbie

      Hi

      I've already set-up my database xml file and it's working correctly with my entity beans. If I need to get a JDBC Connection from the JBoss pool, what is the proper way to do it ? Currently i'm doing it like this but i dont know if this is the right way to go

      Context context = new InitialContext();
      ds = (DataSource) context.lookup("java:comp/env/jdbc/MyOwnDS");
      Connection con = ds.getConnection();

      And how shld i use transactions with the Connection object i've got ? Shld it be like this ?

      UserTranaction ut = null;
      InitialContext ctx = new InitialContext();
      ut = (UserTranaction) ctx.lookup("UserTranaction");
      tx.begin()

      // Normal JDBC stuff here ??
      ds = (DataSource) context.lookup("java:comp/env/jdbc/MyOwnDS");
      Connection con = ds.getConnection();
      con.prepareStatement();
      ........
      // SQL statments executed, time to commit ?


      if (ut.getStatus() == Status.STATUS_ACTIVE)
      ut.commit();

      Thanks in advance..:)

      Shafei