org.hibernate.Session.createNativeQuery() - java examples

Here are the examples of the java api org.hibernate.Session.createNativeQuery() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

60 Examples 7

18 View Complete Implementation : NativeQueryMethodInterceptorImpl.java
Copyright MIT License
Author : gasparbarancelli
private Long getTotalRecords(NativeQueryInfo info, Session session) {
    NativeQuery<?> query = session.createNativeQuery(info.getSqlTotalRecord());
    query.unwrap(NativeQuery.clreplaced).addScalar("totalRecords", LongType.INSTANCE);
    addParameterJpa(query, info);
    return (Long) query.getSingleResult();
}

18 View Complete Implementation : MCRClassification2Commands.java
Copyright GNU General Public License v3.0
Author : MyCoRe-Org
private static void repairCategoryWithGapInPos(Number parentID, Number firstErrorPositionInParent) {
    Session session = MCRHIBConnection.instance().getSession();
    // the query decrease the position in parent with a rate.
    // eg. posInParent: 0 1 2 5 6 7
    // at 3 the position get faulty, 5 is the min. of the position greather
    // 3
    // so the reate is 5-3 = 2
    String sqlQuery = "update {h-schema}MCRCategory " + "set positioninparent=(positioninparent - (select min(positioninparent) from " + "{h-schema}MCRCategory where parentid=" + parentID + " and positioninparent > " + firstErrorPositionInParent + ")+" + firstErrorPositionInParent + ") where parentid=" + parentID + " and positioninparent > " + firstErrorPositionInParent;
    session.createNativeQuery(sqlQuery).executeUpdate();
}

18 View Complete Implementation : MCRClassification2Commands.java
Copyright GNU General Public License v3.0
Author : MyCoRe-Org
public static void repairCategoryWithWrongStartPos(Number parentID, Number wrongStartPositionInParent) {
    Session session = MCRHIBConnection.instance().getSession();
    String sqlQuery = "update {h-schema}MCRCategory set positioninparent= positioninparent -" + wrongStartPositionInParent + "-1 where parentid=" + parentID + " and positioninparent > " + wrongStartPositionInParent;
    session.createNativeQuery(sqlQuery).executeUpdate();
}

18 View Complete Implementation : HibernateStore.java
Copyright GNU Lesser General Public License v2.1
Author : xwiki
private <T, E> T executeNative(String sqlString, Function<NativeQuery<E>, T> function) {
    try (Session session = getSessionFactory().openSession()) {
        NativeQuery<E> query = session.createNativeQuery(sqlString);
        return function.apply(query);
    }
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_query_parameters_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-query-parameters-example[]
        List<Person> persons = session.createNativeQuery("SELECT * " + "FROM Person " + "WHERE name like :name").addEnreplacedy(Person.clreplaced).setParameter("name", "J%").list();
        // end::sql-hibernate-query-parameters-example[]
        replacedertEquals(1, persons.size());
    });
}

17 View Complete Implementation : ReadConcernPropagationTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void shouldApplyReadConcernWhenExecutingBackendQuery() {
    // given
    MockMongoClientBuilder.MockMongoClient mockClient = mockClient().insert("GolfPlayer", getPlayer()).build();
    setupSessionFactory(new MongoDBDatastoreProvider(mockClient.getClient()));
    Session session = sessions.openSession();
    // when
    String nativeQuery = "db.GolfPlayer" + ".findAndModify({ 'query': {'_id': 1}, 'update': { '$set': { 'name': 'Ben' } }, 'new': true })";
    NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(GolfPlayer.clreplaced);
    @SuppressWarnings("unchecked")
    List<GolfPlayer> result = query.list();
    // then
    replacedertThat(result).hreplacedize(1);
    verify(mockClient.getClient().getDatabase("db").getCollection("GolfPlayer")).withReadConcern(eq(ReadConcern.MAJORITY));
}

17 View Complete Implementation : Neo4jSessionNativeQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testListMultipleResultQueryWithFirstResultAndMaxRows() throws Exception {
    Session session = openSession();
    Transaction transaction = session.beginTransaction();
    String nativeQuery = "MATCH ( n:" + TABLE_NAME + " { author:'Oscar Wilde' } ) RETURN n ORDER BY n.name DESC";
    @SuppressWarnings("unchecked")
    List<OscarWildePoem> result = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.TABLE_NAME, OscarWildePoem.clreplaced).setFirstResult(1).setMaxResults(1).list();
    replacedertThat(result).containsExactly(ballade);
    transaction.commit();
    session.clear();
    session.close();
}

