Call a Stored Procedure using Java JDBC CallableStatement Example

Java JDBC CallableStatement to call Stored Procedure Example
MySQL Stored Procedure:
CREATE DEFINER=`root`@`%` PROCEDURE `my_stored_proc`()
   Select count(*) from my_table;

Java Code:
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JdbcStoredProcedureExample {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        String url ="jdbc:mysql://localhost:3306/my_uat";
        String userName="root";
        String password ="root123";

        Connection connection = DriverManager.getConnection(url,userName,password);
        //Create the stored procedure call as a String
        String call="call my_stored_proc()";
        //Prepare CallableStatement
        CallableStatement callableStatement = connection.prepareCall(call);
        //Execute and fetch resultSet
        ResultSet resultSet = callableStatement.executeQuery();
        //Converting resultSet to ArrayList
        while( {
Output: 3

Have Questions? Post them here!
Try Out Code2care Dev Tools:


Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and software developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include learnings, tutorials, trouble-shooting steps, video tutorials, code snippets, how-to, blogs, articles, etc.

🎉 We are celebrating the 10th years of Code2care! Thank you for all your support!

We strongly support Gender Equality & Diversity.