Package javax.persistence

Examples of javax.persistence.StoredProcedureQuery

33
34
35
36
37
38
39
40
41
42
43
44
45
46
  }

  @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
285
286
287
288
289
290
291
292
293
294
    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
63
64
65
66
67
68
69
70
71
   * @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
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
   *
   * @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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
  @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
109
110
111
112
113
114
115
116
117
118
119
120
  @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

Related Classes of javax.persistence.StoredProcedureQuery

  • org.agoncal.book.javaee7.chapter06.ex29.StoredProcedure29IT
  • org.springframework.data.jpa.repository.query.JpaQueryExecution$ProcedureExecution
  • org.springframework.data.jpa.repository.query.StoredProcedureJpaQuery
  • org.springframework.data.jpa.repository.UserRepositoryStoredProcedureTests
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.