title: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expiredConnection .even after commit also getting same issue
body: <pre><code>Query : "SELECT * FROM basictasks WHERE STATUS = 1 and rownum = 1 order by TASKID for update nowait" 
  
  octTransaction.Commit();
  octTransaction.Dispose();
  </code></pre>
  
  <pre><code> Tasks tasks = new Tasks();
                 DataLayer datalayer = new DataLayer();
                 datalayer = Login.objDataLayer;
                 OracleCommand ocdSelect = new OracleCommand();
                 datalayer.BeginTransaction();
                 Sqlquery = "SELECT * FROM basictasks WHERE STATUS = 1 and rownum = 1 order by TASKID for update nowait ";
                 ocdSelect.CommandText = Sqlquery;
  
                 DataTable dt = datalayer.GetResultDT(ocdSelect, false);
                 if (dt.Rows.Count &gt; 0)
                 {
                     tasks.TaskID = Convert.ToInt32(dt.Rows[0]["TASKID"]);
                     tasks.MechineName = dt.Rows[0]["MACHINENAME"].ToString();
                     tasks.Parameters = dt.Rows[0]["PARAMETERS"].ToString();
                     tasks.TaskName = dt.Rows[0]["TASKNAME"].ToString();
                     tasks.Description = dt.Rows[0]["DESCRIPTION"].ToString();
                     tasks.Status = 2;
                     tasks.StartTime = DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss tt");
                     tasks.FinishJob = false;
                     Sqlquery = "UPDATE basictasks SET STATUS = " + tasks.Status + ", STARTTIME = SYSDATE,MACHINENAME = '" + Common.MechineName + "',REMARK = ' ',ENDTIME = null WHERE TASKID = " + tasks.TaskID + "";
                     datalayer.TableOperation_BySQL(Sqlquery, true);
                     if (datalayer != null)
                         datalayer.CheckTransaction(true);
                     return tasks;
                 }
  
                 else
                 {
                     if (datalayer != null)
                         datalayer.CheckTransaction(true);
                 }
             }
  </code></pre>
  
  <p>once close connection and reopen the connection then working. but I don't want it to open and close connection every time. I want to use one connection.</p>