Examples with LockOptions org.hibernate.LockOptions used on opensource projects

Example 51 with LockOptions

use of org.hibernate.LockOptions in project hibernate-orm by hibernate.

the class OracleFollowOnLockingTest method testPessimisticLockWithFirstResultsWhileExplicitlyEnablingFollowOnLockingThenFollowOnLocking.

@Test
public void testPessimisticLockWithFirstResultsWhileExplicitlyEnablingFollowOnLockingThenFollowOnLocking() {
    final Session session = openSession();
    session.beginTransaction();
    sqlStatementInterceptor.getSqlQueries().clear();
    List<Product> products = session.createQuery("select p from Product p", Product.class).setLockOptions(new LockOptions(LockMode.PESSIMISTIC_WRITE).setFollowOnLocking(true)).setFirstResult(40).setMaxResults(10).getResultList();
    assertEquals(10, products.size());
    assertEquals(11, sqlStatementInterceptor.getSqlQueries().size());
    session.getTransaction().commit();
    session.close();
}

Example 52 with LockOptions

use of org.hibernate.LockOptions in project hibernate-orm by hibernate.

the class OracleFollowOnLockingTest method testPessimisticLockWithGroupByWhileExplicitlyDisablingFollowOnLockingThenFails.

@Test
public void testPessimisticLockWithGroupByWhileExplicitlyDisablingFollowOnLockingThenFails() {
    final Session session = openSession();
    session.beginTransaction();
    sqlStatementInterceptor.getSqlQueries().clear();
    try {
        List<Object[]> products = session.createQuery("select count(p), p " + "from Product p " + "group by p.id, p.name ").setLockOptions(new LockOptions(LockMode.PESSIMISTIC_WRITE).setFollowOnLocking(false)).getResultList();
        fail("Should throw exception since Oracle does not support GROUP BY if follow on locking is disabled");
    } catch (PersistenceException expected) {
        assertEquals(SQLGrammarException.class, expected.getCause().getClass());
    }
}

Example 53 with LockOptions

use of org.hibernate.LockOptions in project hibernate-orm by hibernate.

the class SQLServerDialectTest method testLockNowaitSqlServer.

@Test
@TestForIssue(jiraKey = "HHH-3961")
public void testLockNowaitSqlServer() throws Exception {
    Session s = openSession();
    s.beginTransaction();
    final Product2 kit = new Product2();
    kit.id = 4000;
    kit.description = "m";
    s.persist(kit);
    s.getTransaction().commit();
    final Transaction tx = s.beginTransaction();
    Session s2 = openSession();
    s2.beginTransaction();
    Product2 kit2 = s2.byId(Product2.class).load(kit.id);
    kit.description = "change!";
    // creates write lock on kit until we end the transaction
    s.flush();
    Thread thread = new Thread(() -> {
        sleep(TimeUnit.SECONDS.toMillis(1));
        tx.commit();
    });
    LockOptions opt = new LockOptions(LockMode.UPGRADE_NOWAIT);
    // seems useless
    opt.setTimeOut(0);
    long start = System.currentTimeMillis();
    thread.start();
    try {
        s2.buildLockRequest(opt).lock(kit2);
    } catch (LockTimeoutException e) {
    // OK
    }
    long end = System.currentTimeMillis();
    thread.join();
    long differenceInMillis = end - start;
    assertTrue("Lock NoWait blocked for " + differenceInMillis + " ms, this is definitely to much for Nowait", differenceInMillis < 2000);
    s2.getTransaction().rollback();
    s.getTransaction().begin();
    s.delete(kit);
    s.getTransaction().commit();
}

Example 54 with LockOptions

use of org.hibernate.LockOptions in project hibernate-orm by hibernate.

the class AbstractLockHintTest method lockOptions.

protected LockOptions lockOptions(String aliasToLock) {
    LockOptions lockOptions = new LockOptions(LockMode.UPGRADE);
    lockOptions.setAliasSpecificLockMode(aliasToLock, LockMode.UPGRADE);
    return lockOptions;
}

Example 55 with LockOptions

use of org.hibernate.LockOptions in project hibernate-orm by hibernate.

the class HANALockTimeoutTest method testLockTimeoutAliasNoTimeout.

@Test
public void testLockTimeoutAliasNoTimeout() {
    String alias = "a";
    assertEquals(" for update of a", dialect.getForUpdateString(alias, new LockOptions(LockMode.PESSIMISTIC_READ).setAliasSpecificLockMode(alias, LockMode.PESSIMISTIC_READ)));
    assertEquals(" for update of a", dialect.getForUpdateString(alias, new LockOptions(LockMode.PESSIMISTIC_WRITE).setAliasSpecificLockMode(alias, LockMode.PESSIMISTIC_WRITE)));
}