90 What kind of exceptions those spring DAO classes throw?

The spring’s DAO class does not throw any technology related exceptions such as SQLException. They throw exceptions which are subclasses of DataAccessException.

91 What is DataAccessException?

DataAccessException is a RuntimeException. This is an Unchecked Exception. The user is not forced to handle these kinds of exceptions.

92  How can you configure a bean to get DataSource from JNDI?

        <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
             <property name="jndiName">
               <value>java:comp/env/jdbc/myDatasource</value>
            </property>
        </bean>

93  How can you create a DataSource connection pool?

        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
           <property name="driver">
               <value>${db.driver}</value>
           </property>
           <property name="url">
              <value>${db.url}</value>
           </property>
           <property name="username">
             <value>${db.username}</value>
           </property>
           <property name="password">
            <value>${db.password}</value>
           </property>
        </bean>

94  How JDBC can be used more efficiently in spring framework?

JDBC can be used more efficiently with the help of a template class provided by spring framework called as JdbcTemplate.

95  How JdbcTemplate can be used?

With use of Spring JDBC framework the burden of resource management and error handling is reduced a lot. So it leaves developers to write the statements and queries to get the data to and from the database.

        JdbcTemplate template = new JdbcTemplate(myDataSource);
A simple DAO class looks like this.

        public class StudentDaoJdbc implements StudentDao {
          private JdbcTemplate jdbcTemplate;

        public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
           this.jdbcTemplate = jdbcTemplate;
        }
        more..
        }
The configuration is shown below.

        <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
           <property name="dataSource">
               <ref bean="dataSource"/>
           </property>
        </bean>
        <bean id="studentDao" class="StudentDaoJdbc">
           <property name="jdbcTemplate">
               <ref bean="jdbcTemplate"/>
           </property>
        </bean>
        <bean id="courseDao" class="CourseDaoJdbc">
           <property name="jdbcTemplate">
               <ref bean="jdbcTemplate"/>
           </property>
        </bean>

96  How do you write data to backend in spring using JdbcTemplate?

The JdbcTemplate uses several of these callbacks when writing data to the database. The usefulness you will find in each of these interfaces will vary. There are two simple interfaces. One is PreparedStatementCreator and the other interface is BatchPreparedStatementSetter.

97  Explain about PreparedStatementCreator?

PreparedStatementCreator is one of the most common used interfaces for writing data to database. The interface has one method createPreparedStatement().

        PreparedStatement createPreparedStatement(Connection conn)
        throws SQLException;
When this interface is implemented, we should create and return a PreparedStatement from the Connection argument, and the exception handling is automatically taken care off. When this interface is implemented, another interface SqlProvider is also implemented which has a method called getSql() which is used to provide sql strings to JdbcTemplate.

98 Explain about BatchPreparedStatementSetter?

If the user what to update more than one row at a shot then he can go for BatchPreparedStatementSetter. This interface provides two methods

        setValues(PreparedStatement ps, int i) throws SQLException;
       
        int getBatchSize();
The getBatchSize() tells the JdbcTemplate class how many statements to create. And this also determines how many times setValues() will be called.

99. Explain about RowCallbackHandler and why it is used?

In order to navigate through the records we generally go for ResultSet. But spring provides an interface that handles this entire burden and leaves the user to decide what to do with each row. The interface provided by spring is RowCallbackHandler. There is a method processRow() which needs to be implemented so that it is applicable for each and everyrow.

        void processRow(java.sql.ResultSet rs);

100 What is JDBC abstraction and DAO module?

Using this module we can keep up the database code clean and simple, and prevent problems that result from a failure to close database resources. A new layer of meaningful exceptions on top of the error messages given by several database servers is bought in this module. In addition, this module uses Spring’s AOP module to provide transaction management services for objects in a Spring application.