EntityManager em = emf.createEntityManager(); em.getTransaction().begin(); em.persist( new DataPoint( "Brett" ) ); em.getTransaction().commit(); em.close(); em = emf.createEntityManager(); em.getTransaction().begin(); DataPoint dp = em.find( DataPoint.class, 1 ); assertNotNull( dp ); assertEquals( "Brett", dp.getName() ); em.getTransaction().commit(); em.close(); em = emf.createEntityManager(); em.getTransaction().begin(); dp = em.find( DataPoint.class, 1 ); dp.setName( "Brett2" ); em.getTransaction().commit(); em.close(); em = emf.createEntityManager(); em.getTransaction().begin(); em.createQuery( "delete from DataPoint" ).executeUpdate(); em.getTransaction().commit(); em.close(); em = emf.createEntityManager(); em.getTransaction().begin();
private void assertQueryRowCount(String queryString, int rowCount) { EntityManager entityManager = getOrCreateEntityManager(); try { // persist the data entityManager.getTransaction().begin(); entityManager.persist( new Simple( new SimpleId( 1, 1 ), 1 ) ); entityManager.getTransaction().commit(); Query query = entityManager.createQuery( queryString ); assertEquals( rowCount, query.getResultList().size() ); } catch ( Exception e ) { if ( entityManager.getTransaction().isActive() ) { entityManager.getTransaction().rollback(); } throw e; } finally { entityManager.close(); } }
try { entityManager = properties == null ? factorySupplier.get().createEntityManager(): factorySupplier.get().createEntityManager(properties); function.beforeTransactionCompletion(); txn = entityManager.getTransaction(); txn.begin(); function.accept( entityManager ); if ( !txn.getRollbackOnly() ) { txn.commit(); txn.rollback(); if ( txn != null && txn.isActive() ) { try { txn.rollback(); function.afterTransactionCompletion(); if ( entityManager != null ) { entityManager.close();
public class ProjectServlet extends HttpServlet { @EJB ProjectService bean; protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // ... try { EntityManagerFactory emf = Persistence.createEntityManagerFactory("myPU"); EntityManager em = emf.createEntityManager(); EntityTransaction tx = em.getTransaction(); tx.begin(); try { bean.assignEmployeeToProject(projectId, empId); bean.updateProjectStatistics(); } finally { tx.commit(); } } catch (Exception e) { // handle exceptions from EntityTransaction methods // ... } // ... } }
private void ensureNotInRollbackOnlyTransation() { EntityTransaction tx = em.getTransaction(); U.must(!tx.isActive() || !tx.getRollbackOnly(), "Cannot perform writes inside read-only transaction!"); }
public void setRollbackOnly() { EntityTransaction tx = getEntityManagerHolder().getEntityManager().getTransaction(); if (tx.isActive()) { tx.setRollbackOnly(); } if (hasConnectionHolder()) { getConnectionHolder().setRollbackOnly(); } }
@Test public void canUseByteAsParameterForInComparison() { EntityManager entityManager = getFactory().createEntityManager(); entityManager.getTransaction().begin(); List<Movie> thrillers = entityManager.createQuery( "SELECT m FROM Movie m WHERE m.viewerRating IN (:viewerRating)", Movie.class ) .setParameter( "viewerRating", Arrays.asList( (byte) 8, (byte) 9 ) ) .getResultList(); assertThat( thrillers ).onProperty( "title" ).containsOnly( "To thatch a roof", "South by Southeast" ); entityManager.getTransaction().commit(); entityManager.close(); }
public void rollBackWithMultiTransactions() em.getTransaction().begin(); persistUsers(); em.getTransaction().commit(); em.clear(); EntityManager em1 = emf.createEntityManager(); User user = em1.find(User.class, "1"); em1.getTransaction().begin(); user.setName("pragalbh"); em1.merge(user); em1.getTransaction().commit(); EntityManager em2 = emf.createEntityManager(); user = em2.find(User.class, "1"); Assert.assertEquals("pragalbh", user.getName()); user.setName("karthik"); try EntityManager em3 = emf.createEntityManager(); User userNew = em3.find(User.class, "1"); Assert.assertNotNull(userNew); Assert.assertEquals("pragalbh", userNew.getName());
fbprofile.setuserAccount(uacc); em.getTransaction().begin(); em.persist(uacc); em.getTransaction().commit(); Query q = em.createQuery(uaQuery); List<UserAccount> results = q.getResultList(); Assert.assertEquals(1, results.size()); Assert.assertEquals("UpdatedTest", results.get(0).getDispName()); Assert.assertEquals(2, results.get(0).getSocialProfiles().size()); Assert.assertFalse(results.get(0).getSocialProfiles().get(0).getId().equals(results.get(0).getId()));
@Test public void testJpaEnvers() throws Exception { final ServiceReference serviceReference = bundleContext.getServiceReference( PersistenceProvider.class.getName() ); final PersistenceProvider persistenceProvider = (PersistenceProvider) bundleContext.getService( serviceReference ); final EntityManagerFactory emf = persistenceProvider.createEntityManagerFactory( "hibernate-osgi-test", null ); final Integer adpId; EntityManager em = emf.createEntityManager(); em.getTransaction().begin(); AuditedDataPoint adp = new AuditedDataPoint( "Chris" ); em.persist( adp ); em.getTransaction().commit(); adpId = adp.getId(); em.close(); em = emf.createEntityManager(); em.getTransaction().begin(); adp = em.find( AuditedDataPoint.class, adpId ); adp.setName( "Chris2" ); em.getTransaction().commit(); em.close(); em = emf.createEntityManager(); AuditReader ar = AuditReaderFactory.get( em ); assertEquals( 2, ar.getRevisions( AuditedDataPoint.class, adpId ).size() ); AuditedDataPoint rev1 = ar.find( AuditedDataPoint.class, adpId, 1 ); AuditedDataPoint rev2 = ar.find( AuditedDataPoint.class, adpId, 2 ); assertEquals( new AuditedDataPoint( adpId, "Chris" ), rev1 ); assertEquals( new AuditedDataPoint( adpId, "Chris2" ), rev2 ); em.close(); }
@Test public void testTransactionCommitWithExtendedEntityManagerUnsynchronized() { given(manager.getTransaction()).willReturn(tx); tt.execute(status -> { bean.extendedEntityManagerUnsynchronized.flush(); return null; }); verify(tx).commit(); verify(manager).flush(); verify(manager).close(); }
/** * Rollback on error. * * @throws Exception * the exception */ @Test public void rollbackOnError() throws Exception { try { em.getTransaction().begin(); persistUsers(); em.merge(null); em.getTransaction().commit(); } catch (Exception ex) { em.clear(); User user = em.find(User.class, "1"); Assert.assertNull(user); user = em.find(User.class, "2"); Assert.assertNull(user); user = em.find(User.class, "3"); Assert.assertNull(user); } }
EntityTransaction tx2 = mock(EntityTransaction.class); given(manager.getTransaction()).willReturn(tx); given(factory.createEntityManager()).willReturn(manager, manager2); given(manager2.getTransaction()).willReturn(tx2); given(manager2.isOpen()).willReturn(true); assertTrue(!TransactionSynchronizationManager.isSynchronizationActive()); verify(tx).commit(); verify(tx2).begin(); verify(tx2).commit(); verify(manager).flush(); verify(manager).close();
Contract contract = new Contract(); entityManager.persist( contract ); return contract.getId(); } ); Customer customer = new Customer(); entityManager.persist( customer ); return customer.getId(); } ); try { entityManager = entityManagerFactory().createEntityManager(); txn = entityManager.getTransaction(); txn.begin(); Customer customer = entityManager.createQuery( txn.commit(); if ( txn != null && txn.isActive() ) { try { txn.rollback();
@Test public void testCommit() { em.getTransaction().begin(); Object p1 = prepareData("1", 10); Object p2 = prepareData("2", 20); Object p3 = prepareData("3", 15); em.persist(p1); em.persist(p2); em.persist(p3); // on commit. em.getTransaction().commit(); Person p = findById(Person.class, "1", em); Assert.assertNotNull(p); em.getTransaction().begin(); ((Person) p2).setPersonName("rollback"); em.merge(p2); // roll back, should roll back person name for p2! em.getTransaction().rollback(); p = findById(Person.class, "1", em); Assert.assertNotNull(p); p = findById(Person.class, "2", em); Assert.assertNotNull(p); Assert.assertEquals("vivek", p.getPersonName()); Assert.assertNotSame("rollback", p.getPersonName()); }
@Test public void shouldRespectWriteExpression() { EntityManager em = getEntityManager(); em.getTransaction().begin(); List resultList = em.createNativeQuery( "select size_in_cm from t_staff_AUD where id =" + id ).getResultList(); Assert.assertEquals( 1, resultList.size() ); Double sizeInCm = null; if ( getDialect() instanceof Oracle8iDialect ) { sizeInCm = ((BigDecimal) resultList.get( 0 )).doubleValue(); } else { sizeInCm = (Double) resultList.get( 0 ); } em.getTransaction().commit(); Assert.assertEquals( HEIGHT_CENTIMETERS, sizeInCm.doubleValue(), 0.00000001 ); }
public static void main(String[] argv) { Map<String, String> configurationOverrides = new HashMap<String, String>(); EntityManagerFactory emf = Persistence.createEntityManagerFactory( "ConsolePU", configurationOverrides ); EntityManager entityManager = emf.createEntityManager(); populateTestData( entityManager ); entityManager.getTransaction().begin(); Session sesion = (Session) entityManager.getDelegate(); System.out.println( sesion.createQuery( "select e from org.hibernate.envers.demo.Person_versions e " + "where " + "e.originalId._revision.id =" + "(select max(e2.originalId._revision.id) " + "from org.hibernate.envers.demo.Person_versions e2 " + "where e.originalId.id = :p0) " ) .setParameter( "p0", 1 ) .list() ); entityManager.getTransaction().commit(); entityManager.close(); emf.close(); }
private void setup() { EntityManager entityManager = getEntityManager(); entityManager.getTransaction().begin(); for ( int i = 0; i < NUMBER_ENTITIES; i++ ) { StrTestEntity testEntity = new StrTestEntity( "x" + i ); entityManager.persist( testEntity ); ids.add( testEntity.getId() ); } entityManager.getTransaction().commit(); }
@Test @TestForIssue(jiraKey = "OGM-1294") public void testJpqlReturnPropertiesForMan() { initDB(); em.getTransaction().begin(); List<Person> persons = em.createQuery( "FROM Person p where p.name = :name", Person.class ).setParameter( "name", john.getName() ).getResultList(); assertThat( persons ).hasSize( 1 ); assertThat( persons.get( 0 ) ).isInstanceOf( Man.class ); Man man = (Man) ( persons.get( 0 ) ); assertThat( man.getHobby() ).isEqualTo( john.getHobby() ); em.getTransaction().commit(); }
/** * On rollback after merge. * * @throws Exception * the exception */ @Test public void onRollbackAfterMerge() throws Exception { em.getTransaction().begin(); persistUsers(); em.getTransaction().commit(); em.clear(); em.getTransaction().begin(); User user = em.find(User.class, "1"); user.setName("pragalbh"); em.merge(user); em.getTransaction().rollback(); em.clear(); user = em.find(User.class, "1"); Assert.assertEquals("dev", user.getName()); Assert.assertNotSame("pragalbh", user.getName()); }