public Company getCompany(String id) throws SQLException {
   Connection connection = oracleCM.getConnection();
   try {
     return companyDAO.find(id, connection);
   } finally {
     connection.close();
   }
 }
 public Employee getEmployee(String id) throws SQLException {
   Connection connection = oracleCM.getConnection();
   try {
     return employeeDAO.find(id, connection);
   } finally {
     connection.close();
   }
 }
 public void hireEmployee(Employee hiredEmployee, Company toCompany) throws SQLException {
   Connection connection = oracleCM.getConnection();
   try {
     connection.setAutoCommit(false);
     employeeDAO.save(hiredEmployee, connection);
     Company company = companyDAO.find(toCompany.getId(), connection);
     company.getEmployees().add(hiredEmployee);
     companyDAO.update(company, connection);
     connection.commit();
   } finally {
     connection.setAutoCommit(true);
     connection.close();
   }
 }
 public void fireEmployee(Employee firedEmployee, Company fromCompany) throws SQLException {
   Connection connection = oracleCM.getConnection();
   try {
     connection.setAutoCommit(false);
     Company company = companyDAO.find(fromCompany.getId(), connection);
     company.getEmployees().remove(firedEmployee);
     companyDAO.update(company, connection);
     employeeDAO.delete(firedEmployee, connection);
     connection.commit();
   } finally {
     connection.setAutoCommit(true);
     connection.close();
   }
 }