17 View Complete Implementation : MCRClassification2Commands.java
Copyright GNU General Public License v3.0
Author : MyCoRe-Org
private static void checkMissingParent(String clreplacedID, List<String> log) {
    Session session = MCRHIBConnection.instance().getSession();
    String sqlQuery = "select cat.categid from {h-schema}MCRCategory cat WHERE cat.clreplacedid='" + clreplacedID + "' and cat.level > 0 and cat.parentID is NULL";
    @SuppressWarnings("unchecked")
    List<String> list = session.createNativeQuery(sqlQuery).getResultList();
    for (String categIDString : list) {
        log.add("parentID is null for category " + new MCRCategoryID(clreplacedID, categIDString));
    }
}

17 View Complete Implementation : SessionFactoryFactoryTest.java
Copyright Apache License 2.0
Author : dropwizard
@Test
public void buildsAWorkingSessionFactory() throws Exception {
    build();
    try (Session session = requireNonNull(sessionFactory).openSession()) {
        Transaction transaction = session.beginTransaction();
        session.createNativeQuery("DROP TABLE people IF EXISTS").executeUpdate();
        session.createNativeQuery("CREATE TABLE people (name varchar(100) primary key, email varchar(100), birthday timestamp(0))").executeUpdate();
        session.createNativeQuery("INSERT INTO people VALUES ('Coda', '[email protected]', '1979-01-02 00:22:00')").executeUpdate();
        transaction.commit();
        final Person enreplacedy = session.get(Person.clreplaced, "Coda");
        replacedertThat(enreplacedy.getName()).isEqualTo("Coda");
        replacedertThat(enreplacedy.getEmail()).isEqualTo("[email protected]");
        replacedertThat(requireNonNull(enreplacedy.getBirthday()).toDateTime(DateTimeZone.UTC)).isEqualTo(new DateTime(1979, 1, 2, 0, 22, DateTimeZone.UTC));
    }
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_query_scalar_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-all-columns-scalar-query-example[]
        List<Object[]> persons = session.createNativeQuery("SELECT * FROM Person").list();
        // end::sql-hibernate-all-columns-scalar-query-example[]
        replacedertEquals(3, persons.size());
    });
}

17 View Complete Implementation : GreetingController.java
Copyright GNU General Public License v2.0
Author : ron190
@RequestMapping("/greeting-time")
public Greeting greetingTime(@RequestParam(value = "name", defaultValue = "World") String name) throws IOException {
    Session session = this.sessionFactory.getCurrentSession();
    name = name.replace(":", "\\:");
    Query q = session.createNativeQuery("select First_Name from Student where '1' = '" + name + "'");
    Greeting greeting = null;
    try {
        q.getResultList();
    } catch (Exception e) {
    // Hide useless SQL error messages
    } finally {
        session.close();
    }
    return greeting;
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_query_scalar_partial_explicit_result_set_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-scalar-query-partial-explicit-result-set-example[]
        List<Object[]> persons = session.createNativeQuery("SELECT * FROM Person").addScalar("id", LongType.INSTANCE).addScalar("name").list();
        for (Object[] person : persons) {
            Long id = (Long) person[0];
            String name = (String) person[1];
        }
        // end::sql-hibernate-scalar-query-partial-explicit-result-set-example[]
        replacedertEquals(3, persons.size());
    });
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_enreplacedy_query_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-enreplacedy-query-example[]
        List<Person> persons = session.createNativeQuery("SELECT * FROM Person").addEnreplacedy(Person.clreplaced).list();
        // end::sql-hibernate-enreplacedy-query-example[]
        replacedertEquals(3, persons.size());
    });
}

17 View Complete Implementation : ReadPreferencePropagationTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void shouldApplyReadPreferenceWhenExecutingBackendQuery() {
    // given
    MockMongoClientBuilder.MockMongoClient mockClient = mockClient().insert("GolfPlayer", getPlayer()).build();
    setupSessionFactory(new MongoDBDatastoreProvider(mockClient.getClient()));
    Session session = sessions.openSession();
    String nativeQuery = "db.GolfPlayer" + ".findAndModify({ 'query': {'_id': 1}, 'update': { '$set': { 'name': 'Ben' } }, 'new': true })";
    // when
    NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(GolfPlayer.clreplaced);
    @SuppressWarnings("unchecked")
    List<GolfPlayer> result = query.list();
    // then
    replacedertThat(result).hreplacedize(1);
    verify(mockClient.getClient().getDatabase("db").getCollection("GolfPlayer")).withReadPreference(eq(ReadPreference.secondaryPreferred()));
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_custom_column_selection_scalar_query_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-custom-column-selection-scalar-query-example[]
        List<Object[]> persons = session.createNativeQuery("SELECT id, name FROM Person").list();
        for (Object[] person : persons) {
            Number id = (Number) person[0];
            String name = (String) person[1];
        }
        // end::sql-hibernate-custom-column-selection-scalar-query-example[]
        replacedertEquals(3, persons.size());
    });
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_enreplacedy_replacedociations_query_many_to_one_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-enreplacedy-replacedociations-query-many-to-one-example[]
        List<Phone> phones = session.createNativeQuery("SELECT id, phone_number, phone_type, person_id " + "FROM Phone").addEnreplacedy(Phone.clreplaced).list();
        // end::sql-hibernate-enreplacedy-replacedociations-query-many-to-one-example[]
        replacedertEquals(3, phones.size());
    });
}

