Appeler une procédure stockée SQL Server
Bonjour,
J'ai une procédure stocké sous sql server et je souhaite l'appeler en JAVA:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14
| StoredProcedureQuery query = sqlServerEntityManagerFactory.createNamedStoredProcedureQuery("maProcedure");
query.registerStoredProcedureParameter("param1", Integer.class, ParameterMode.IN);
query.registerStoredProcedureParameter("param2", LocalDate.class, ParameterMode.IN);
query.registerStoredProcedureParameter("param3", LocalDateTime.class, ParameterMode.IN);
query.registerStoredProcedureParameter("param4", LocalDateTime.class, ParameterMode.IN);
query.registerStoredProcedureParameter("param5", Double.class, ParameterMode.IN);
query.registerStoredProcedureParameter("param6", Double.class, ParameterMode.IN);
query.registerStoredProcedureParameter("param7", Double.class, ParameterMode.IN);
query.registerStoredProcedureParameter("param8", Double.class, ParameterMode.IN);
query.setParameter(.....);
query.execute(); |
Sauf que quand je l'appel, j'ai l'erreur suivante:
No @NamedStoredProcedureQuery was found with that name : maProcedure