I am using Spring JDBC to call SQL statements. Recently I wrote a service to call a SP on Oracle from Spring. As explained on the Spring documentation on the link below, I created a class that extends StoredProcedure and everything that has been explained.
Hi, I'm bit confused with the calling pattern of Stored Procedure using jdbcTemplate.
Do i need to add a new class everytime a new SP is to be called?
I WANT to call a SP with some IN and OUT parameters and want to store the result in some DTO object and want to do this using spring in such a manner
that many functions can be listed in a sinlge class some XXXDAO.java
So that it can be called from a bllImp class with some input arguments and gets a class object DTO/String/List/Result set in return.
Please give a running example or provide a .war with the example code or any link where i can clear my doubts.