Examples of StoredProcedureQuery

javax.persistence.StoredProcedureQuery
Interface used to control stored procedure query execution. @see Query @see Parameter @since Java Persistence 2.1

Examples of javax.persistence.StoredProcedureQuery

  }


  @Test @Ignore
  public void shouldCallAStoredProcedureQuery() throws Exception {


    StoredProcedureQuery query = em.createStoredProcedureQuery("sp_archive_old_books");
    query.registerStoredProcedureParameter("archiveDate", Date.class, ParameterMode.IN);
    query.registerStoredProcedureParameter("maxBookArchived", Integer.class, ParameterMode.IN);


    // Set the parameters and execute
    query.setParameter("archiveDate", new Date());
    query.setParameter("maxBookArchived", 1000);
    query.execute();
  }

View Full Code Here

Examples of javax.persistence.StoredProcedureQuery

    protected Object doExecute(AbstractJpaQuery jpaQuery, Object[] values) {


      Assert.isInstanceOf(StoredProcedureJpaQuery.class, jpaQuery);


      StoredProcedureJpaQuery storedProcedureJpaQuery = (StoredProcedureJpaQuery) jpaQuery;
      StoredProcedureQuery storedProcedure = storedProcedureJpaQuery.createQuery(values);
      storedProcedure.execute();


      return storedProcedureJpaQuery.extractOutputValue(storedProcedure);
    }

View Full Code Here

Examples of javax.persistence.StoredProcedureQuery

   * @see org.springframework.data.jpa.repository.query.AbstractJpaQuery#doCreateQuery(java.lang.Object[])
   */
  @Override
  protected StoredProcedureQuery doCreateQuery(Object[] values) {


    StoredProcedureQuery proc = createStoredProcedure();


    return createBinder(values).bind(proc);
  }

View Full Code Here

Examples of javax.persistence.StoredProcedureQuery

   * 
   * @return
   */
  private StoredProcedureQuery newAdhocStoredProcedureQuery() {


    StoredProcedureQuery procedureQuery = getEntityManager().createStoredProcedureQuery(
        procedureAttributes.getProcedureName());


    JpaParameters params = getQueryMethod().getParameters();
    for (JpaParameter param : params) {


      if (!param.isBindable()) {
        continue;
      }


      if (param.isNamedParameter()) {
        procedureQuery.registerStoredProcedureParameter(param.getName(), param.getType(), ParameterMode.IN);
      } else {
        procedureQuery.registerStoredProcedureParameter(param.getIndex() + 1, param.getType(), ParameterMode.IN);
      }
    }


    if (procedureAttributes.hasReturnValue()) {
      procedureQuery.registerStoredProcedureParameter(params.getNumberOfParameters() + 1,
          procedureAttributes.getOutputParameterType(), ParameterMode.OUT);
    }


    return procedureQuery;
  }

View Full Code Here

Examples of javax.persistence.StoredProcedureQuery

  @Ignore
  public void plainJpa21() {


    assumeTrue(currentEntityManagerIsAJpa21EntityManager(em));


    StoredProcedureQuery proc = em.createStoredProcedureQuery("plus1inout");
    proc.registerStoredProcedureParameter(1, Integer.class, ParameterMode.IN);
    proc.registerStoredProcedureParameter(2, Integer.class, ParameterMode.OUT);


    proc.setParameter(1, 1);
    proc.execute();


    assertThat(proc.getOutputParameterValue(2), is((Object) 2));
  }

View Full Code Here

Examples of javax.persistence.StoredProcedureQuery

  @Ignore
  public void plainJpa21_entityAnnotatedCustomNamedProcedurePlus1IO() {


    Assume.assumeTrue(currentEntityManagerIsAJpa21EntityManager(em));


    StoredProcedureQuery proc = em.createNamedStoredProcedureQuery("User.plus1IO");


    proc.setParameter("arg", 1);
    proc.execute();


    assertThat(proc.getOutputParameterValue("res"), is((Object) 2));
  }

View Full Code Here

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.