17 View Complete Implementation : Neo4jSessionNativeQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@After
public void deleteAll() {
    Session session = openSession();
    Transaction tx = session.beginTransaction();
    session.createNativeQuery("MATCH (n) DETACH DELETE n").executeUpdate();
    tx.commit();
    session.clear();
    session.close();
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_enreplacedy_query_explicit_result_set_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-enreplacedy-query-explicit-result-set-example[]
        List<Person> persons = session.createNativeQuery("SELECT id, name, nickName, address, createdOn, version " + "FROM Person").addEnreplacedy(Person.clreplaced).list();
        // end::sql-hibernate-enreplacedy-query-explicit-result-set-example[]
        replacedertEquals(3, persons.size());
    });
}

17 View Complete Implementation : MCRClassification2Commands.java
Copyright GNU General Public License v3.0
Author : MyCoRe-Org
private static void checkEmptyLabels(String clreplacedID, List<String> log) {
    Session session = MCRHIBConnection.instance().getSession();
    String sqlQuery = "select cat.categid from {h-schema}MCRCategory cat " + "left outer join {h-schema}MCRCategoryLabels label on cat.internalid = label.category where " + "cat.clreplacedid='" + clreplacedID + "' and (label.text is null or trim(label.text) = '')";
    @SuppressWarnings("unchecked")
    List<String> list = session.createNativeQuery(sqlQuery).getResultList();
    for (String categIDString : list) {
        log.add("EMPTY lables for category " + new MCRCategoryID(clreplacedID, categIDString));
    }
}

17 View Complete Implementation : GreetingController.java
Copyright GNU General Public License v2.0
Author : ron190
@RequestMapping("/greeting-error")
public Greeting greetingError(@RequestParam(value = "name", defaultValue = "World") String name) throws IOException {
    Session session = this.sessionFactory.getCurrentSession();
    name = name.replace(":", "\\:");
    Query q = session.createNativeQuery("select First_Name from Student where '1' = '" + name + "'");
    Greeting greeting = null;
    try {
        q.getResultList();
    } catch (Exception e) {
        String stacktrace = ExceptionUtils.getStackTrace(e);
        LOGGER.debug(stacktrace);
        greeting = new Greeting(this.counter.incrementAndGet(), String.format(template + "#", name) + StringEscapeUtils.unescapeJava(stacktrace));
    } finally {
        session.close();
    }
    return greeting;
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_multi_enreplacedy_query_alias_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-multi-enreplacedy-query-alias-example[]
        List<Object> enreplacedies = session.createNativeQuery("SELECT {pr.*}, {pt.*} " + "FROM Person pr, Partner pt " + "WHERE pr.name = pt.name").addEnreplacedy("pr", Person.clreplaced).addEnreplacedy("pt", Partner.clreplaced).list();
        // end::sql-hibernate-multi-enreplacedy-query-alias-example[]
        replacedertEquals(1, enreplacedies.size());
    });
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_enreplacedy_replacedociations_query_many_to_one_join_result_transformer_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-enreplacedy-replacedociations-query-many-to-one-join-result-transformer-example[]
        List<Person> persons = session.createNativeQuery("SELECT pr.*, ph.phone_number ,ph.person_id , ph.phone_type " + "FROM Phone ph " + "JOIN Person pr ON ph.person_id = pr.id").addEnreplacedy("phone", Phone.clreplaced).addJoin("pr", "phone.person").setResultTransformer(Criteria.ROOT_ENreplacedY).list();
        for (Person person : persons) {
            person.getPhones();
        }
        // end::sql-hibernate-enreplacedy-replacedociations-query-many-to-one-join-result-transformer-example[]
        replacedertEquals(3, persons.size());
    });
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_enreplacedy_replacedociations_query_one_to_many_join_example_1() {
    try {
        doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
            Session session = enreplacedyManager.unwrap(Session.clreplaced);
            List<Phone> phones = session.createNativeQuery("SELECT * " + "FROM Phone ph " + "JOIN phone_call c ON c.phone_id = ph.id").addEnreplacedy("phone", Phone.clreplaced).addJoin("c", "phone.calls").setResultTransformer(Criteria.DISTINCT_ROOT_ENreplacedY).list();
            for (Phone phone : phones) {
                List<Call> calls = phone.getCalls();
            }
            replacedertEquals(2, phones.size());
        });
    } catch (Exception e) {
        log.error("HHH-10504", e);
    // See issue https://hibernate.atlreplacedian.net/browse/HHH-10504
    }
}

