Search code examples
mysqlstored-proceduresjdbcreturn-valuestored-functions

Can I call a stored procedure in jdbc which returns a table using mysql?

I'm new to using jdbc to execute mysql stored procedures. My question is that is it possible to call an stored procedure which returns a table in jdbc? I searched a lot and I know I can return a certain number of parameters using registerOutParameter using procedures, but how about a whole table with several rows?!

I hope it's not a redundant post.

Solution

  • Yes. It's possible to call a MySQL stored procedure to return a resultset using JDBC.

    Examples provided here:

    https://docs.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html#calling_javadb_mysql