Here is my DAO code
this.calcRTRDetails = new SimpleJdbcCall(dataSource).withCatalogName("score_rtr").
withProcedureName("calc_rtr_dtls").declareParameters(
new SqlParameter("p_repy_track", Types.ARRAY)
).returningResultSet("p_track_dtls",new RowMapper<String>() {
@Override
public String mapRow(ResultSet rs, int arg1)
throws SQLException {
// TODO Auto-generated method stub
return rs.getString(1);
}
} );
I get the following error
org.springframework.dao.InvalidDataAccessApiUsageException: Unable to determine the correct call signature - multiple procedures/functions/signatures for CALC_RTR_DTLS found [SCORE_RTR.SCORE.CALC_RTR_DTLS, SCORE_RTR.SCORE.CALC_RTR_DTLS]
What can be the reason ??
I found that I had a very similar issue where I was trying to call an overloaded Postgres function. The solution in Spring 3.2.3 was to call withoutProcedureColumnMetaDataAccess().
But be sure to explicitly declare your parameters. Alternative is to to give your overloaded functions different names.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With