17 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_multi_enreplacedy_query_example() {
    try {
        doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
            Session session = enreplacedyManager.unwrap(Session.clreplaced);
            // tag::sql-hibernate-multi-enreplacedy-query-example[]
            List<Object> enreplacedies = session.createNativeQuery("SELECT * " + "FROM Person pr, Partner pt " + "WHERE pr.name = pt.name").list();
            // end::sql-hibernate-multi-enreplacedy-query-example[]
            replacedertEquals(2, enreplacedies.size());
        });
        fail("Should throw NonUniqueDiscoveredSqlAliasException!");
    } catch (NonUniqueDiscoveredSqlAliasException e) {
    // expected
    } catch (PersistenceException e) {
        replacedertTyping(NonUniqueDiscoveredSqlAliasException.clreplaced, e.getCause());
    }
}

16 View Complete Implementation : MongoDBPaginationWithAggregateTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@SuppressWarnings("unchecked")
protected List<Poem> findPoemsSortedAlphabetically(Session session, int startPosition, int maxResult) {
    List<Poem> result = session.createNativeQuery(NATIVE_QUERY).addEnreplacedy(Poem.TABLE_NAME, Poem.clreplaced).setFirstResult(startPosition).setMaxResults(maxResult).list();
    return result;
}

16 View Complete Implementation : Neo4jPaginationWithCypherTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@SuppressWarnings("unchecked")
protected List<Poem> findPoemsSortedAlphabetically(Session session, int startPosition, int maxResult) {
    List<Poem> result = session.createNativeQuery(CYPHER_QUERY).addEnreplacedy(Poem.TABLE_NAME, Poem.clreplaced).setFirstResult(startPosition).setMaxResults(maxResult).list();
    return result;
}

16 View Complete Implementation : MCRClassification2Commands.java
Copyright GNU General Public License v3.0
Author : MyCoRe-Org
@MCRCommand(syntax = "repair position in parent", help = "fixes all categories gaps in position in parent", order = 120)
@SuppressWarnings("unchecked")
public static void repairPositionInParent() {
    Session session = MCRHIBConnection.instance().getSession();
    // this SQL-query find missing numbers in positioninparent
    String sqlQuery = "select parentid, min(cat1.positioninparent+1) from {h-schema}MCRCategory cat1 " + "where cat1.parentid is not null and not exists" + "(select 1 from {h-schema}MCRCategory cat2 " + "where cat2.parentid=cat1.parentid and cat2.positioninparent=(cat1.positioninparent+1))" + "and cat1.positioninparent not in " + "(select max(cat3.positioninparent) from {h-schema}MCRCategory cat3 " + "where cat3.parentid=cat1.parentid) group by cat1.parentid";
    for (List<Object[]> parentWithErrorsList = session.createNativeQuery(sqlQuery).getResultList(); !parentWithErrorsList.isEmpty(); parentWithErrorsList = session.createNativeQuery(sqlQuery).getResultList()) {
        for (Object[] parentWithErrors : parentWithErrorsList) {
            Number parentID = (Number) parentWithErrors[0];
            Number firstErrorPositionInParent = (Number) parentWithErrors[1];
            LOGGER.info("Category {} has the missing position {} ...", parentID, firstErrorPositionInParent);
            repairCategoryWithGapInPos(parentID, firstErrorPositionInParent);
            LOGGER.info("Fixed position {} for category {}.", firstErrorPositionInParent, parentID);
        }
    }
    sqlQuery = "select parentid, min(cat1.positioninparent-1) from {h-schema}MCRCategory cat1 " + "where cat1.parentid is not null and not exists" + "(select 1 from {h-schema}MCRCategory cat2 " + "where cat2.parentid=cat1.parentid and cat2.positioninparent=(cat1.positioninparent-1))" + "and cat1.positioninparent not in " + "(select max(cat3.positioninparent) from {h-schema}MCRCategory cat3 " + "where cat3.parentid=cat1.parentid) and cat1.positioninparent > 0 group by cat1.parentid";
    while (true) {
        List<Object[]> parentWithErrorsList = session.createNativeQuery(sqlQuery).getResultList();
        if (parentWithErrorsList.isEmpty()) {
            break;
        }
        for (Object[] parentWithErrors : parentWithErrorsList) {
            Number parentID = (Number) parentWithErrors[0];
            Number wrongStartPositionInParent = (Number) parentWithErrors[1];
            LOGGER.info("Category {} has the the starting position {} ...", parentID, wrongStartPositionInParent);
            repairCategoryWithWrongStartPos(parentID, wrongStartPositionInParent);
            LOGGER.info("Fixed position {} for category {}.", wrongStartPositionInParent, parentID);
        }
    }
    LOGGER.info("Repair position in parent finished!");
}

