We have old application and it have generic class BaseStoredProcedure which extends StoredProcedure.

BaseStoredProcedure use by more than 200 procedure calling classes. It is hard to make changes into BaseStoredProcedure class.

Now, we have input parameter having default value at database end. We should be able to make a call with not mandatory parameter and let default parameters work with default value.but we are not able to do.

Is it because it does not supported yet? There is open issue.

Note: we cannot replace this implementation with SimpleJdbcCall as it will increase regression(lead said)

class BaseStoredProcedure extends StoredProcedure {
//Constructor with data source set to supper class

//Declare parameters method to set all input and output parameter, here I want to ignore setting default input parameter declaration 

//Execute() here I want to ignore setting default parameters value 

}

Please suggest how to call procedure with optional parameter using StoredProcedure only? As we can do using SimpleJdbcCall withoutProcedureColumnMetaDataAccess() method. As given here