Postgres stored procedures not executing

[Jolymmiles]

Get errors when start stored procedure

@Repository

public interface Repo extends CrudRepository<EntityClass, String> {
    @Procedure(procedureName = "sp_dis_hierarchy_sync_groups")
    void sync();
}

[gregturn]

Looks like something fundamental has changed regarding stored procedures in Postgres 11+. Our current integration tests use Postgres 10, and run just fine. Back then, stored procedures were simply functions with a void return type.

Apparently, this has changed massively, and considering we simply later over JPA regarding stored procedure invocations, I'm trying to glean where the real issue is.

[gregturn]

@Jolymmiles What version of Postgres are you using?

[spring-projects-issues]

If you would like us to look at this issue, please provide the requested information. If the information is not provided within the next 7 days this issue will be closed.

[spring-projects-issues]

Closing due to lack of requested feedback. If you would like us to look at this issue, please provide the requested information and we will re-open the issue.

[gregturn]

We know that this involves Postgres 11+.

[gregturn]

Because Postgres didn't have proper stored procedures in versions 10 and earlier, we had integration testing using that combined with that. However, with Postgres 11+, there is now proper support through JPA/Hibernate, etc.

For stored procedures to work properly for you you can either:

• Upgraded your Postgres procedures from functions to procedures properly
• Instead of using @Procedure, switch to @Query and use select statement statements against the stored functions.

[gregturn]

Tests updated for main, 3.1.x, and 3.0.x. Checked out 2.7.x, but Hibernate 5.x is still on Postgres 9, so not applicable.