16 View Complete Implementation : GreetingController.java
Copyright GNU General Public License v2.0
Author : ron190
@SuppressWarnings("unchecked")
@RequestMapping("/greeting-cookie")
public Greeting greetingCookie(HttpServletRequest request, @CookieValue("name") String name) throws IOException {
    Session session = this.sessionFactory.getCurrentSession();
    Greeting greeting = null;
    try {
        name = name.replace(":", "\\:");
        Query q = session.createNativeQuery("select First_Name from Student where '1' = '" + name + "'");
        List<Object[]> results = q.getResultList();
        greeting = new Greeting(this.counter.incrementAndGet(), String.format(template, name) + StringEscapeUtils.unescapeJava(this.objectMapper.writeValuereplacedtring(results)));
    } catch (Exception e) {
    // Hide useless SQL error messages
    } finally {
        session.close();
    }
    return greeting;
}

16 View Complete Implementation : InfinispanRemotePaginationTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Override
protected List<Poem> findPoemsSortedAlphabetically(Session session, int startPosition, int maxResult) {
    List<Poem> result = session.createNativeQuery(NATIVE_QUERY).addEnreplacedy(Poem.TABLE_NAME, Poem.clreplaced).setFirstResult(startPosition).setMaxResults(maxResult).list();
    return result;
}

16 View Complete Implementation : AbsSupportDao.java
Copyright MIT License
Author : aiyoyoyo
@Override
@SuppressWarnings("unchecked")
public <T> List<T> selectBySQL(String _db, String _sql, int _first, int _limit, String[] _param, Object[] _value, Clreplaced<T> _cls) {
    Session session = _get_session(_db);
    Query<T> query = session.createNativeQuery(_sql, _cls);
    query.setFirstResult(_first);
    query.setMaxResults(_limit);
    _set_parameter(query, _param, _value);
    return query.getResultList();
}

16 View Complete Implementation : Wikipedia.java
Copyright Apache License 2.0
Author : dkpro
/**
 * Tests, whether a page with the given pageID exists.
 * Trying to retrieve a pageID that does not exist in Wikipedia throws an exception.
 *
 * @param pageID A pageID.
 * @return {@code True}, if a page with that pageID exits, {@code false} otherwise.
 */
public boolean existsPage(int pageID) {
    // This is a hack to provide a much quicker way to test whether a page exists.
    // Encoding the replacedle in this way surpreplacedes the normal way of creating a replacedle first.
    // Anyway, I do not like this hack :-|
    if (pageID < 0) {
        return false;
    }
    Session session = this.__getHibernateSession();
    session.beginTransaction();
    List returnList = session.createNativeQuery("select p.id from PageMapLine as p where p.pageID = :pageId").setParameter("pageId", pageID, IntegerType.INSTANCE).list();
    session.getTransaction().commit();
    return returnList.size() != 0;
}

16 View Complete Implementation : Wikipedia.java
Copyright Apache License 2.0
Author : dkpro
/**
 * Gets the replacedle for a given pageId.
 *
 * @param pageId The id of the page.
 * @return The replacedle for the given pageId.
 * @throws WikiApiException Thrown if errors occurred.
 */
public replacedle getreplacedle(int pageId) throws WikiApiException {
    Session session = this.__getHibernateSession();
    session.beginTransaction();
    Object returnValue = session.createNativeQuery("select p.name from PageMapLine as p where p.pageId= :pId").setParameter("pId", pageId, IntegerType.INSTANCE).uniqueResult();
    session.getTransaction().commit();
    String replacedle = (String) returnValue;
    if (replacedle == null) {
        throw new WikiPageNotFoundException();
    }
    return new replacedle(replacedle);
}

16 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
/**
 * This test cannot run for Spanner. It attempts to map both person and phone
 * from single row but they have overlapping column names.
 *
 * The previous driver worked but it had a BUG that reused the same column for both cases.
 */
@Test
@Ignore
public void test_sql_hibernate_enreplacedy_replacedociations_query_many_to_one_join_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-enreplacedy-replacedociations-query-many-to-one-join-example[]
        List<Object[]> tuples = session.createNativeQuery("SELECT * " + "FROM Phone ph " + "JOIN Person pr ON ph.person_id = pr.id").addEnreplacedy("phone", Phone.clreplaced).addJoin("pr", "phone.person").list();
        for (Object[] tuple : tuples) {
            Phone phone = (Phone) tuple[0];
            Person person = (Person) tuple[1];
            replacedertNotNull(person.getName());
        }
        // end::sql-hibernate-enreplacedy-replacedociations-query-many-to-one-join-example[]
        replacedertEquals(3, tuples.size());
    });
}

16 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
/**
 * This test cannot run for Spanner. It attempts to map both person and payment
 * from single row but they have overlapping column names.
 *
 * The previous driver worked but it had a BUG that reused the same column for both cases.
 */
