javacallable-statementapache-commons-dbutils

Calling a stored procedure using apache DBUtils

I cannot find how we can use DBUtils to invoke callable statements

Can we some how specify which all fields are inputs and which all re outputs ?

Solution

  • You just need to use a CallableStatement

    Connection con = ...; // get the connection
CallableStatement callStatement = con.prepareCall("{CALL yourStoredProcedure()}");
ResultSet rs = callStatement.executeQuery();
// do what you need to do