Examples of JPQLStatement

it.eng.qbe.statement.jpa.JPQLStatement
@author Andrea Gioia (andrea.gioia@eng.it)
org.apache.olingo.odata2.jpa.processor.api.jpql.JPQLStatement
The class represents a Java Persistence Query Language (JPQL) Statement. The JPQL statement is built using a builder namely {@link org.apache.olingo.odata2.jpa.processor.api.jpql.JPQLStatement.JPQLStatementBuilder} . Based upon the JPQLContext types ( {@link org.apache.olingo.odata2.jpa.processor.api.jpql.JPQLContextType} differentkinds of JPQL statements are built. The JPQL statements thus generated can be executed using JPA Query APIs to fetch JPA entities. @see org.apache.olingo.odata2.jpa.processor.api.factory.JPQLBuilderFactory @see org.apache.olingo.odata2.jpa.processor.api.jpql.JPQLContextView
org.apache.olingo.odata2.processor.api.jpa.jpql.JPQLStatement
The class represents a Java Persistence Query Language (JPQL) Statement. The JPQL statement is built using a builder namely {@link org.apache.olingo.odata2.processor.api.jpa.jpql.JPQLStatement.JPQLStatementBuilder} . Based upon the JPQLContext types ( {@link org.apache.olingo.odata2.processor.api.jpa.jpql.JPQLContextType} differentkinds of JPQL statements are built. The JPQL statements thus generated can be executed using JPA Query APIs to fetch JPA entities. @see org.apache.olingo.odata2.processor.api.jpa.factory.JPQLBuilderFactory @see org.apache.olingo.odata2.processor.api.jpa.jpql.JPQLContextView

Examples of org.apache.olingo.odata2.jpa.processor.api.jpql.JPQLStatement

    }


    JPQLContext jpqlContext = JPQLContext.createBuilder(contextType,
        resultsView).build();


    JPQLStatement jpqlStatement = JPQLStatement.createBuilder(jpqlContext)
        .build();
    Query query = null;
    try {


      query = em.createQuery(jpqlStatement.toString());
      List<?> resultList = query.getResultList();
      if (resultList != null && resultList.size() == 1) {
        return Long.valueOf(resultList.get(0).toString());
      }
    } catch (IllegalArgumentException e) {

View Full Code Here

Examples of org.apache.olingo.odata2.jpa.processor.api.jpql.JPQLStatement

        || uriParserResultView instanceof PutMergePatchUriInfo) {


      JPQLContext selectJPQLContext = JPQLContext.createBuilder(
          contextType, uriParserResultView).build();


      JPQLStatement selectJPQLStatement = JPQLStatement.createBuilder(
          selectJPQLContext).build();
      Query query = null;
      try {
        query = em.createQuery(selectJPQLStatement.toString());
        if (!query.getResultList().isEmpty()) {
          selectedObject = query.getResultList().get(0);
        }
      } catch (IllegalArgumentException e) {
        throw ODataJPARuntimeException.throwException(

View Full Code Here

Examples of org.apache.olingo.odata2.jpa.processor.api.jpql.JPQLStatement

    }


    JPQLContext jpqlContext = JPQLContext.createBuilder(contextType,
        uriParserResultView).build();


    JPQLStatement jpqlStatement = JPQLStatement.createBuilder(jpqlContext)
        .build();
    Query query = null;
    try {
      query = em.createQuery(jpqlStatement.toString());
      // $top/$skip with $inlinecount case handled in response builder to avoid multiple DB call
      if (uriParserResultView.getSkip() != null && uriParserResultView.getInlineCount() == null) {
        query.setFirstResult(uriParserResultView.getSkip());
      }

View Full Code Here

Examples of org.apache.olingo.odata2.jpa.processor.api.jpql.JPQLStatement

    }


    JPQLContext jpqlContext = JPQLContext.createBuilder(contextType,
        resultsView).build();


    JPQLStatement jpqlStatement = JPQLStatement.createBuilder(jpqlContext)
        .build();
    Query query = null;
    try {


      query = em.createQuery(jpqlStatement.toString());
      List<?> resultList = query.getResultList();
      if (resultList != null && resultList.size() == 1) {
        return Long.valueOf(resultList.get(0).toString());
      }
    } catch (IllegalArgumentException e) {

View Full Code Here

Examples of org.apache.olingo.odata2.jpa.processor.api.jpql.JPQLStatement

    }


    JPQLContext jpqlContext = JPQLContext.createBuilder(contextType,
        resultsView).build();


    JPQLStatement jpqlStatement = JPQLStatement.createBuilder(jpqlContext)
        .build();
    Query query = null;
    try {


      query = em.createQuery(jpqlStatement.toString());
      List<?> resultList = query.getResultList();
      if (resultList != null && resultList.size() == 1) {
        return Long.valueOf(resultList.get(0).toString());
      }
    } catch (IllegalArgumentException e) {

View Full Code Here

Examples of org.apache.olingo.odata2.jpa.processor.api.jpql.JPQLStatement

        || uriParserResultView instanceof PutMergePatchUriInfo) {


      JPQLContext selectJPQLContext = JPQLContext.createBuilder(
          contextType, uriParserResultView).build();


      JPQLStatement selectJPQLStatement = JPQLStatement.createBuilder(
          selectJPQLContext).build();
      Query query = null;
      try {
        query = em.createQuery(selectJPQLStatement.toString());
        if (!query.getResultList().isEmpty()) {
          selectedObject = query.getResultList().get(0);
        }
      } catch (IllegalArgumentException e) {
        throw ODataJPARuntimeException.throwException(

View Full Code Here

Examples of org.apache.olingo.odata2.processor.api.jpa.jpql.JPQLStatement

  public void testBuild() throws Exception {
    setUp(getJoinClauseList());
    JPQLJoinSelectSingleStatementBuilder jpqlJoinSelectsingleStatementBuilder =
        new JPQLJoinSelectSingleStatementBuilder(context);
    try {
      JPQLStatement jpqlStatement = jpqlJoinSelectsingleStatementBuilder.build();
      assertEquals(
          "SELECT gt1 FROM SOHeader soh JOIN soh.soItem soi JOIN soi.material mat WHERE soh.soId = 1 AND " +
          "soi.shId = soh.soId AND mat.id = 'abc'",
          jpqlStatement.toString());
    } catch (ODataJPARuntimeException e) {
      fail("Should not have come here");
    }


  }

View Full Code Here

Examples of org.apache.olingo.odata2.processor.api.jpa.jpql.JPQLStatement

  @Test
  public void testBuild() throws Exception {
    setUp(getJoinClauseList());
    JPQLJoinStatementBuilder jpqlJoinStatementBuilder = new JPQLJoinStatementBuilder(context);
    try {
      JPQLStatement jpqlStatement = jpqlJoinStatementBuilder.build();
      assertEquals(
          "SELECT mat FROM SOHeader soh JOIN soh.soItem soi JOIN soi.material mat WHERE soh.buyerId = 2 AND " +
          "soh.createdBy = 'Peter' AND soi.shId = soh.soId AND mat.id = 'abc' ORDER BY mat.buyerId asc , mat.city desc",
          jpqlStatement.toString());
    } catch (ODataJPARuntimeException e) {
      fail("Should not have come here");
    }


  }

View Full Code Here

Examples of org.apache.olingo.odata2.processor.api.jpa.jpql.JPQLStatement

    }


    JPQLContext jpqlContext = JPQLContext.createBuilder(contextType,
        uriParserResultView).build();


    JPQLStatement jpqlStatement = JPQLStatement.createBuilder(jpqlContext)
        .build();
    Query query = null;
    try {
      query = em.createQuery(jpqlStatement.toString());
      // $top/$skip with $inlinecount case handled in response builder to avoid multiple DB call
      if (uriParserResultView.getSkip() != null && uriParserResultView.getInlineCount() == null) {
        query.setFirstResult(uriParserResultView.getSkip());
      }

View Full Code Here

Examples of org.apache.olingo.odata2.processor.api.jpa.jpql.JPQLStatement

    }


    JPQLContext jpqlContext = JPQLContext.createBuilder(contextType,
        resultsView).build();


    JPQLStatement jpqlStatement = JPQLStatement.createBuilder(jpqlContext)
        .build();
    Query query = null;
    try {


      query = em.createQuery(jpqlStatement.toString());
      List<?> resultList = query.getResultList();
      if (resultList != null && resultList.size() == 1) {
        return Long.valueOf(resultList.get(0).toString());
      }
    } catch (IllegalArgumentException e) {

View Full Code Here

0 1 2

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.