• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling Stored Procedure from jdbcTemplate

 
Ramkumar Nachimuthu
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic