Which is better Stored Procedures or use JDBC Java?

Question

MySQL

Hello!
There was a question. Now I am at a crossroads. What to choose:
1. Use SQL queries in a Java program
2. Use Stored Procedures, and already query the results of their work in Java
I always followed the rule, if the database can do it, then let it do it. But now I began to doubt. Is it worth storing procedures? What are the pros and cons you see in each approach?

Answer 1

(1) Flexibility + testability
vs.
(2) speed + binding to the engine + hassle with migrations + logic in the database
However, I'm not sure that muscle procedures are now production ready

Answer 2

You should not store business logic, without special need in the database. Because maintaining and refactoring a database is an order of magnitude more difficult than java code.