File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies 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
%rowtype mapping in java
Servlets and PL\SQL
Spring JDBCTemplate _ MS SQL cursor
How to get a return value from the stored procedure using callable statement
Calling Stored Procedure from simpleJdbcTemplate