Example usage for javax.persistence StoredProcedureQuery registerStoredProcedureParameter

Introduction

In this page you can find the example usage for javax.persistence StoredProcedureQuery registerStoredProcedureParameter.

Prototype

StoredProcedureQuery registerStoredProcedureParameter(String parameterName, Class type, ParameterMode mode);

Source Link

Document

Register a named parameter.

Usage

From source file:example.springdata.jpa.storedprocedures.UserRepositoryIntegrationTests.java

@Test
public void plainJpa21() {

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

    proc.setParameter(1, 1);/*w  ww.  j a va 2 s  . c o  m*/
    proc.execute();

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

---