EntityManager et requête Select -> NullPointerException

**Raph87** · 12/11/2011, 18h33

Salut à tous,

voila pour mon application multicouches, j'essaye de lister (via ma vue) des record d'une table de ma DB. J'utilise des annotations JPA dans mes différentes classe.

Ma classe DAOImpl

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
	@PersistenceContext
	private EntityManager em;
 
	@Transactional
	public void create(Role role) {
		Role myRole = em.merge(role);
		em.flush();
 
		role.setRole(myRole.getRole());
 
	}
 
	@Transactional(readOnly=true)
	public List<Role> listRole() {
		@SuppressWarnings("unchecked")
		List<Role>mesRoles = em.createQuery("SELECT r FROM t_role r").getResultList();
		return mesRoles;
	}
...

Ma classe de service

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
@Service
public class RoleServiceImpl implements RoleService {
 
	private final Log logger = LogFactory.getLog(getClass());
	@Autowired
	private IRoleDAO roleDao;
 
 
	public void addRole(Role role) {
		roleDao.create(role);
 
 
	}
 
 
	public List<Role> listRole() {
 
		List<Role> roles=null;
		try
		{
			roles = roleDao.listRole();
		}
		catch(Exception e)
		{
			logger.error("Problem avec la liste"+e.getMessage());
		}
 
 
		return roles;
	}

Et mon Controller

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
@Controller
public class RoleController {
	private final Log logger = LogFactory.getLog(getClass());
 
	private RoleService roleService;
 
	@RequestMapping(value="/lstroles.html")
	public ModelAndView displayRoles(HttpServletRequest req , HttpServletResponse rep)
	{
		logger.info("displayRoles()");
		ModelAndView mav = new  ModelAndView();
		mav.setViewName("layout");
		req.setAttribute("pageTitle", "Vos roles");
		req.setAttribute("maingPage", "/roles/lstroles.jsp");
 
		mav.addObject("roles", roleService.listRole());
		return mav;
 
	}
 
}

Quand je veux afficher ma page, j'ai comme message :
12-nov.-2011 18:21:41 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [spring] in context with path [/projetecole_login0511] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause
java.lang.NullPointerException
at be.helb.app.controller.RoleController.displayRoles(RoleController.java:29)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)

Tout est bon non ? Comment savoir si mon DAO et mon Service contiennent bien ma liste ?
Merci d'avance

**JeitEmgie** · 12/11/2011, 20h24

En cas d'exception vous renvoyez null et mav.addObject n'accepte sans doute pas null comme paramètre, comme vous avez un logger.error vous devriez voir quelque chose dans les logs à moins que vous ayez mal configuré vos paramètres de configuration du logger,
commencez par renvoyer une liste vide au lieu de null : si çà "fonctionne", c'est que vous avez une exception qui n'est pas logguée pour cause de configuration erronée et qu'une fois que vous aurez corrigé cela, vous verrez la vraie cause du problème.

**Raph87** · 12/11/2011, 21h54

Ok, je ne vois pas grand chose concernant ma liste, ni le message d'erreur que j'ai mis dans logger.error dans le fichier.

logs.txt

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
 
