Spring JDBC Template for calling Stored Procedures

by

There are a number of ways to call stored procedures in Spring.

If you use CallableStatementCreator to declare parameters, you will be using Java’s standard interface of CallableStatement, i.e register out parameters and set them separately. Using SqlParameter abstraction will make your code cleaner.

I recommend you looking at SimpleJdbcCall. It may be used like this:

SimpleJdbcCall jdbcCall = new SimpleJdbcCall(jdbcTemplate)
    .withSchemaName(schema)
    .withCatalogName(package)
    .withProcedureName(procedure)();
...
jdbcCall.addDeclaredParameter(new SqlParameter(paramName, OracleTypes.NUMBER));
...
jdbcCall.execute(callParams);

For simple procedures you may use jdbcTemplate‘s update method:

jdbcTemplate.update("call SOME_PROC (?, ?)", param1, param2);

More Related Contents:

  1. NamedParameterJdbcTemplate vs JdbcTemplate
  2. Spring – @Transactional – What happens in background?
  3. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  4. Spring Boot default H2 jdbc connection (and H2 console)
  5. Jdbctemplate query for string: EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
  6. How to use SELECT IN clause in JDBCTemplates?
  7. Dynamic spring data jpa repository query with arbitrary AND clauses
  8. Spring Boot and multiple external configuration files
  9. @Resource vs @Autowired
  10. Implementing custom methods of Spring Data repository and exposing them through REST
  11. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  12. Hibernate table not mapped error in HQL query
  13. Download Large file from server using REST template Java Spring MVC
  14. How to pass a JSON array as a parameter in URL
  15. java.lang.NoSuchMethodError: org.hibernate.SessionFactory.openSession()Lorg/hibernate/classic/Session
  16. How to include js and CSS in JSP with spring MVC
  17. Hibernate-sequence doesn’t exist
  18. Spring-Data FETCH JOIN with Paging is not working
  19. Customize authentication failure response in Spring Security using AuthenticationFailureHandler
  20. Spring injection Into Servlet
  21. Use abstract super class as parameter for Spring data repository
  22. org.apache.jasper.JasperException: The function test must be used with a prefix when a default namespace is not specified
  23. How set up Spring Boot to run HTTPS / HTTP ports
  24. How to inject ApplicationContext itself
  25. Mixing xml and java config with spring
  26. Path variables in Spring WebSockets @SendTo mapping
  27. Spring 3.1, Hibernate 4, SessionFactory
  28. Spring Boot – Reading Text File using ResourceLoader
  29. Spring + AspectJ weaving for java 8 using aspectj-maven-plugin
  30. hibernate two tables per one entity

Leave a Comment