@Test
@Ignore
public void test_sql_hibernate_inheritance_query_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-inheritance-query-example[]
        List<CreditCardPayment> payments = session.createNativeQuery("SELECT cp.*, p.amount, p.completed , p.person_id " + "FROM Payment p " + "JOIN CreditCardPayment cp on cp.id = p.id").addEnreplacedy(CreditCardPayment.clreplaced).list();
        // end::sql-hibernate-inheritance-query-example[]
        replacedertEquals(1, payments.size());
    });
}

16 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_query_scalar_explicit_result_set_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-scalar-query-explicit-result-set-example[]
        List<Object[]> persons = session.createNativeQuery("SELECT * FROM Person").addScalar("id", LongType.INSTANCE).addScalar("name", StringType.INSTANCE).list();
        for (Object[] person : persons) {
            Long id = (Long) person[0];
            String name = (String) person[1];
        }
        // end::sql-hibernate-scalar-query-explicit-result-set-example[]
        replacedertEquals(3, persons.size());
    });
}

16 View Complete Implementation : SQLTest.java
Copyright GNU Lesser General Public License v2.1
Author : GoogleCloudPlatform
@Test
public void test_sql_hibernate_dto_query_example() {
    doInJPA(this::enreplacedyManagerFactory, enreplacedyManager -> {
        Session session = enreplacedyManager.unwrap(Session.clreplaced);
        // tag::sql-hibernate-dto-query-example[]
        List<PersonSummaryDTO> dtos = session.createNativeQuery("SELECT p.id as id, p.name as name " + "FROM Person p").setResultTransformer(Transformers.aliasToBean(PersonSummaryDTO.clreplaced)).list();
        // end::sql-hibernate-dto-query-example[]
        replacedertEquals(3, dtos.size());
    });
}

15 View Complete Implementation : Wikipedia.java
Copyright Apache License 2.0
Author : dkpro
/**
 * Tests, whether a page or redirect with the given replacedle exists.
 * Trying to retrieve a page that does not exist in Wikipedia throws an exception.
 * You may catch the exception or use this test, depending on your task.
 * @param replacedle The replacedle of the page.
 * @return {@code True}, if a page or redirect with that replacedle exits, {@code false} otherwise.
 */
public boolean existsPage(String replacedle) {
    if (replacedle == null || replacedle.length() == 0) {
        return false;
    }
    replacedle t;
    try {
        t = new replacedle(replacedle);
    } catch (WikireplacedleParsingException e) {
        return false;
    }
    String encodedreplacedle = t.getWikiStylereplacedle();
    Session session = this.__getHibernateSession();
    session.beginTransaction();
    String query = "select p.id from PageMapLine as p where p.name = :pName";
    if (dbConfig.supportsCollation()) {
        query += SQL_COLLATION;
    }
    Object returnValue = session.createNativeQuery(query).setParameter("pName", encodedreplacedle, StringType.INSTANCE).uniqueResult();
    session.getTransaction().commit();
    return returnValue != null;
}

15 View Complete Implementation : SessionFactoryHealthCheckTest.java
Copyright Apache License 2.0
Author : dropwizard
@Test
public void isUnhealthyIfAnExceptionIsThrown() throws Exception {
    final Session session = mock(Session.clreplaced);
    when(factory.openSession()).thenReturn(session);
    final Transaction transaction = mock(Transaction.clreplaced);
    when(session.beginTransaction()).thenReturn(transaction);
    when(transaction.getStatus()).thenReturn(ACTIVE);
    final NativeQuery<?> query = mock(NativeQuery.clreplaced);
    when(session.createNativeQuery(anyString())).thenReturn(query);
    when(query.list()).thenThrow(new HibernateException("OH NOE"));
    replacedertThat(healthCheck("SELECT 1").execute().isHealthy()).isFalse();
    final InOrder inOrder = inOrder(factory, session, transaction, query);
    inOrder.verify(factory).openSession();
    inOrder.verify(session).beginTransaction();
    inOrder.verify(session).createNativeQuery("SELECT 1");
    inOrder.verify(query).list();
    inOrder.verify(transaction).rollback();
    inOrder.verify(session).close();
    verify(transaction, never()).commit();
}

15 View Complete Implementation : SessionFactoryHealthCheckTest.java
Copyright Apache License 2.0
Author : dropwizard
@Test
public void isHealthyIfNoExceptionIsThrown() throws Exception {
    final Session session = mock(Session.clreplaced);
    when(factory.openSession()).thenReturn(session);
    final Transaction transaction = mock(Transaction.clreplaced);
    when(session.beginTransaction()).thenReturn(transaction);
    final NativeQuery<?> query = mock(NativeQuery.clreplaced);
    when(session.createNativeQuery(anyString())).thenReturn(query);
    replacedertThat(healthCheck("SELECT 1").execute().isHealthy()).isTrue();
    final InOrder inOrder = inOrder(factory, session, transaction, query);
    inOrder.verify(factory).openSession();
    inOrder.verify(session).beginTransaction();
    inOrder.verify(session).createNativeQuery("SELECT 1");
    inOrder.verify(query).list();
    inOrder.verify(transaction).commit();
    inOrder.verify(session).close();
}

