Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'loginController': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.wackywozniaks.dao.impl.UserDAOImpl com.wackywozniaks.controller.LoginController.userDAOImpl; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userDAOImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.springframework.jdbc.core.JdbcTemplate com.wackywozniaks.dao.impl.UserDAOImpl.jdbcTemplate; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No matching bean of type [org.springframework.jdbc.core.JdbcTemplate] found for dependency: expected at least 1 bean which qualifies as autowire candidate for this dependency. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
- at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:287)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
- at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
- at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
- at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
- at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
- at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
- at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
- at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:631)
- at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:588)
- at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:645)
- at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:508)
- at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:449)
- at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:133)
- at javax.servlet.GenericServlet.init(GenericServlet.java:158)
- at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1238)
- at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)
- at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)
- at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
- at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5306)
- at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
- at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1407)
- at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1397)
- at java.util.concurrent.FutureTask.run(FutureTask.java:266)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at java.lang.Thread.run(Thread.java:745)
- package com.wackywozniaks.dao;
- import java.util.List;
- import com.wackywozniaks.dto.LoginBean;
- import com.wackywozniaks.entity.User;
- public interface UserDAO {
- public void createUser(LoginBean user);
- public User getUser(Long id);
- public List<User> listUsers();
- }
- package com.wackywozniaks.dao.impl;
- import java.util.List;
- import javax.sql.DataSource;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.dao.EmptyResultDataAccessException;
- import org.springframework.jdbc.core.JdbcTemplate;
- import org.springframework.stereotype.Repository;
- import com.wackywozniaks.dao.UserDAO;
- import com.wackywozniaks.dto.LoginBean;
- import com.wackywozniaks.entity.User;
- import com.wackywozniaks.mapper.UserMapper;
- @Repository
- public class UserDAOImpl implements UserDAO {
- @Autowired
- private JdbcTemplate jdbcTemplate;
- public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
- this.jdbcTemplate = jdbcTemplate;
- }
- public void setDataSource(DataSource dataSource) {
- this.jdbcTemplate = new JdbcTemplate(dataSource);
- }
- @Override
- public void createUser(LoginBean user) {
- }
- public User getUser(Long id) {
- String sql = "select * from Users where id = ?";
- User user = null;
- try {
- user = jdbcTemplate.queryForObject(sql, new Object[]{id}, new UserMapper());
- }
- catch(EmptyResultDataAccessException e) {
- return null;
- }
- return user;
- }
- public User getUser(String email) {
- String sql = "select * from Users where email = ?";
- User user = null;
- try {
- user = jdbcTemplate.queryForObject(sql, new Object[]{email}, new UserMapper());
- }
- catch(EmptyResultDataAccessException e) {
- return null;
- }
- return user;
- }
- public List<User> listUsers() {
- String sql = "select * from Users";
- List<User> users = jdbcTemplate.query(sql, new UserMapper());
- return users;
- }
- }
- <?xml version = "1.0" encoding = "UTF-8"?>
- <beans xmlns="http://www.springframework.org/schema/beans"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
- xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context
- http://www.springframework.org/schema/context/spring-context-3.0.xsd">
- <bean id="dataSource"
- class="org.springframework.jdbc.datasource.DriverManagerDataSource">
- <property name="driverClassName" value="org.postgresql.Driver" />
- <property name="url"
- value="#{'jdbc:postgresql://' + systemEnvironment.RDS_HOSTNAME + ':' + systemEnvironment.RDS_PORT + '/' + systemEnvironment.RDS_DB_NAME}" />
- <property name="username" value="#{systemEnvironment.RDS_USERNAME}" />
- <property name="password" value="#{systemEnvironment.RDS_PASSWORD}" />
- </bean>
- <context:annotation-config />
- <context:component-scan base-package="com.wackywozniaks" />
- <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
- <property name="dataSource" ref="dataSource"></property>
- </bean>
- <bean id="loginController" class="com.wackywozniaks.controller.LoginController"></bean>
- <bean id="userDAOImpl" class="com.wackywozniaks.dao.impl.UserDAOImpl">
- <property name="dataSource" ref="dataSource" />
- </bean>
- </beans>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement