Nov 15th, 2010, 07:32 PM
Dynamic Procedure call using JdbcTemplate
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.
Tags for this Thread