0 Replies Latest reply on Dec 29, 2004 9:53 AM by susantpatnaik

    without any bean can we use usertransaction

    susantpatnaik

      hi,
      can we use usertrasaction without any beans like session or entity bean.
      i am using a simple servlet where i am using usertransaction.
      this is statement if i am wrong pls correct me.

      try{
      objDBUtil.beginTxn();
      objDBUtil.execUdate("correct qry");
      objDBUtil.execUdate("correct qry");
      objDBUtil.execUdate("in correct qry");
      objDBUtil.commitTxn();

      } catch (Exception e) {
      System.out.println(" Step5#...."+e);
      objDBUtil.rollbackTxn();
      }


      actually i m getting sqlexception but data are not rolledback.
      so if any body knows pls help me


      Rgds,
      S.S