ERROR [procedure name] is not a procedure with Postgres 12 after upgrading from Spring Boot 3.0.3 to >= 3.1.0 about spring-data-jpa

[fvclaus]

Thanks. I think I have figured it out. Since Postgres 11, real stored procedures are supported (not just functions). If I change my code from FUNCTION to PROCEDURE, the test succeeds with 3.2.3 (but not with 3.0.3). I also scrolled through the Hibernate release notes (between 6.1.7 and 6.2.2), but couldn't find anything.

[mp911de]

I'm able to reproduce the same issue with calling the entity manager directly:

StoredProcedureQuery someProcedure = em.createStoredProcedureQuery("some_procedure");
someProcedure.registerStoredProcedureParameter("some_id", String.class, ParameterMode.IN);
someProcedure.setParameter("some_id", "42");
someProcedure.execute();

You can rewrite your Spring Data repository query method to the following form to consume the return value:

@Query(value = "SELECT some_procedure(:some_id)", nativeQuery = true)
long someProcedure(@Param("some_id") String id);

[fvclaus]

That's fine with. We don't have automated test for those calls, but it is not such a big deal to retest the whole application. Do you mind explaining why this is not going to be fixed? @Procedure worked before and I couldn't find any release notes that this changed.

[mp911de]

The change has happened inside of Hibernate so that isn't something we can fix. We can only outline how you could work around that issue.