Announcement Announcement Module
Collapse
No announcement yet.
springjdbccall parameter caching Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • springjdbccall parameter caching

    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

  • #2
    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

    Comment


    • #3
      thank you very much

      apologies, I have reposted as per your suggestion

      Comment

      Working...
      X