thjanssen · May 21, 2017 16:57
diff --git a/CallAdHocStoredProcedureQuery.java b/CallAdHocStoredProcedureQuery.java
 StoredProcedureQuery query = this.em.createStoredProcedureQuery("get_reviews", Review.class);
 query.registerStoredProcedureParameter(1, void.class, ParameterMode.REF_CURSOR);
 query.registerStoredProcedureParameter(2, Long.class, ParameterMode.IN);

 query.setParameter(2, b.getId());
 List<Review> reviews = query.getResultList();
diff --git a/CallNamedStoredProcedureQuery.java b/CallNamedStoredProcedureQuery.java
 StoredProcedureQuery q = this.em.createNamedStoredProcedureQuery("getReviews");
 q.setParameter(2, b.getId());
 List<Review> reviews = q.getResultList();
diff --git a/CreateSequence.sql b/CreateSequence.sql
 CREATE SEQUENCE book_seq;
diff --git a/NamedNativeQuery.java b/NamedNativeQuery.java
 @NamedNativeQuery(name = "selectAuthorNames", query = "SELECT a.firstname, a.lastname FROM Author a")
	StoredProcedureQuery query = this.em.createStoredProcedureQuery("get_reviews", Review.class);
	query.registerStoredProcedureParameter(1, void.class, ParameterMode.REF_CURSOR);
	query.registerStoredProcedureParameter(2, Long.class, ParameterMode.IN);

	query.setParameter(2, b.getId());
	List<Review> reviews = query.getResultList();
	StoredProcedureQuery q = this.em.createNamedStoredProcedureQuery("getReviews");
	q.setParameter(2, b.getId());
	List<Review> reviews = q.getResultList();