@Override public void deleteFinancialSource(int id) { EntityManager entityManager = this.getSession().getEntityManager(); TransactionScope transactionScope = this.beginTransaction(); try { entityManager .createQuery("DELETE FROM FinancialSource fs WHERE fs.id :finId") .setParameter("finId", id) .executeUpdate(); transactionScope.commit(); } catch (PersistenceException ex) { throw TransactionHelper.translateException(ex); } finally { transactionScope.dispose(); } }