Examples with Query org.hibernate.query.Query used on opensource projects

Example 11 with Query

use of org.hibernate.query.Query in project hibernate-orm by hibernate.

the class LobStringTest method testUsingLobPropertyInHqlQuery.

@Test
@TestForIssue(jiraKey = "HHH-11477")
public void testUsingLobPropertyInHqlQuery() {
    TransactionUtil.doInHibernate(this::sessionFactory, session -> {
        final Query query = session.createQuery("select t.secondLobField from TestEntity t where LOWER(t.clobField) LIKE :value");
        query.setParameter("value", ClobProxy.generateProxy(value2));
        final List<String> results = query.list();
        assertThat(results.size(), is(1));
        assertThat(results.get(0), is(value2));
    });
}

Example 12 with Query

use of org.hibernate.query.Query in project hibernate-orm by hibernate.

the class LobStringTest method testSelectClobPropertyInHqlQuery.

@Test
@TestForIssue(jiraKey = "HHH-11477")
public void testSelectClobPropertyInHqlQuery() {
    TransactionUtil.doInHibernate(this::sessionFactory, session -> {
        final Query query = session.createQuery("select t.clobField from TestEntity t where LOWER(t.clobField) LIKE :value");
        query.setParameter("value", ClobProxy.generateProxy(value2));
        final List<Clob> results = query.list();
        assertThat(results.size(), is(1));
        final Clob clobField = results.get(0);
        try {
            assertThat(clobField.getSubString(1, (int) clobField.length()), is(value2));
        } catch (SQLException e) {
            fail(e.getMessage());
        }
    });
}

Example 13 with Query

use of org.hibernate.query.Query in project hibernate-orm by hibernate.

the class LobStringTest method testUsingStringLobAnnotatedPropertyInHqlQuery.

@Test
@TestForIssue(jiraKey = "HHH-11477")
public void testUsingStringLobAnnotatedPropertyInHqlQuery() {
    TransactionUtil.doInHibernate(this::sessionFactory, session -> {
        final Query query = session.createQuery("from TestEntity where LOWER(firstLobField) LIKE :value");
        query.setParameter("value", value1);
        final List<TestEntity> results = query.list();
        assertThat(results.size(), is(1));
        final TestEntity testEntity = results.get(0);
        assertThat(testEntity.getFirstLobField(), is(value1));
        assertThat(testEntity.getSecondLobField(), is(value2));
        final Clob clobField = testEntity.getClobField();
        try {
            assertThat(clobField.getSubString(1, (int) clobField.length()), is(value2));
        } catch (SQLException e) {
            fail(e.getMessage());
        }
    });
}

Example 14 with Query

use of org.hibernate.query.Query in project nikita-noark5-core by HiOA-ABI.

the class OdataTest method testOdata.

@RequestMapping(method = RequestMethod.GET, value = "arkivstruktur/{\\w*}")
public ResponseEntity<String> testOdata(final UriComponentsBuilder uriBuilder, HttpServletRequest request, final HttpServletResponse response) throws Exception {
    String uqueryString = request.getQueryString();
    String decoded = URLDecoder.decode(uqueryString, UTF_8);
    StringBuffer originalRequest = request.getRequestURL();
    originalRequest.append("?" + decoded);
    CharStream stream = CharStreams.fromString(originalRequest.toString());
    ODataLexer lexer = new ODataLexer(stream);
    CommonTokenStream tokens = new CommonTokenStream(lexer);
    ODataParser parser = new ODataParser(tokens);
    ParseTree tree = parser.odataURL();
    ParseTreeWalker walker = new ParseTreeWalker();
    // Make the HQL Statement
    NikitaODataToHQLWalker hqlWalker = new NikitaODataToHQLWalker();
    walker.walk(hqlWalker, tree);
    Session session = entityManager.unwrap(org.hibernate.Session.class);
    Query query = hqlWalker.getHqlStatment(session);
    String queryString = query.getQueryString();
    System.out.println(queryString);
    List<NoarkEntity> list = query.getResultList();
    return ResponseEntity.status(HttpStatus.CREATED).body(list.toString());
}

Example 15 with Query

use of org.hibernate.query.Query in project microservices by pwillhan.

the class App method positionalParameters.

private static Query positionalParameters(Session session) {
    Query query = session.createQuery("select t from Transaction t where t.amount > ? and t.transactionType = 'Withdrawl'");
    System.out.println("Please specify an amount:");
    Scanner scanner = new Scanner(System.in);
    query.setParameter(0, new BigDecimal(scanner.next()));
    return query;
}