15 View Complete Implementation : GreetingController.java
Copyright GNU General Public License v2.0
Author : ron190
@SuppressWarnings("unchecked")
@RequestMapping(method = { RequestMethod.GET, RequestMethod.POST }, path = "/greeting-post", consumes = { MediaType.APPLICATION_FORM_URLENCODED_VALUE, MediaType.TEXT_PLAIN_VALUE })
public Greeting greetingPost(HttpServletRequest a) throws IOException {
    Session session = this.sessionFactory.getCurrentSession();
    Greeting greeting = null;
    try {
        String name = a.getParameterMap().get("name")[0];
        name = name.replace(":", "\\:");
        Query q = session.createNativeQuery("select First_Name from Student where '1' = '" + name + "'");
        List<Object[]> results = q.getResultList();
        greeting = new Greeting(this.counter.incrementAndGet(), String.format(template, name) + StringEscapeUtils.unescapeJava(this.objectMapper.writeValuereplacedtring(results)));
    } catch (Exception e) {
    // Hide useless SQL error messages
    } finally {
        session.close();
    }
    return greeting;
}

15 View Complete Implementation : GreetingController.java
Copyright GNU General Public License v2.0
Author : ron190
@SuppressWarnings("unchecked")
@RequestMapping("/greeting-header")
public Greeting greetingHeader(@RequestHeader Map<String, String> a) throws IOException {
    Session session = this.sessionFactory.getCurrentSession();
    Greeting greeting = null;
    try {
        String name = a.get("name");
        name = name.replace(":", "\\:");
        Query q = session.createNativeQuery("select First_Name from Student where '1' = '" + name + "'");
        List<Object[]> results = q.getResultList();
        greeting = new Greeting(this.counter.incrementAndGet(), String.format(template, name) + StringEscapeUtils.unescapeJava(this.objectMapper.writeValuereplacedtring(results)));
    } catch (Exception e) {
    // Hide useless SQL error messages
    } finally {
        session.close();
    }
    return greeting;
}

15 View Complete Implementation : GreetingController.java
Copyright GNU General Public License v2.0
Author : ron190
@SuppressWarnings("unchecked")
@RequestMapping("/greeting")
public Greeting greeting(@RequestParam(value = "name", defaultValue = "World") String name) throws IOException {
    Session session = this.sessionFactory.getCurrentSession();
    name = name.replace(":", "\\:");
    Query q = session.createNativeQuery("select First_Name from Student where '1' = '" + name + "'");
    Greeting greeting = null;
    try {
        List<Object[]> results = q.getResultList();
        greeting = new Greeting(this.counter.incrementAndGet(), String.format(template, name) + StringEscapeUtils.unescapeJava(this.objectMapper.writeValuereplacedtring(results)));
    } catch (Exception e) {
    // Hide useless SQL error messages
    } finally {
        session.close();
    }
    return greeting;
}

15 View Complete Implementation : GreetingController.java
Copyright GNU General Public License v2.0
Author : ron190
@SuppressWarnings("unchecked")
@RequestMapping("/greeting-json")
public Greeting greetingJson(@RequestParam(value = "name", defaultValue = "World") String name) throws IOException {
    Session session = this.sessionFactory.getCurrentSession();
    Greeting greeting = null;
    try {
        name = name.replaceAll("\\\\:", ":");
        String j = new JSONObject(name).getJSONObject("b").getJSONArray("b").getJSONObject(2).getJSONObject("a").getString("a");
        j = j.replaceAll(":", "\\\\:");
        String a = j;
        a = a.replace(":", "\\:");
        Query q = session.createNativeQuery("select First_Name from Student where '1' = '" + a + "'");
        List<Object[]> results = q.getResultList();
        greeting = new Greeting(this.counter.incrementAndGet(), String.format(template, name) + StringEscapeUtils.unescapeJava(this.objectMapper.writeValuereplacedtring(results)));
    } catch (Exception e) {
    // Hide useless SQL error messages
    } finally {
        session.close();
    }
    return greeting;
}

14 View Complete Implementation : Category.java
Copyright Apache License 2.0
Author : dkpro
/**
 * This is a more efficient shortcut for writing "getChildren().size()", as that would require to load all the children first.
 * @return The number of children of this category.
 */
public int getNumberOfChildren() {
    BigInteger nrOfOutlinks = new BigInteger("0");
    long id = this.__getId();
    Session session = this.wiki.__getHibernateSession();
    session.beginTransaction();
    Object returnValue = session.createNativeQuery("select count(outLinks) from category_outlinks where id = :id").setParameter("id", id, LongType.INSTANCE).uniqueResult();
    session.getTransaction().commit();
    if (returnValue != null) {
        nrOfOutlinks = (BigInteger) returnValue;
    }
    return nrOfOutlinks.intValue();
}

