public void create(Usuario usuario) throws PreexistingEntityException, Exception { EntityManager em = null; try { em = getEntityManager(); em.getTransaction().begin(); Investigador investigadorIdentificacion = usuario.getInvestigadorIdentificacion(); if (investigadorIdentificacion != null) { investigadorIdentificacion = em.getReference( investigadorIdentificacion.getClass(), investigadorIdentificacion.getIdentificacion()); usuario.setInvestigadorIdentificacion(investigadorIdentificacion); } em.persist(usuario); if (investigadorIdentificacion != null) { investigadorIdentificacion.getUsuarioList().add(usuario); investigadorIdentificacion = em.merge(investigadorIdentificacion); } em.getTransaction().commit(); } catch (Exception ex) { if (findUsuario(usuario.getNombre()) != null) { throw new PreexistingEntityException("Usuario " + usuario + " already exists.", ex); } throw ex; } finally { if (em != null) { em.close(); } } }
public PurchaseDTO getPurchase(Long id) { entityManager.getTransaction().begin(); PurchaseDTO result = PurchaseConverter.entity2PersistenceDTO(entityManager.find(PurchaseEntity.class, id)); entityManager.getTransaction().commit(); return result; }
public void destroy(Integer id) throws NonexistentEntityException { EntityManager em = null; try { em = getEntityManager(); em.getTransaction().begin(); BarEntity bar; try { bar = em.getReference(BarEntity.class, id); bar.getId(); } catch (EntityNotFoundException enfe) { throw new NonexistentEntityException("The bar with id " + id + " no longer exists.", enfe); } ContractEntity contract = bar.getContract(); if (contract != null) { contract.getBarCollection().remove(bar); contract = em.merge(contract); } em.remove(bar); em.getTransaction().commit(); } finally { if (em != null) { em.close(); } } }
public static Project createProject(Project project) { EntityManager em = getEM(); em.getTransaction().begin(); em.persist(project); em.getTransaction().commit(); return project; }
public static void assignUserToProject(Long projectID, Long userID) { EntityManager em = getEM(); ProjectUser pu = em.find(ProjectUser.class, userID); em.getTransaction().begin(); pu.setContributor(em.find(Project.class, projectID)); em.getTransaction().commit(); }
public void executeEscalatedDeadline( Task task, Deadline deadline, EntityManager em, TaskService service) { if (deadline == null || deadline.getEscalations() == null) { return; } for (Escalation escalation : deadline.getEscalations()) { // we won't impl constraints for now // escalation.getConstraints() String language = "es_CL"; for (Notification notification : escalation.getNotifications()) { if (notification.getNotificationType() == NotificationType.Email) { executeEmailNotification((EmailNotification) notification, task, em); } } if (!escalation.getReassignments().isEmpty()) { // get first and ignore the rest. Reassignment reassignment = escalation.getReassignments().get(0); em.getTransaction().begin(); task.getTaskData().setStatus(Status.Ready); List potentialOwners = new ArrayList(reassignment.getPotentialOwners()); task.getPeopleAssignments().setPotentialOwners(potentialOwners); em.getTransaction().commit(); } } em.getTransaction().begin(); deadline.setEscalated(true); em.getTransaction().commit(); }
@Override public T add(T entry) { em.getTransaction().begin(); T newEntry = em.merge(entry); em.getTransaction().commit(); return newEntry; }
@Test @Priority(10) public void initData() { EntityManager em = getEntityManager(); SetRefEdEntity ed1 = new SetRefEdEntity(1, "data_ed_1"); SetRefIngEntity ing1 = new SetRefIngEntity(3, "data_ing_1"); // Revision 1 em.getTransaction().begin(); em.persist(ed1); em.getTransaction().commit(); // Revision 2 em.getTransaction().begin(); ed1 = em.find(SetRefEdEntity.class, ed1.getId()); em.persist(ing1); ed1.setReffering(new HashSet<SetRefIngEntity>()); ed1.getReffering().add(ing1); em.getTransaction().commit(); // ed1_id = ed1.getId(); ing1_id = ing1.getId(); }
@Test @Priority(10) public void initData() throws InterruptedException { timestamp1 = System.currentTimeMillis(); Thread.sleep(100); // Revision 1 EntityManager em = getEntityManager(); em.getTransaction().begin(); StrTestEntity te = new StrTestEntity("x"); em.persist(te); id = te.getId(); em.getTransaction().commit(); timestamp2 = System.currentTimeMillis(); Thread.sleep(100); // Revision 2 em.getTransaction().begin(); te = em.find(StrTestEntity.class, id); te.setStr("y"); em.getTransaction().commit(); timestamp3 = System.currentTimeMillis(); }
@Override public List<Event> getChildAdoptionRecords(Person person) { // get the birth records of the children of this parent List<Adoption> adoptionRecords = new ArrayList<Adoption>(); em.getTransaction().begin(); TypedQuery<Adoption> q = em.createQuery( "select b from Adoption b, IN(b.parents) p WHERE p.id = :idParam", Adoption.class); q.setParameter("idParam", person.getId()); adoptionRecords.addAll(q.getResultList()); List<Event> adoptions = new ArrayList<Event>(); for (Adoption b : adoptionRecords) { if (b != null) { AdoptedChildRecord cr = new AdoptedChildRecord(); cr.setEventDate(b.getEventDate()); cr.setPerson(person); cr.setChild(b.getPerson()); cr.setTown(b.getTown()); cr.setState_province(b.getState_province()); cr.setCountry(b.getCountry()); adoptions.add(cr); } } em.getTransaction().commit(); return adoptions; }
@SuppressWarnings("unchecked") @Override public Set<Person> getTopAncestors() { Set<Person> topAncestors = new HashSet<Person>(); // Find all the parents // If a person is in the childrenmap as a key, // then they are registered as a parent to somebody em.getTransaction().begin(); TypedQuery q = em.createQuery("select p.parents from Birth p", Person.class); List<Person> people = (List<Person>) q.getResultList(); em.getTransaction().commit(); for (Person person : people) { // If a person doesn't have a birth record, // then there's no record of a parent System.out.println("Found " + person); Birth birthRecord = findBirthRecord(person); if (birthRecord == null || birthRecord.getParents().isEmpty()) { System.out.println("Adding " + person + " to top ancestors list"); topAncestors.add(person); } } return topAncestors; }
@Override public List<Event> getChildrenBirths(Person person) { // get the birth records of the children of this parent List<Birth> birthRecords = new ArrayList<Birth>(); em.getTransaction().begin(); Query q = em.createQuery("select b from Birth b, IN(b.parents) p WHERE p.id = :idParam"); q.setParameter("idParam", person.getId()); birthRecords.addAll((Collection<? extends Birth>) q.getResultList()); List<Event> childrenBirths = new ArrayList<Event>(); for (Birth b : birthRecords) { if (b != null) { ChildRecord cr = new ChildRecord(); cr.setEventDate(b.getEventDate()); cr.setPerson(person); cr.setChild(b.getPerson()); cr.setTown(b.getTown()); cr.setState_province(b.getState_province()); cr.setCountry(b.getCountry()); childrenBirths.add(cr); } } em.getTransaction().commit(); return childrenBirths; }
@Override public Set<Person> getSiblingsAll(Person thisPerson) { // return full and half siblings of thisPerson // exclude thisPerson from the set Set<Person> siblings = new HashSet<Person>(); List<Person> parents = new ArrayList<Person>(); em.getTransaction().begin(); Query q = em.createQuery( "select b.parents from Birth b, IN(b.person) p WHERE p.id = :personId" + " or p.id = :parent2Id"); q.setParameter("personId", thisPerson.getId()); parents.addAll((Collection<? extends Person>) q.getResultList()); if (!parents.isEmpty()) { if (parents.size() == 2) { siblings = getChildrenAll(parents.get(0), parents.get(1)); } else if (parents.size() == 1) { siblings = getChildren(parents.get(0)); } } em.getTransaction().commit(); siblings.remove(thisPerson); return siblings; }
/** Test of an SQL query using a result set mapping giving two entities (Login + LoginAccount). */ public void testSQLResult() { if (vendorID == null) { return; } try { EntityManager em = getEM(); EntityTransaction tx = em.getTransaction(); try { tx.begin(); LoginAccount acct = new LoginAccount(1, "Fred", "Flintstone"); Login login = new Login("flintstone", "pwd"); acct.setLogin(login); em.persist(login); em.persist(acct); tx.commit(); } finally { if (tx.isActive()) { tx.rollback(); } em.close(); } em = getEM(); tx = em.getTransaction(); try { tx.begin(); // Check the results List result = em.createNativeQuery( "SELECT P.ID, P.FIRSTNAME, P.LASTNAME, P.LOGIN_ID, L.ID, L.USERNAME, L.PASSWORD " + "FROM JPA_AN_LOGINACCOUNT P, JPA_AN_LOGIN L", "AN_LOGIN_PLUS_ACCOUNT") .getResultList(); assertEquals(1, result.size()); Iterator iter = result.iterator(); while (iter.hasNext()) { // Should be a String (type of "ID" column) Object[] obj = (Object[]) iter.next(); assertEquals("Fred", ((LoginAccount) obj[0]).getFirstName()); assertEquals("flintstone", ((Login) obj[1]).getUserName()); assertEquals("Fred", ((LoginAccount) obj[0]).getFirstName()); assertTrue(((LoginAccount) obj[0]).getLogin() == ((Login) obj[1])); } tx.rollback(); } finally { if (tx.isActive()) { tx.rollback(); } em.close(); } } finally { clean(LoginAccount.class); clean(Login.class); } }
@Override public void create(User obj) { em.getTransaction().begin(); em.persist(obj); em.getTransaction().commit(); }
/** * Refresh method test loads an entity with two different entity managers. One updates the entity * and another refreshes it. The test checks whether refreshed entity contains changes. */ @Test public void entityEquality_refresh_EntityManager() { // load an entity EntityManager emRefresh = factory.createEntityManager(); Person person1 = emRefresh.find(Person.class, SIMON_SLASH_ID); // load the same entity by different entity manager EntityManager emChange = factory.createEntityManager(); Person person2 = emChange.find(Person.class, SIMON_SLASH_ID); // change the first entity - second entity remains the same emRefresh.getTransaction().begin(); person1.setFirstName("refreshDemo"); assertNotSame("refreshDemo", person2.getFirstName()); // commit the transaction - second entity still remains the same emRefresh.getTransaction().commit(); assertNotSame("refreshDemo", person2.getFirstName()); // refresh second entity - it changes emChange.refresh(person2); assertEquals("refreshDemo", person2.getFirstName()); emRefresh.close(); emChange.close(); }
@Override public void delete(User obj) { em.getTransaction().begin(); em.remove(obj); em.getTransaction().commit(); }
@Test public void testExcludeHbmPar() throws Exception { File testPackage = buildExcludeHbmPar(); addPackageToClasspath(testPackage); EntityManagerFactory emf = null; try { emf = Persistence.createEntityManagerFactory("excludehbmpar", new HashMap()); } catch (PersistenceException e) { Throwable nested = e.getCause(); if (nested == null) { throw e; } nested = nested.getCause(); if (nested == null) { throw e; } if (!(nested instanceof ClassNotFoundException)) { throw e; } fail("Try to process hbm file: " + e.getMessage()); } EntityManager em = emf.createEntityManager(); Caipirinha s = new Caipirinha("Strong"); em.getTransaction().begin(); em.persist(s); em.getTransaction().commit(); em.getTransaction().begin(); s = em.find(Caipirinha.class, s.getId()); em.remove(s); em.getTransaction().commit(); em.close(); emf.close(); }
public void addCurr(List<Currency> currency) { em.getTransaction().begin(); for (Currency c : currency) { em.persist(c); } em.getTransaction().commit(); }
@Test public void testCfgXmlPar() throws Exception { File testPackage = buildCfgXmlPar(); addPackageToClasspath(testPackage); EntityManagerFactory emf = Persistence.createEntityManagerFactory("cfgxmlpar", new HashMap()); EntityManager em = emf.createEntityManager(); Item i = new Item(); i.setDescr("Blah"); i.setName("factory"); Morito m = new Morito(); m.setPower("SuperStrong"); em.getTransaction().begin(); em.persist(i); em.persist(m); em.getTransaction().commit(); em.getTransaction().begin(); i = em.find(Item.class, i.getName()); em.remove(i); em.remove(em.find(Morito.class, m.getId())); em.getTransaction().commit(); em.close(); emf.close(); }
private void btnOKActionPerformed( java.awt.event.ActionEvent evt) { // GEN-FIRST:event_btnOKActionPerformed EntityManager em = OPDE.createEM(); try { em.getTransaction().begin(); TradeForm myTradeForm = em.merge(tradeForm); em.lock(myTradeForm, LockModeType.OPTIMISTIC); myTradeForm.setSubtext(txtZusatz.getText()); DosageForm dosageForm = em.merge((DosageForm) cmbForm.getSelectedItem()); em.lock(dosageForm, LockModeType.OPTIMISTIC); myTradeForm.setDosageForm(dosageForm); em.getTransaction().commit(); tradeForm = myTradeForm; } catch (Exception e) { if (em.getTransaction().isActive()) { em.getTransaction().rollback(); } OPDE.fatal(e); } finally { em.close(); } dispose(); } // GEN-LAST:event_btnOKActionPerformed
@Test public void testDefaultPar() throws Exception { File testPackage = buildDefaultPar(); addPackageToClasspath(testPackage); // run the test EntityManagerFactory emf = Persistence.createEntityManagerFactory("defaultpar", new HashMap()); EntityManager em = emf.createEntityManager(); ApplicationServer as = new ApplicationServer(); as.setName("JBoss AS"); Version v = new Version(); v.setMajor(4); v.setMinor(0); v.setMicro(3); as.setVersion(v); Mouse mouse = new Mouse(); mouse.setName("mickey"); em.getTransaction().begin(); em.persist(as); em.persist(mouse); assertEquals(1, em.createNamedQuery("allMouse").getResultList().size()); Lighter lighter = new Lighter(); lighter.name = "main"; lighter.power = " 250 W"; em.persist(lighter); em.flush(); em.remove(lighter); em.remove(mouse); assertNotNull(as.getId()); em.remove(as); em.getTransaction().commit(); em.close(); emf.close(); }
public static ProjectUser createUser(ProjectUser user) { EntityManager em = getEM(); em.getTransaction().begin(); em.persist(user); em.getTransaction().commit(); return user; }
public void destroy(Integer id) throws NonexistentEntityException { EntityManager em = null; try { em = getEntityManager(); em.getTransaction().begin(); Tema tema; try { tema = em.getReference(Tema.class, id); tema.getId(); } catch (EntityNotFoundException enfe) { throw new NonexistentEntityException("The tema with id " + id + " no longer exists.", enfe); } Clase idAreaDerecho = tema.getIdAreaDerecho(); if (idAreaDerecho != null) { idAreaDerecho.getTemaList().remove(tema); idAreaDerecho = em.merge(idAreaDerecho); } List<Normatividad> normatividadList = tema.getNormatividadList(); for (Normatividad normatividadListNormatividad : normatividadList) { normatividadListNormatividad.setIdTema(null); normatividadListNormatividad = em.merge(normatividadListNormatividad); } List<Proceso> procesoList = tema.getProcesoList(); for (Proceso procesoListProceso : procesoList) { procesoListProceso.setIdTema(null); procesoListProceso = em.merge(procesoListProceso); } em.remove(tema); em.getTransaction().commit(); } finally { if (em != null) { em.close(); } } }
public PurchaseDTO createPurchase(PurchaseDTO purchase) { PurchaseEntity entity = PurchaseConverter.persistenceDTO2Entity(purchase); entityManager.getTransaction().begin(); entityManager.persist(entity); entityManager.getTransaction().commit(); return PurchaseConverter.entity2PersistenceDTO(entity); }
public void destroy(long id) throws NonexistentEntityException { EntityManager em = null; try { em = getEntityManager(); em.getTransaction().begin(); CheckoutRecord checkoutRecord; try { checkoutRecord = em.getReference(CheckoutRecord.class, id); checkoutRecord.getId(); } catch (EntityNotFoundException enfe) { throw new NonexistentEntityException( "The checkoutRecord with id " + id + " no longer exists.", enfe); } Member member = checkoutRecord.getMember(); if (member != null) { member.getRecords().remove(checkoutRecord); member = em.merge(member); } Fine fine = checkoutRecord.getFine(); if (fine != null) { fine.setRecord(null); fine = em.merge(fine); } em.remove(checkoutRecord); em.getTransaction().commit(); } finally { if (em != null) { em.close(); } } }
public void create(BarEntity bar) throws PreexistingEntityException, Exception { EntityManager em = null; try { em = getEntityManager(); em.getTransaction().begin(); ContractEntity contract = bar.getContract(); if (contract != null) { contract = em.getReference(contract.getClass(), contract.getId()); bar.setContract(contract); } em.persist(bar); if (contract != null) { contract.getBarCollection().add(bar); contract = em.merge(contract); } em.getTransaction().commit(); } catch (Exception ex) { if (findBar(bar.getId()) != null) { throw new PreexistingEntityException("Bar " + bar + " already exists.", ex); } throw ex; } finally { if (em != null /*&& em.isOpen()*/) { em.close(); } } }
private void setH2LockTimeout() { EntityManager manager = entityManagerFactory.createEntityManager(); manager.getTransaction().begin(); manager.createNativeQuery("SET DEFAULT_LOCK_TIMEOUT " + locktimeout).executeUpdate(); manager.getTransaction().commit(); manager.close(); }
@SuppressWarnings({"unchecked"}) private void cleanup() { EntityManager em = getOrCreateEntityManager(); em.getTransaction().begin(); for (Hoarder hoarder : (List<Hoarder>) em.createQuery("from Hoarder").getResultList()) { hoarder.getItems().clear(); em.remove(hoarder); } for (Category category : (List<Category>) em.createQuery("from Category").getResultList()) { if (category.getExampleItem() != null) { category.setExampleItem(null); em.remove(category); } } for (Item item : (List<Item>) em.createQuery("from Item").getResultList()) { item.setCategory(null); em.remove(item); } em.createQuery("delete from Item").executeUpdate(); em.getTransaction().commit(); em.close(); }
public void destroy(String id) throws NonexistentEntityException { EntityManager em = null; try { em = getEntityManager(); em.getTransaction().begin(); Usuario usuario; try { usuario = em.getReference(Usuario.class, id); usuario.getNombre(); } catch (EntityNotFoundException enfe) { throw new NonexistentEntityException( "The usuario with id " + id + " no longer exists.", enfe); } Investigador investigadorIdentificacion = usuario.getInvestigadorIdentificacion(); if (investigadorIdentificacion != null) { investigadorIdentificacion.getUsuarioList().remove(usuario); investigadorIdentificacion = em.merge(investigadorIdentificacion); } em.remove(usuario); em.getTransaction().commit(); } finally { if (em != null) { em.close(); } } }