1 Reply Latest reply: Jul 10, 2013 9:37 AM by Gert-JanPaulissen RSS

    30EA1 - Unit Testing Not Releasing Locks

    Tubby
      Hello,

      I've been utilizing the Unit Testing Framework and have been having problems with the locking that's been implemented. A couple of times now i've gotten a "no lock - Unable to obtain lock at this time". At one point the only solution i could find (without bouncing the database instance) was to manually delete the test from the UT table and then import the test from an exported XML file.

      Not a huge inconvenience, but it looks like there may be some work needed on this feature.

      Thanks!

      Version information.
      Oracle SQL Developer 3.0.02
       Version 3.0.02
      Build MAIN-02.37
      Copyright ©  2005,2010 Oracle.  All Rights Reserved.
      IDE Version: 11.1.1.4.37.58.38
      Product ID: oracle.sqldeveloper
      Product Version: 11.1.2.02.37
        • 1. Re: 30EA1 - Unit Testing Not Releasing Locks
          Gert-JanPaulissen

          Hi,

           

          I have been using unit testing very shortly and I got the same problem when I tried to start a test run while the connection was lost. Our office policy is to kill remote sessions after a while,

           

          The solution I used was to delete the test from the GUI and to recreate it manually. I followed the procedure above but it did not help.

           

           

          Version information:

           

          Oracle SQL Developer 3.2.10.09

          Version 3.2.10.09

          Build MAIN-09.57

          Copyright ©  2005, 2012 Oracle.  All Rights Reserved.

          IDE Version: 11.1.1.4.37.59.48

          Product ID: oracle.sqldeveloper

          Product Version: 11.2.0.09.57