Meaningless Drivel is fun!
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
It's not a secret anymore!