Advertisement
Guest User

Untitled

a guest
Apr 2nd, 2017
236
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.48 KB | None | 0 0
  1. 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)}
  2. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:287)
  3. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)
  4. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
  5. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  6. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
  7. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
  8. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
  9. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
  10. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
  11. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
  12. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
  13. at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:631)
  14. at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:588)
  15. at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:645)
  16. at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:508)
  17. at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:449)
  18. at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:133)
  19. at javax.servlet.GenericServlet.init(GenericServlet.java:158)
  20. at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1238)
  21. at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)
  22. at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)
  23. at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
  24. at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5306)
  25. at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
  26. at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1407)
  27. at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1397)
  28. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  29. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  30. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  31. at java.lang.Thread.run(Thread.java:745)
  32.  
  33. package com.wackywozniaks.dao;
  34.  
  35. import java.util.List;
  36.  
  37. import com.wackywozniaks.dto.LoginBean;
  38. import com.wackywozniaks.entity.User;
  39.  
  40. public interface UserDAO {
  41.  
  42. public void createUser(LoginBean user);
  43.  
  44. public User getUser(Long id);
  45.  
  46. public List<User> listUsers();
  47.  
  48. }
  49.  
  50. package com.wackywozniaks.dao.impl;
  51.  
  52. import java.util.List;
  53.  
  54. import javax.sql.DataSource;
  55.  
  56. import org.springframework.beans.factory.annotation.Autowired;
  57. import org.springframework.dao.EmptyResultDataAccessException;
  58. import org.springframework.jdbc.core.JdbcTemplate;
  59. import org.springframework.stereotype.Repository;
  60.  
  61. import com.wackywozniaks.dao.UserDAO;
  62. import com.wackywozniaks.dto.LoginBean;
  63. import com.wackywozniaks.entity.User;
  64. import com.wackywozniaks.mapper.UserMapper;
  65.  
  66. @Repository
  67. public class UserDAOImpl implements UserDAO {
  68.  
  69. @Autowired
  70. private JdbcTemplate jdbcTemplate;
  71.  
  72. public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
  73. this.jdbcTemplate = jdbcTemplate;
  74. }
  75.  
  76. public void setDataSource(DataSource dataSource) {
  77. this.jdbcTemplate = new JdbcTemplate(dataSource);
  78. }
  79.  
  80. @Override
  81. public void createUser(LoginBean user) {
  82.  
  83. }
  84.  
  85. public User getUser(Long id) {
  86. String sql = "select * from Users where id = ?";
  87. User user = null;
  88. try {
  89. user = jdbcTemplate.queryForObject(sql, new Object[]{id}, new UserMapper());
  90. }
  91. catch(EmptyResultDataAccessException e) {
  92. return null;
  93. }
  94. return user;
  95. }
  96.  
  97. public User getUser(String email) {
  98. String sql = "select * from Users where email = ?";
  99. User user = null;
  100. try {
  101. user = jdbcTemplate.queryForObject(sql, new Object[]{email}, new UserMapper());
  102. }
  103. catch(EmptyResultDataAccessException e) {
  104. return null;
  105. }
  106. return user;
  107. }
  108.  
  109. public List<User> listUsers() {
  110. String sql = "select * from Users";
  111. List<User> users = jdbcTemplate.query(sql, new UserMapper());
  112. return users;
  113. }
  114.  
  115. }
  116.  
  117. <?xml version = "1.0" encoding = "UTF-8"?>
  118. <beans xmlns="http://www.springframework.org/schema/beans"
  119. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
  120. 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
  121. http://www.springframework.org/schema/context/spring-context-3.0.xsd">
  122.  
  123. <bean id="dataSource"
  124. class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  125. <property name="driverClassName" value="org.postgresql.Driver" />
  126. <property name="url"
  127. value="#{'jdbc:postgresql://' + systemEnvironment.RDS_HOSTNAME + ':' + systemEnvironment.RDS_PORT + '/' + systemEnvironment.RDS_DB_NAME}" />
  128. <property name="username" value="#{systemEnvironment.RDS_USERNAME}" />
  129. <property name="password" value="#{systemEnvironment.RDS_PASSWORD}" />
  130. </bean>
  131.  
  132. <context:annotation-config />
  133. <context:component-scan base-package="com.wackywozniaks" />
  134.  
  135. <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
  136. <property name="dataSource" ref="dataSource"></property>
  137. </bean>
  138.  
  139.  
  140. <bean id="loginController" class="com.wackywozniaks.controller.LoginController"></bean>
  141.  
  142. <bean id="userDAOImpl" class="com.wackywozniaks.dao.impl.UserDAOImpl">
  143. <property name="dataSource" ref="dataSource" />
  144. </bean>
  145.  
  146. </beans>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement