Estou chamando uma procedure mas da erro com o nome do atributo dentro da procedure, quando chamo a procedure no banco roda sem problemas mas quando tento chamar no springboot da isso
No repository
@Query( value = "call taxa; ", nativeQuery = true) List<Contracts> lista();
A procedure
` BEGIN
DECLARE saiu INT ;
DECLARE total INT ;
DECLARE entrou INT ;
SELECT COUNT(contrato_id) INTO SAIU FROM tbl_contrato WHERE YEAR(data_fim) =
EXTRACT(YEAR FROM CURDATE());
SELECT COUNT(contrato_id) INTO ENTROU FROM tbl_contrato WHERE YEAR(data_inicio) =
EXTRACT(YEAR fROM CURDATE());
SELECT COUNT(contrato_id) INTO TOTAL FROM tbl_contrato WHERE data_fim <= CURDATE();
SELECT (((ENTROU + SAIU) / 2) / TOTAL) * 100 AS taxa;
END
`
O Erro
`
java.sql.SQLException: Column 'contrato_id' not found.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.27.jar:8.0.27]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.27.jar:8.0.27]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.27.jar:8.0.27]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.27.jar:8.0.27]
at com.mysql.cj.jdbc.result.ResultSetImpl.findColumn(ResultSetImpl.java:581) ~[mysql-connector-java-8.0.27.jar:8.0.27]
at com.mysql.cj.jdbc.result.ResultSetImpl.getLong(ResultSetImpl.java:854) ~[mysql-connector-java-8.0.27.jar:8.0.27]
`
Tentei usar assim
`
@Procedure( value = "call turnover; ")
List<Contracts> lista();
`
Mas de erro de Type cannot be null