File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Application Frameworks and the fly likes Calling Stored Procedure from jdbcTemplate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Other Application Frameworks
Bookmark "Calling Stored Procedure from jdbcTemplate" Watch "Calling Stored Procedure from jdbcTemplate" New topic

Calling Stored Procedure from jdbcTemplate

Ramkumar Nachimuthu

Joined: Dec 30, 2006
Posts: 23
Hi. how to call stored procedure from jdbcTemplate?. i am able to get jdbcTemplate object and my database have id(primary ker, number) and blob.
using jdbctemplate i have to call stored procedure and update a file to database. kindly help me.
Thanks and Regards,
Tamas Jano
Ranch Hand

Joined: Feb 21, 2007
Posts: 55
You create a new org.springframework.jdbc.object.StoredProcedure object, set its input parameters and run it.

A sample code would look like this:

and you run it like this:

[ September 14, 2007: Message edited by: Tamas Jano ]
I agree. Here's the link:
subject: Calling Stored Procedure from jdbcTemplate