protected void resetApiStatus(String resourceName, HttpMethod httpMethod, Connection conn) {
   PreparedStatement stat = null;
   try {
     stat = conn.prepareStatement(RESET_API_STATUS);
     stat.setString(1, resourceName);
     stat.setString(2, httpMethod.toString());
     stat.executeUpdate();
   } catch (Throwable t) {
     processDaoException(
         t,
         "Error resetting status : method '" + resourceName + "' method " + httpMethod.toString(),
         "resetApiStatus");
   } finally {
     closeDaoResources(null, stat);
   }
 }
 public void resetApiStatus(String resourceName, HttpMethod httpMethod) {
   Connection conn = null;
   try {
     conn = this.getConnection();
     conn.setAutoCommit(false);
     this.resetApiStatus(resourceName, httpMethod, conn);
     conn.commit();
   } catch (Throwable t) {
     this.executeRollback(conn);
     processDaoException(
         t,
         "Error resetting status : method '" + resourceName + "' method " + httpMethod.toString(),
         "resetApiStatus");
   } finally {
     closeConnection(conn);
   }
 }