springjdbccall parameter caching

[harikrishnan83]

Hi,

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.

Thanks,
HariKrishnan

[oleg.zhurakousky]

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

[harikrishnan83]

apologies, I have reposted as per your suggestion