aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
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