This week's book giveaway is in the OCAJP forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Calling Stored Procedure from simpleJdbcTemplate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Calling Stored Procedure from simpleJdbcTemplate" Watch "Calling Stored Procedure from simpleJdbcTemplate" New topic
Author

Calling Stored Procedure from simpleJdbcTemplate

Kamil Kuchta
Greenhorn

Joined: Mar 09, 2009
Posts: 17
I have to use SimpleJdbcTemplate to call stored postgresql procedure. It must be SimpleJdbcTemplate because my test class extends AbstractTransactionalJUnit4SpringContextTests which has simpleJdbcTemplate.

I found this:

http://static.springsource.org/spring/docs/2.0.x/reference/jdbc.html#jdbc-JdbcTemplate-examples
but

doesn't work. Maybe is some detail wrong? Somewhere I met call package.my_function(?) but my function is in no package.

http://www.coderanch.com/t/60690/oa/Calling-Stored-Procedure-jdbcTemplate
doesn't work with simpleJdbcTemplate.
Kamil Kuchta
Greenhorn

Joined: Mar 09, 2009
Posts: 17
Answer:
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling Stored Procedure from simpleJdbcTemplate