Calling a stored procedure using apache DBUtils

Question

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 ?

You can find one answer to your question here: [link](http://stackoverflow.com/questions/8742224/apache-dbutils-stored-procedure) — Chris Snow, Nov 19 '12 at 09:04
DBUtils is a light jar to wrap Database Operator, no function with stored procedure, please use JDBC Operator of Connection(CallableStatement) — zg_spring, Apr 09 '15 at 06:05

score 1 · Accepted Answer · answered Nov 19 '12 at 09:03

1

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

answered Nov 19 '12 at 09:03

Alex

25,147
6
59
55

1

Here we are not using DButils – Shamis Shukoor Nov 19 '12 at 09:09
1

Can we use dbutils to specify in and out parameters ? – Shamis Shukoor Nov 19 '12 at 09:24

Calling a stored procedure using apache DBUtils

1 Answers1