2011-11-12 21:50:25,615 INFO [org.springframework.web.context.ContextLoader] - Root WebApplicationContext: initialization started
2011-11-12 21:50:25,679 INFO [org.springframework.web.context.support.XmlWebApplicationContext] - Refreshing Root WebApplicationContext: startup date [Sat Nov 12 21:50:25 CET 2011]; root of context hierarchy
2011-11-12 21:50:25,772 INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader] - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
2011-11-12 21:50:26,381 INFO [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer] - Loading properties file from class path resource [jdbc.properties]
2011-11-12 21:50:26,396 INFO [org.springframework.context.weaving.DefaultContextLoadTimeWeaver] - Using a reflective load-time weaver for class loader: org.springframework.instrument.classloading.tomcat.TomcatInstrumentableClassLoader
2011-11-12 21:50:26,568 INFO [org.springframework.web.context.support.XmlWebApplicationContext] - Bean 'dataSource' of type [class org.apache.commons.dbcp.BasicDataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2011-11-12 21:50:26,599 INFO [org.springframework.web.context.support.XmlWebApplicationContext] - Bean 'org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter#5029d294' of type [class org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2011-11-12 21:50:26,599 INFO [org.springframework.web.context.support.XmlWebApplicationContext] - Bean 'jpaDialectTrans' of type [class org.springframework.orm.jpa.vendor.EclipseLinkJpaDialect] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2011-11-12 21:50:26,615 INFO [org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean] - Building JPA container EntityManagerFactory for persistence unit 'projetecole'
2011-11-12 21:50:27,552 INFO [org.springframework.web.context.support.XmlWebApplicationContext] - Bean 'entityManagerFactory' of type [class org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2011-11-12 21:50:27,583 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@67e2c841: defining beans [org.springframework.context.weaving.AspectJWeavingEnabler#0,org.springframework.context.config.internalBeanConfigurerAspect,loadTimeWeaver,org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,dataSource,entityManagerFactory,jpaDialectTrans,transactionManager,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,org.springframework.transaction.config.internalTransactionAspect,org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor#0,roleDAOImpl,roleServiceImpl,org.springframework.security.providers.dao.DaoAuthenticationProvider#0,_userDetailsService,org.springframework.security.config.AuthenticationProviderBeanDefinitionParser$AuthenticationProviderCacheResolver#0,_authenticationManager,_filterChainProxy,_httpSessionContextIntegrationFilter,_filterChainProxyPostProcessor,_filterChainList,_securityContextHolderAwareRequestFilter,_accessManager,_portMapper,_exceptionTranslationFilter,_filterSecurityInterceptor,_sessionFixationProtectionFilter,_anonymousAuthenticationProvider,_anonymousProcessingFilter,_rememberMeServices,_rememberMeAuthenticationProvider,_rememberMeFilter,_rememberMeServicesInjectionBeanPostProcessor,_logoutFilter,_basicAuthenticationEntryPoint,_basicAuthenticationFilter,_formLoginFilter,_formLoginEntryPoint,_entryPointInjectionBeanPostProcessor,_userServiceInjectionPostProcessor]; root of factory hierarchy
2011-11-12 21:50:27,770 INFO [org.springframework.security.userdetails.jdbc.JdbcUserDetailsManager] - No authentication manager set. Reauthentication of users when changing passwords will not be performed.
2011-11-12 21:50:27,801 INFO [org.springframework.security.config.EntryPointInjectionBeanPostProcessor] - Selecting AuthenticationEntryPoint for use in ExceptionTranslationFilter
2011-11-12 21:50:27,801 INFO [org.springframework.security.config.EntryPointInjectionBeanPostProcessor] - Using main configured AuthenticationEntryPoint.
2011-11-12 21:50:27,801 INFO [org.springframework.security.config.EntryPointInjectionBeanPostProcessor] - Using bean 'org.springframework.security.ui.webapp.AuthenticationProcessingFilterEntryPoint@48834af6' as the entry point.
2011-11-12 21:50:27,817 INFO [org.springframework.security.intercept.AbstractSecurityInterceptor] - Validated configuration attributes
2011-11-12 21:50:27,833 INFO [org.springframework.security.config.RememberMeServicesInjectionBeanPostProcessor] - Setting RememberMeServices on bean _basicAuthenticationFilter
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - Checking sorted filter chain: [org.springframework.security.context.HttpSessionContextIntegrationFilter[ order=200; ], org.springframework.security.ui.logout.LogoutFilter[ order=300; ], org.springframework.security.ui.webapp.AuthenticationProcessingFilter[ order=700; ], org.springframework.security.ui.basicauth.BasicProcessingFilter[ order=1000; ], org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter[ order=1100; ], org.springframework.security.ui.rememberme.RememberMeProcessingFilter[ order=1200; ], org.springframework.security.providers.anonymous.AnonymousProcessingFilter[ order=1300; ], org.springframework.security.ui.ExceptionTranslationFilter[ order=1400; ], org.springframework.security.ui.SessionFixationProtectionFilter[ order=1600; ], org.springframework.security.intercept.web.FilterSecurityInterceptor@477baf4]
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - Filter chain...
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - [0] - org.springframework.security.context.HttpSessionContextIntegrationFilter[ order=200; ]
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - [1] - org.springframework.security.ui.logout.LogoutFilter[ order=300; ]
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - [2] - org.springframework.security.ui.webapp.AuthenticationProcessingFilter[ order=700; ]
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - [3] - org.springframework.security.ui.basicauth.BasicProcessingFilter[ order=1000; ]
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - [4] - org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter[ order=1100; ]
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - [5] - org.springframework.security.ui.rememberme.RememberMeProcessingFilter[ order=1200; ]
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - [6] - org.springframework.security.providers.anonymous.AnonymousProcessingFilter[ order=1300; ]
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - [7] - org.springframework.security.ui.ExceptionTranslationFilter[ order=1400; ]
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - [8] - org.springframework.security.ui.SessionFixationProtectionFilter[ order=1600; ]
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - [9] - org.springframework.security.intercept.web.FilterSecurityInterceptor@477baf4
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - Checking whether login URL '/login.html' is accessible with your configuration
2011-11-12 21:50:27,848 INFO [org.springframework.security.config.FilterChainProxyPostProcessor] - FilterChainProxy: FilterChainProxy[ UrlMatcher = org.springframework.security.util.AntUrlPathMatcher[requiresLowerCase='true']; Filter Chains: {/css/**=[], /login.html=[], /**=[org.springframework.security.context.HttpSessionContextIntegrationFilter[ order=200; ], org.springframework.security.ui.logout.LogoutFilter[ order=300; ], org.springframework.security.ui.webapp.AuthenticationProcessingFilter[ order=700; ], org.springframework.security.ui.basicauth.BasicProcessingFilter[ order=1000; ], org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter[ order=1100; ], org.springframework.security.ui.rememberme.RememberMeProcessingFilter[ order=1200; ], org.springframework.security.providers.anonymous.AnonymousProcessingFilter[ order=1300; ], org.springframework.security.ui.ExceptionTranslationFilter[ order=1400; ], org.springframework.security.ui.SessionFixationProtectionFilter[ order=1600; ], org.springframework.security.intercept.web.FilterSecurityInterceptor@477baf4]}]
2011-11-12 21:50:27,864 INFO [org.springframework.web.context.ContextLoader] - Root WebApplicationContext: initialization completed in 2249 ms
2011-11-12 21:50:27,879 INFO [org.springframework.web.servlet.DispatcherServlet] - FrameworkServlet 'spring': initialization started
2011-11-12 21:50:27,879 INFO [org.springframework.web.context.support.XmlWebApplicationContext] - Refreshing WebApplicationContext for namespace 'spring-servlet': startup date [Sat Nov 12 21:50:27 CET 2011]; parent: Root WebApplicationContext
2011-11-12 21:50:27,879 INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader] - Loading XML bean definitions from ServletContext resource [/WEB-INF/spring-servlet.xml]
2011-11-12 21:50:27,974 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@49b9a538: defining beans [loginController,roleController,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,viewResolver]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory@67e2c841
2011-11-12 21:50:28,036 INFO [org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping] - Mapped URL path [/home.html] onto handler 'loginController'
2011-11-12 21:50:28,036 INFO [org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping] - Mapped URL path [/login.html] onto handler 'loginController'
2011-11-12 21:50:28,036 INFO [org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping] - Mapped URL path [/denied.html] onto handler 'loginController'
2011-11-12 21:50:28,036 INFO [org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping] - Mapped URL path [/lstroles.html] onto handler 'roleController'
2011-11-12 21:50:28,161 INFO [org.springframework.web.servlet.DispatcherServlet] - FrameworkServlet 'spring': initialization completed in 282 ms
2011-11-12 21:50:49,243 INFO [be.helb.app.controller.RoleController] - displayRoles()

Où configure -t-on les logs ?

**JeitEmgie** · 13/11/2011, 09h55

Envoyé par Raph87

Ok, je ne vois pas grand chose concernant ma liste, ni le message d'erreur que j'ai mis dans logger.error dans le fichier.

logs.txt

Où configure -t-on les logs ?

log4j.properties
log4j.xml

…lire la doc du framework que vous utilisez…

EntityManager et requête Select -> NullPointerException

Spring Java

Vue hybride

Discussions similaires

Partager

Partager