Java stored procedure vs sql stored procedure

Question

now java stored procedures are written in java, as the name implies, so they exist on the client side. There are SQL stored procedures on the server. I know about the benefits of having sql stored procedures: - One of them that I can think of is reducing network overhead because you need to send parameters instead of the whole sql statement.

But I can't figure out how to use Java stored procedures over sql stored procedure. Can someone help me with this?

Answer 1

One big advantage of using Java code only is that it is easier to release and to version. If you use stored procedures, it’s not so easy to update and roll back versions or run multiple versions at the same time.

Answer 2

It is written in Java, which some prefer SQL. This is just another way to consolidate the languages ​​used in the project.