14 View Complete Implementation : Category.java
Copyright Apache License 2.0
Author : dkpro
/**
 * This is a more efficient shortcut for writing "getParents().size()", as that would require to load all the parents first.
 * @return The number of parents of this category.
 */
public int getNumberOfParents() {
    BigInteger nrOfInlinks = new BigInteger("0");
    long id = this.__getId();
    Session session = this.wiki.__getHibernateSession();
    session.beginTransaction();
    Object returnValue = session.createNativeQuery("select count(inLinks) from category_inlinks where id = :id").setParameter("id", id, LongType.INSTANCE).uniqueResult();
    session.getTransaction().commit();
    if (returnValue != null) {
        nrOfInlinks = (BigInteger) returnValue;
    }
    return nrOfInlinks.intValue();
}

14 View Complete Implementation : Category.java
Copyright Apache License 2.0
Author : dkpro
/**
 * This is a more efficient shortcut for writing "getPages().size()", as that would require to load all the pages first.
 * @return The number of pages.
 */
public int getNumberOfPages() {
    BigInteger nrOfPages = new BigInteger("0");
    long id = this.__getId();
    Session session = this.wiki.__getHibernateSession();
    session.beginTransaction();
    Object returnValue = session.createNativeQuery("select count(pages) from category_pages where id = :id").setParameter("id", id, LongType.INSTANCE).uniqueResult();
    session.getTransaction().commit();
    if (returnValue != null) {
        nrOfPages = (BigInteger) returnValue;
    }
    return nrOfPages.intValue();
}

14 View Complete Implementation : Page.java
Copyright Apache License 2.0
Author : dkpro
/**
 * This is a more efficient shortcut for writing {@link Page#getOutlinks()}.size(), as that would require
 * to load all the outlinks first.
 *
 * @return The number of outlinks.
 */
public int getNumberOfOutlinks() {
    BigInteger nrOfOutlinks = new BigInteger("0");
    long id = __getId();
    Session session = wiki.__getHibernateSession();
    session.beginTransaction();
    Object returnValue = session.createNativeQuery("select count(outLinks) from page_outlinks where id = :id").setParameter("id", id, LongType.INSTANCE).uniqueResult();
    session.getTransaction().commit();
    if (returnValue != null) {
        nrOfOutlinks = (BigInteger) returnValue;
    }
    return nrOfOutlinks.intValue();
}

14 View Complete Implementation : Page.java
Copyright Apache License 2.0
Author : dkpro
/**
 * This is a more efficient shortcut for writing {@link Page#getInlinks()}.size(), as that would require to
 * load all the inlinks first.
 *
 * @return The number of inlinks.
 */
public int getNumberOfInlinks() {
    BigInteger nrOfInlinks = new BigInteger("0");
    long id = __getId();
    Session session = wiki.__getHibernateSession();
    session.beginTransaction();
    Object returnValue = session.createNativeQuery("select count(pi.inLinks) from page_inlinks as pi where pi.id = :piid").setParameter("piid", id, LongType.INSTANCE).uniqueResult();
    session.getTransaction().commit();
    if (returnValue != null) {
        nrOfInlinks = (BigInteger) returnValue;
    }
    return nrOfInlinks.intValue();
}

14 View Complete Implementation : Page.java
Copyright Apache License 2.0
Author : dkpro
/**
 * This is a more efficient shortcut for writing {@link Page#getCategories()}.size, as that would require
 * to load all the categories first.
 *
 * @return The number of categories.
 */
public int getNumberOfCategories() {
    BigInteger nrOfCategories = new BigInteger("0");
    long id = __getId();
    Session session = wiki.__getHibernateSession();
    session.beginTransaction();
    Object returnValue = session.createNativeQuery("select count(pages) from page_categories where id = :pageid").setParameter("pageid", id, LongType.INSTANCE).uniqueResult();
    session.getTransaction().commit();
    if (returnValue != null) {
        nrOfCategories = (BigInteger) returnValue;
    }
    return nrOfCategories.intValue();
}

14 View Complete Implementation : SessionFactoryHealthCheck.java
Copyright Apache License 2.0
Author : dropwizard
@Override
protected Result check() throws Exception {
    return timeBoundHealthCheck.check(() -> {
        HealthCheck.Result result = Result.healthy();
        try (Session session = sessionFactory.openSession()) {
            final Transaction txn = session.beginTransaction();
            try {
                if (validationQuery.isPresent()) {
                    session.createNativeQuery(validationQuery.get()).list();
                } else if (!isValidConnection(session)) {
                    result = Result.unhealthy("Connection::isValid returned false.");
                }
                txn.commit();
            } catch (Exception e) {
                if (txn.getStatus().canRollback()) {
                    txn.rollback();
                }
                throw e;
            }
        }
        return result;
    });
}