Quote Originally Posted by Durden View Post
Well, you can use JdbcTemplate to query your procedures with standard "call procedure (?, ?)" syntax.

Hibernate also supports stored procedures with procedure mapping, see http://docs.jboss.org/hibernate/stab...ngle/#sp_query

If your DAO-logic consists mostly of procedure calls, I would recommend to use jdbcTemplate.
Why would you recommend jdbctemplate? Is it less resource intensive?