Postgresql :Calling of stored procedure through Java code with Hibernate

Question

I am getting an error while using lambda expression(->{ ) for calling a stored procedure.

Error: org.postgresql.util.PSQLException: ERROR: syntax error at or near "{"

Here is the code I am using to call my stored procedure using Prepared Statement.

    public void deleteData(Session session, int minVal, int maxVal) throws SQLException {
    session.doWork(connection -> {
        PreparedStatement st = connection.prepareStatement("{call delete_data(" + minVal + "," + maxVal + ")}");
        st.execute();
    });
}

I want to execute this stored procedure. Could you please help me with it by suggesting changes or modifying my current code.

Thanks in advance.

Rakesh Vasal · Accepted Answer · 2019-09-24 10:01:08Z

1

Try This :

public void deleteData(Session session, int minVal, int maxVal) throws SQLException {
    session.doWork(new Work() {
                @Override
                public void execute(Connection connection) throws SQLException {
                    CallableStatement st = null;
                    st = connection.prepareCall("{call delete_data(?,?)}");
                    st.setInt(1, minVal);
                    st.setInt(2, maxVal);
                    st.execute();
                    st.close();
                }
            }); 

    }

answered Sep 24, 2019 at 10:01

Rakesh Vasal

2665 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql :Calling of stored procedure through Java code with Hibernate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related