Can anybody say that stored procedures are for and against, and Java stored procedures are for and against?

Question

Can anyone tell what stored procedures are for and against? And the Java pro and con stored procedures? And how to test it.

Yours faithfully!

Answer 1

The arguments for and against stored procedures are generally divided into what, in your opinion, is the correct answer to the question: does the business logic belong to the database or application? I will try to be neutral in my presentation of the arguments. If I succeed, some of my pros and cons will be self-contradictory.

PRO

• , , - . .
• , .
• .

CON

• - .
• , .
• , .
• , .

Java. , .

PRO

• Java , .
• , .
• , Java.
• Java .

CON

• Java , .
• Java , .
• Java .
• Java . .

Java : , , , . ORM . , .

Answer 2

pro:

-Secure

-

- ( , /-)

-