This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling Stored Procedure from jdbcTemplate
 
Similar Threads
Calling Stored Procedure from simpleJdbcTemplate
How to get a return value from the stored procedure using callable statement
Servlets and PL\SQL
%rowtype mapping in java
Spring JDBCTemplate _ MS SQL cursor