No bean named 'JDBCDAOImpl' is defined - Exception

[Dana Ucaed]

Hello ranchers,

I faces with one issue:

I created one app using NetBeans 8.2 to learn Spring DataAccess.

My  spring.xml

<?xml version='1.0' encoding='UTF-8' ?>
<!-- was: <?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:p="http://www.springframework.org/schema/p"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
       http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"
       xmlns:context="http://www.springframework.org/schema/context">

    <!--bean id="propertyConfigurer"
              class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
        p:location="/WEB-INF/jdbc.properties" /> 
    </beans>/-->
    
   
    


<bean id="dataSource"
          class="org.springframework.jdbc.datasource.DriverManagerDataSource"
          p:driverClassName="org.apache.derby.jdbc.ClientDriver"
          p:url="jdbc:derby://localhost:1527/sample"
          p:username="app"
          p:password="app">
    </bean>

    <!-- ADD PERSISTENCE SUPPORT HERE (jpa, hibernate, etc) -->

</beans>

My main class is:

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package readfromdatabasespring;


import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.stereotype.Component;


public class ReadFromDatabaseSpring {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws Exception {

       try
       {
        ApplicationContext ctx = new ClassPathXmlApplicationContext("spring.xml");
        JDBCDAOImpl dao = (JDBCDAOImpl) ctx.getBean("JDBCDAOImpl", JDBCDAOImpl.class);

        Users1 read = new JDBCDAOImpl().getUser(1);
        System.out.println(read.getName());
       }
       catch(Exception ex)
       {
           ex.printStackTrace();
       }

    }

}


My users1 class is:

package readfromdatabasespring;


import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;




public class Users1 {

    private static final long serialVersionUID = 1L;
    @Id
    @Basic(optional = false)
    @Column(name = "ID")
    private Integer id;
    @Basic(optional = false)
    @Column(name = "NAME")
    private String name;
    @Basic(optional = false)
    @Column(name = "EMAIL")
    private String email;

    public Users1() {
    }

    public Users1(Integer id) {
        this.id = id;
    }

    public Users1(Integer id, String name) {
        this.id = id;
        this.name = name;
        
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Users1)) {
            return false;
        }
        Users1 other = (Users1) object;
        if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "readfromdatabasespring.Users1[ id=" + id + " ]";
    }

}

and my JDBCDAOImp class is:

package readfromdatabasespring;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.stereotype.Component;

@Component
@ComponentScan
public class JDBCDAOImpl {

    @Autowired
    private DataSource dataSource;

    public DataSource getDataSource() {
        return dataSource;
    }

    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
    }

    public JDBCDAOImpl() {
    }

    public Users1 getUser(int userId) throws Exception {
        Users1 u1 = null;
        Connection c = null;
        try {
            //c = DriverManager.getConnection("jdbc:derby://localhost:1527/sample", "app", "app");
            c = dataSource.getConnection();

            PreparedStatement stmt = c.prepareStatement("SELECT ID, NAME, Email FROM APP.USERS1 where ID = ?");
            stmt.setInt(1, userId);
            ResultSet rs = stmt.executeQuery();

            while (rs.next()) {
                u1 = new Users1(userId, rs.getString("NAME"));
                System.out.println(u1.getName());
            }

            rs.close();
            stmt.close();

        } catch (SQLException ex) {
            ex.printStackTrace();

        } finally {
            c.close();
        }
        return u1;
    }

}

When I try to run my project surprise:

Aug 30, 2017 2:01:32 PM org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@443b7951: startup date [Wed Aug 30 14:01:32 EEST 2017]; root of context hierarchy
Aug 30, 2017 2:01:32 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [spring.xml]
Aug 30, 2017 2:01:32 PM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@2a5ca609: defining beans [dataSource]; root of factory hierarchy
Aug 30, 2017 2:01:33 PM org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
INFO: Loaded JDBC driver: org.apache.derby.jdbc.ClientDriver
org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'JDBCDAOImpl' is defined
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:570)
at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1114)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:279)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1121)
at readfromdatabasespring.ReadFromDatabaseSpring.main(ReadFromDatabaseSpring.java:24)
BUILD SUCCESSFUL (total time: 1 second)


Can someone help me?

I am using Spring Framework 3.2.7.

Thanks a lot,

[Dana Ucaed]

I modified my spring.xml so:

<?xml version='1.0' encoding='UTF-8' ?>
<!-- was: <?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:p="http://www.springframework.org/schema/p"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
       http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"
>

    <!--bean id="propertyConfigurer"
              class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
        p:location="/WEB-INF/jdbc.properties" /> 
    </beans>/-->
    
    <bean id="JDBCDAOImpl"
          class="readfromdatabasespring.JDBCDAOImpl">
    </bean> 
    


    <bean id="dataSource"
          class="org.springframework.jdbc.datasource.DriverManagerDataSource"
          p:driverClassName="org.apache.derby.jdbc.ClientDriver"
          p:url="jdbc:derby://localhost:1527/sample"
          p:username="app"
          p:password="app">
    </bean>

    <!-- ADD PERSISTENCE SUPPORT HERE (jpa, hibernate, etc) -->

</beans>

ans surprise:

my exception is:

java.lang.NullPointerException
at readfromdatabasespring.JDBCDAOImpl.getUser(JDBCDAOImpl.java:40)
at readfromdatabasespring.ReadFromDatabaseSpring.main(ReadFromDatabaseSpring.java:27)
java.lang.NullPointerException
at readfromdatabasespring.JDBCDAOImpl.getUser(JDBCDAOImpl.java:59)
at readfromdatabasespring.ReadFromDatabaseSpring.main(ReadFromDatabaseSpring.java:27)

means that my dataSource from my xml is not recognized.

[Vaibhav Gargs]

Now, you are getting NullPointerException. Run the following query on DB:

SELECT ID, NAME, Email FROM APP.USERS1 where ID = ?

for given ID and check if there are any rows returned?

[Dana Ucaed]

I resolved.

My issue was from Spring.xml.

This is corect file.

<?xml version='1.0' encoding='UTF-8' ?>
<!-- was: <?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:p="http://www.springframework.org/schema/p"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
       http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"
>

    <!--bean id="propertyConfigurer"
              class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
        p:location="/WEB-INF/jdbc.properties" /> 
    </beans>/-->
    
    <bean id="dataSource"
              class="org.springframework.jdbc.datasource.DriverManagerDataSource"
              p:driverClassName="org.apache.derby.jdbc.ClientDriver"
              p:url="jdbc:derby://localhost:1527/sample"
              p:username="app"
              p:password="app">
    </bean>
    
    
    
    <bean id="JDBCDAOImpl"
          class="readfromdatabasespring.JDBCDAOImpl">
        <property name ="dataSource" ref = "dataSource"></property>
    </bean>