Hi,
looking on the net i've found the annotation @NamedStoredProcedureQuery so in my Entity i've defined
Code:
@Entity
@Table(name = "Ticket_TM")
@NamedStoredProcedureQueries(
@NamedStoredProcedureQuery(
name = "getEmp",
procedureName = "GET_EMP",
returnsResultSet = false
)
)
public class My Class implements Serializable {...}
In my service, i've defined
Code:
@Service
public class MyService implements IMyService
{
@PersistenceContext EntityManager entityManager;
@Override
@Transactional
public void callProcedure()
{
StoredProcedureQuery query = entityManager.createNamedStoredProcedureQuery("getEmp");
query.execute();
log.info("Procedure executed");
}
}
But i get the error No @NamedStoredProcedureQuery was found with that name : getEmp
JPA Call Oracle Stored Procedure
