jdbctemplate not getting created in the DAO class

[Shah Hiren]

I am getting null pointer for the jdbcTemplate even when i have auto wired it .Please suggest what could be wrong.
THe same validationDAO works from a struts action clas and query get executed as well.But it does not work from the utility class.
I tried moving it to the service package and also created Service annotation.
Please help find the errror.

package com.d1.d2.Service
@SuppressWarnings("serial")
@Service
public class XLSX2CSV2 {
	@Autowired
	ValidationDAO validationDAOTemplate;

THe following is the code of DAO

package com.d1.d2.dao;
@Repository
public class ValidationDAO {
	@Autowired
	JdbcTemplate jdbcTemplate;

	public JdbcTemplate getJdbcTemplate() {
		return jdbcTemplate;
	}

	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}

XML config

<context:component-scan base-package="com.k1.k2">
		<context:include-filter type="regex" expression=".dao.*"/> 
		<context:include-filter type="regex" expression=".service.*"/>

					        
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Repository"/>
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Service"/>
    </context:component-scan>

Thanks
Hiren

[Mark Spritzler]

You component scan base package of

base-package="com.k1.k2"

doesn't match the packages of your classes your posted.

On another not. k1, k2, d1, d2 are terrible package names, they tell us nothing. What the heck does it even mean. I don't want to know what it means but package structure and naming are just as important as class and interface naming.

Mark

[Shah Hiren]

I have corrected the package names.

package com.ericson.sales.Service
@SuppressWarnings("serial")
@Service
public class XLSX2CSV2 {
	@Autowired
	ValidationDAO validationDAOTemplate;

package com.ericson.sales.dao;
@Repository
public class ValidationDAO {
	@Autowired
	JdbcTemplate jdbcTemplate;

	public JdbcTemplate getJdbcTemplate() {
		return jdbcTemplate;
	}

	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}

<context:component-scan base-package="com.ericson.sales">
		<context:include-filter type="regex" expression=".dao.*"/> 
		<context:include-filter type="regex" expression=".service.*"/>

					        
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Repository"/>
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Service"/>
    </context:component-scan>

The service xlsxtocsv.class calls ValidationDAO .But ValidationDAO is not getting injected with jdbc template.

[Shah Hiren]

web.xml

 <servlet>

             <servlet-name>earlyriser</servlet-name>

             <servlet-class>com.ge.project.common.LoadServletAtStartup</servlet-class>

             <load-on-startup>1</load-on-startup>

      </servlet>

package com.ge.project.common;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServlet;


public class LoadServletAtStartup extends HttpServlet {
	public static ServletContext servetContext = null;

  public void init() {
	  if (getServletContext()!=null)
	  {
		  System.out.println( getServletName() + ": servelt context is not null" );
	  }
	  LoadServletAtStartup.servetContext = getServletContext();
	  System.out.println( getServletName() + ": initialised" );
  }

}

import org.springframework.web.context.WebApplicationContext;

import org.springframework.web.context.support.WebApplicationContextUtils;

            
//
public boolean insertFinalData2(List<FileDataDTO> lstFinalData) throws SQLException

      {

            

            WebApplicationContext webAppCtx = WebApplicationContextUtils.getWebApplicationContext(LoadServletAtStartup.servetContext);

             JdbcTemplate jdbcTemplateX =(JdbcTemplate) webAppCtx.getBean("jdbcTemplate");
//work with jdbcTemplateX 
}

 

[Mark Spritzler]

And where is your <bean id="jdbcTemplate" …..

in your config file(s)

I expect that you would have one because @Autowired is required by default. So you would get an exception at ApplicationContext startup if there wasn't a jdbcTemplate defined somewhere.

Also, for your component-scan

><context:component-scan base-package="com.ericson.sales"/>


That is all you need. The include you have is redundant, unless there is other classes in your com.ericson.sale package that you do not want to be a Spring Bean and is annotated with @Component or any of the stereotype annotations like @Service.

Mark