If Java calls the MYSQL stored procedure with input and output parameters, the following error occurs: java. SQL. SQLException: Parameter number X is not an OUT parameter (X indicates a number)
By convention, Google immediately searched for the above errors and the answer was to delete the comments behind the output parameters, as stated in website 1 and website 2.
However, I tried it, but I still couldn't. I remotely asked my peers if there was no solution for the QQ group. A day has been wasted.
Today, I decided to re-write a test-specific stored procedure and re-call it.
Nimei! Ah !! It turns out that the name of the stored procedure to be called is incorrect, and the stored procedure does not exist !!!
Previously, the name "prc_splite_page" was used. Later, the team lead asked me to change it to "sp_splite_page", but the project was suspended for two months and I forgot to change it.
Then, my lonely programmer will have a cup.
Ben yuanhereby has a card in front of this pit. You are lucky to see it.