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();

CallNamedStoredProcedureQuery.java

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

CreateSequence.sql

CREATE SEQUENCE book_seq;

NamedNativeQuery.java

@NamedNativeQuery(name = "selectAuthorNames", query = "SELECT a.firstname, a.lastname FROM Author a")