public class SavetoDBDaoImpl implements SavetoDBDao {
        private JdbcTemplate jdbcTemplate;
        public static final Logger logger = LoggerFactory
                .getLogger(SavetoDBDaoImpl.class);

        @Autowired
        public void setJdbcTemplate(DataSource dataSource) {
            this.jdbcTemplate = new JdbcTemplate(dataSource);
        }

        @Override
        @Transactional(rollbackFor = Exception.class)
        public void saveSchedInstr(UserDetails userDetails) throws Exception {
                String insertIntoUserInstanceStatus = "INSERT INTO UserInstanceStatus(UserID,CreateTS,InsertTs,EmployeeID,StatusCd) VALUES(?,?,?,?,?)";
            String insertIntoUserStatusDetails = "INSERT INTO UserStatusDetails(UserID,CreateTS,InsertTs,EmployeeID, StatusCd, STATE, HEADER, BODY, RESPONSETIME, PROTOCOL) VALUES(?,?,?,?,?,?,?,?,?,?)";

                /*
                 * Store status into table UserInstanceStatus
                 */
                jdbcTemplate.update(insertIntoUserInstanceStatus, userDetails.getUserId(),LocalDateTime.now(),
                        LocalDateTime.now(), userDetails.getEmployeeId(),
                        userDetails.getState());

                /*
                 * Store status details into table UserStatusDetails.
                 */
                try {
jdbcTemplate.update(insertIntoUserStatusDetails, userDetails.getUserId(),
            LocalDateTime.now(), LocalDateTime.now(),
                        userDetails.getEmployeeId(), userDetails.getStatusCd(), userDetails.getState(),
                        userDetails.getHeader().toString(), userDetails.getBody().toString(),
                        userDetails.getResponseTime(), userDetails.getStatus()
                                .getProtocol());
                logger.debug("Successfully stored user details into DB");
                } catch(Exception e) {
                    e.printStackTrace();
                }

        }
    }