aspose file tools*
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
Author

Calling Stored Procedure from jdbcTemplate

Ramkumar Nachimuthu
Greenhorn

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,
N.Ramkumar
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 ]
 
 
subject: Calling Stored Procedure from jdbcTemplate