Announcement Announcement Module
No announcement yet.
Dynamic Procedure call using JdbcTemplate Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dynamic Procedure call using JdbcTemplate

    Hi there!

    Here is my use case.

    1. I need to list all the stored procedures (MySQL, I did it quite nicely).
    2. Use JdbcTemplate to call the stored procedures on the fly with provided values (an excel sheet perhaps).

    As you can see there is no static binding/registration of input/output parameter and specially their types.

    How can I do this? Please help..

    Btw, I'm using grails, I was doing it with Groovy SQL up till now which was a breeze as Groovy just do the type casting on the fly, but now I have to stick to JdbcTempalte because of transaction management issues. GroovySQL just can't manage the transactions if underlying procedure itself calls multiple procedures within itself. JdbcTempalte on the other hand rollbacks perfectly with a Runtime Exception in Grails service.

    Alam Sher