Examples of registerStoredProcedureParameter()

Examples of javax.persistence.StoredProcedureQuery.registerStoredProcedureParameter()

34
35
36
37
38
39
40
41
42
43
44
  @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);
View Full Code Here

Examples of javax.persistence.StoredProcedureQuery.registerStoredProcedureParameter()

35
36
37
38
39
40
41
42
43
44
45
  @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.registerStoredProcedureParameter()

135
136
137
138
139
140
141
142
143
144
145
      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);
      }
    }
View Full Code Here

Examples of javax.persistence.StoredProcedureQuery.registerStoredProcedureParameter()

137
138
139
140
141
142
143
144
145
146
147
      }

      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,
View Full Code Here

Examples of javax.persistence.StoredProcedureQuery.registerStoredProcedureParameter()

142
143
144
145
146
147
148
149
150
151
152
        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.registerStoredProcedureParameter()

91
92
93
94
95
96
97
98
99
100
101
  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();
View Full Code Here

Examples of javax.persistence.StoredProcedureQuery.registerStoredProcedureParameter()

92
93
94
95
96
97
98
99
100
101
102
    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
TOP
Copyright © 2018 www.massapi.com. 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.