final int previousTimeout =
            ((Number) session.createSQLQuery("values current lock timeout").uniqueResult())
                    .intValue();
    
    try {
        session.createSQLQuery("set current lock timeout 0").executeUpdate();
    
        // ... Blocking statement ...
    } finally {
        session.createSQLQuery("set current lock timeout ?").setInteger(0, previousTimeout).executeUpdate();
    }