Aug 2nd, 2009, 12:00 PM
springjdbccall parameter caching
We are using springjdbccall to execute stored procedures in oracle database. I was reusing the same springjdbccall to call multiple stored procedures. For example:
stored proc 1 - createCustomer
parameter - customer_type (oracle type)
stored proc 2 - loadCustomer
parameter - id (number)
The issue we were facing is, when executing the second stored procedure (load_customer), the simplejdbccall was still holding on to the parameter (customer_type) from the first stored proc call (load_customer). So we would get an exception saying in or out parameter missing on the second stored proc call.
I want to know how to clear the parameters before making a call to another stored procedure.
I worked around this by instantiating a new simplejdbccall for every stored proc call. But this is costly.
Please let me know your suggestions.
Aug 2nd, 2009, 01:32 PM
This forum is about "Spring Integration" project (http://www.springsource.org/spring-integration) and not about general integration concerns around Spring framework.
I would suggest to re-post the question here: http://forum.springsource.org/forumdisplay.php?f=27
Aug 2nd, 2009, 04:20 PM
thank you very much
apologies, I have reposted as per your suggestion
Tags for this Thread