Slide 47
Slide 47 text
Stored Procedures
@Entity
@NamedStoredProcedureQuery(name = "archiveOldBooks",
procedureName = "sp_archive_books",
parameters = { @StoredProcedureParameter(name = ”date",
mode = IN, type = Date.class), @StoredProcedureParameter(name =
"warehouse",
mode = IN, type = String.class)
public class Book {...}
StoredProcedureQuery query =
em.createNamedStoredProcedureQuery(“archiveOldBooks")
.setParameter(“data”, new Date())
.setParameter(“warehouse”, “1”)
.getResultList();