By khateeb


2014-02-03 04:55:19 8 Comments

In Spring, when we are inserting into the database, we can use JdbcDaoSupport or not. My question is, what are the advantages in using it and in which circumstances we should use it?

2 comments

@gavenkoa 2014-02-24 15:51:34

According to these answers:

JdbcDaoSupport, NamedParameterJdbcDaoSupport, SimpleJdbcDaoSupport are unnecessary and are mental dust. They doesn't save any line of code because you need to inject data-source or template into.

What I recommend - to create templates in XML/class config per data source and reuse/inject them as templates are thread safe according to docs:

Once configured, a JdbcTemplate instance is threadsafe. You may want multiple JdbcTemplate instances if your application accesses multiple databases, which requires multiple DataSources, and subsequently multiple differently configured JdbcTemplates.

Compare applicationContext.xml:

<bean id="dataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
    <property name="driverClassName" value="${jdbc.driverClassName}"/>
    <property name="url" value="${jdbc.url}"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
</bean>
<bean id="jdbcTemplate" 
      class="org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate">
    <constructor-arg ref="dataSource"/>
</bean>

and YourDaoImpl.java:

public class YourDaoImpl implements YourDao {

    @Autowired
    private NamedParameterJdbcTemplate jdbcTemplate;

    @Override
    public int tableExists(String table) {
        String sql = "select count(*) from all_tables"
                + "  where table_name = :tbl";
        return jdbcTemplate.queryForObject(
                    sql, new MapSqlParameterSource("tbl", table), Integer.class);
    }
}

with JdbcDaoSupport.java:

public class YourDaoImpl extends NamedParameterJdbcDaoSupport implements YourDao {

   @Autowired
    public void setDs(DataSource dataSource) {
        setDataSource(dataSource);
    }

    @Override
    public int tableExists(String table) {
        String sql = "select count(*) from all_tables"
                + "  where table_name = :tbl";
        return getNamedParameterJdbcTemplate()
               .queryForObject(
                       sql,
                       new MapSqlParameterSource("tbl", table), Integer.class);
    }

}

UPDATE Official statement about stateless (and so thread safety) of JdbcTemplate/NamedParameterJdbcTemplate here https://jira.springsource.org/browse/SPR-11478

@Prancer 2014-02-03 14:14:11

First lets point out the API specifies this class as a convenience class ("support"). I believe JdbcDaoSupport supports, aka provides you with, a base implementation of the DAO design for jdbc whereas a template class (see template pattern) will give you a singleton that is used to inject into your DAO classes.

In my experience I haven't found a reason to couple my DAO to a *Support class. I instead create my specific jdbcTemplate beans and inject them into my DAO classes favoring composition over inheritence -- generally a good object-oriented practice.

From the Spring docs, "You can choose whether to inherit from this class. The JdbcDaoSupport class is provided as a convenience only.".

As Spring states, JdbcDaoSupport is a convenience only. They say nothing about its advantages over using one of the template implementations.

Related Questions

Sponsored Content

5 Answered Questions

4 Answered Questions

[SOLVED] Spring - @Transactional - What happens in background?

15 Answered Questions

10 Answered Questions

[SOLVED] What in the world are Spring beans?

  • 2013-06-19 14:05:06
  • grantmcconnaughey
  • 148030 View
  • 370 Score
  • 10 Answer
  • Tags:   java spring grails

15 Answered Questions

[SOLVED] Why is my Spring @Autowired field null?

1 Answered Questions

Extending DAO with JDBCDAOSupport, a bad practice?

  • 2015-01-29 09:26:44
  • faisalbhagat
  • 226 View
  • 0 Score
  • 1 Answer
  • Tags:   java spring jdbc

2 Answered Questions

[SOLVED] Spring JdbcDaoSupport

  • 2014-06-11 09:32:14
  • user3729326
  • 288 View
  • 2 Score
  • 2 Answer
  • Tags:   java mysql spring

0 Answered Questions

Spring JDBCDAOSUPPORT for multiple datasources

1 Answered Questions

JdbcDaoSupport with a SQL SELECT FROM INSERT

Sponsored Content