Spring et jasperreport

Bonjour,
je suis entrain de travailler avec Spring et Jasperreport pour la génération des rapport . mais j'ai rencontré quelques problèmes qui m'ont bloqués voila mon code source .

Web.xml :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4"> <servlet> <servlet-name>jasperSpring</servlet-name> <servlet-class> org.springframework.web.servlet.DispatcherServlet </servlet-class> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>jasperSpring</servlet-name> <url-pattern>/jasperSpring/*</url-pattern> </servlet-mapping>   </web-app>

---

Et voila mon fichier views.properties :

Citation:

---

report.class=org.springframework.web.servlet.view.jasperreports.JasperReportsPdfView
report.url=/WebContent/reportsusers.jasper

---

Et voila mon fichier jasperSpring-servlet.xml :

Code:

---

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 44 45

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www. springframework.org/dtd/spring-beans.dtd"> <beans>   <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location"><value>/WEB-INF/jdbc.properties</value></property> </bean>   <bean id="dataSource" class="org.springframework.jdbc.datasource. DriverManagerDataSource" destroy-method="close"> <property name="driverClassName"> <value>com.mysql.jdbc.Driver</value> </property> <property name="url"> <value>${jdbc.url}</value> </property> <property name="username"> <value>${jdbc.username}</value> </property> <property name="password"> <value>${jdbc.password}</value> </property> </bean> <bean id="publicUrlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping"> <property name="mappings"> <props> <prop key="report">jasperController</prop> </props> </property> </bean> <bean id="jasperController" class="net.ensode.jasperbook.spring.JasperSpringController"> <property name="dataSource"> <ref local="dataSource"/> </property> </bean> <bean id="viewResolver" class="org.springframework.web.servlet.view. ResourceBundleViewResolver"> <property name="basename" value="views"/> </bean> </beans>

---

voila ma servlet jasperSpringController

Code:

---

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 44 45 46

package net.ensode.jasperbook.spring; import java.io.IOException;   import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.HashMap; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.sql.DataSource; import net.sf.jasperreports.engine.JRResultSetDataSource; import org.springframework.web.servlet.ModelAndView; import org.springframework.web.servlet.mvc.Controller; public class JasperSpringController implements Controller { private DataSource dataSource; public ModelAndView handleRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException { return new ModelAndView("report", getModel()); } private Map getModel() throws ClassNotFoundException, SQLException { Connection connection; Statement statement; ResultSet resultSet; HashMap model = new HashMap(); String query = "select * from users"; connection = dataSource.getConnection(); statement = connection.createStatement();   resultSet = statement.executeQuery(query); JRResultSetDataSource resultSetDataSource = new JRResultSetDataSource(resultSet); model.put("datasource", resultSetDataSource); return model; } public void setDataSource (DataSource dataSource) { this.dataSource=dataSource; } }

---

Enfin ma page jsp qui fait apelle au report :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Generate Report</title> </head> <body> Click on the button to generate the report. <form name="reportForm" action="jasperSpring/report" method="post"> <input type="submit" name="submitButton" value="Submit"/> </form> </body> </html>

---

Mais lorque je lance ma page jsp elle me donne une liste de message d'erreur :


exception

Citation:

---

javax.servlet.ServletException: "Servlet.init()" pour la servlet jasperSpring a généré une exception
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
java.lang.Thread.run(Unknown Source)


cause mère

org.springframework.beans.factory.BeanDefinitionStoreException: Error registering bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/jasperSpring-servlet.xml]: Bean class [org.springframework.jdbc.datasource. DriverManagerDataSource] not found; nested exception is java.lang.ClassNotFoundException: org.springframework.jdbc.datasource. DriverManagerDataSource
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:645)
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitionElement(DefaultXmlBeanDefinitionParser.java:531)
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseDefaultElement(DefaultXmlBeanDefinitionParser.java:397)
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.parseBeanDefinitions(DefaultXmlBeanDefinitionParser.java:371)
org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser.registerBeanDefinitions(DefaultXmlBeanDefinitionParser.java:206)
org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:388)
org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:259)
org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:209)
org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:184)
org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:128)
org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:144)
org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:126)
org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:94)
org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:89)
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:279)
org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:155)
org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:308)
org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:252)

---

Bonjour,
Il te manque Spring-JDBC dans le classpath.

Bonjour ,
maintenant j'ai remarqué qu'il y un accés sur la servlet mais il y avait un problème de generation de reports et voila la listes des messages d'erreurs retouré

Code:

---

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 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89

11 août 2008 11:19:36 org.apache.catalina.core.AprLifecycleListener init INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.6.0_02\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jre1.6.0_02\bin\client;C:\Program Files\Java\jre1.6.0_02\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem 11 août 2008 11:19:37 org.apache.coyote.http11.Http11Protocol init INFO: Initialisation de Coyote HTTP/1.1 sur http-8080 11 août 2008 11:19:37 org.apache.catalina.startup.Catalina load INFO: Initialization processed in 3778 ms 11 août 2008 11:19:37 org.apache.catalina.core.StandardService start INFO: Démarrage du service Catalina 11 août 2008 11:19:37 org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/6.0.14 11 août 2008 11:19:43 org.apache.catalina.loader.WebappClassLoader validateJarFile INFO: validateJarFile(C:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\exemple\WEB-INF\lib\servlet.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class 0 [main] INFO servlet.DispatcherServlet - Initializing servlet 'jasperSpring' 328 [main] INFO core.CollectionFactory - JDK 1.4+ collections available 328 [main] INFO servlet.DispatcherServlet - FrameworkServlet 'jasperSpring': initialization started 11 août 2008 11:19:46 org.apache.catalina.core.ApplicationContext log INFO: Loading WebApplicationContext for Spring FrameworkServlet 'jasperSpring' 515 [main] INFO xml.XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/jasperSpring-servlet.xml] 1140 [main] INFO support.XmlWebApplicationContext - Bean factory for application context [WebApplicationContext for namespace 'jasperSpring-servlet']: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,publicUrlMapping,jasperController,viewResolver]; root of BeanFactory hierarchy 1156 [main] INFO support.XmlWebApplicationContext - 4 beans defined in application context [WebApplicationContext for namespace 'jasperSpring-servlet'] 1187 [main] INFO support.XmlWebApplicationContext - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@4ee70b] 1203 [main] INFO support.XmlWebApplicationContext - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@d85cc] 1203 [main] INFO support.UiApplicationContextUtils - Unable to locate ThemeSource with name 'themeSource': using default [org.springframework.ui.context.support.ResourceBundleThemeSource@a77106] 1203 [main] INFO support.DefaultListableBeanFactory - Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,publicUrlMapping,jasperController,viewResolver]; root of BeanFactory hierarchy] 1453 [main] INFO datasource.DriverManagerDataSource - Loaded JDBC driver: com.mysql.jdbc.Driver 1531 [main] INFO servlet.DispatcherServlet - Using context class [org.springframework.web.context.support.XmlWebApplicationContext] for servlet 'jasperSpring' 1531 [main] INFO servlet.DispatcherServlet - Unable to locate MultipartResolver with name 'multipartResolver': no multipart request handling provided 1578 [main] INFO servlet.DispatcherServlet - Unable to locate LocaleResolver with name 'localeResolver': using default [org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver@107f45d] 1578 [main] INFO servlet.DispatcherServlet - Unable to locate ThemeResolver with name 'themeResolver': using default [org.springframework.web.servlet.theme.FixedThemeResolver@979e8b] 1640 [main] INFO servlet.DispatcherServlet - No HandlerAdapters found in servlet 'jasperSpring': using default 1656 [main] INFO servlet.DispatcherServlet - Unable to locate RequestToViewNameTranslator with name 'viewNameTranslator': using default [org.springframework.web.servlet.view.DefaultRequestToViewNameTranslator@33f0de] 1656 [main] INFO servlet.DispatcherServlet - FrameworkServlet 'jasperSpring': initialization completed in 1328 ms 1656 [main] INFO servlet.DispatcherServlet - Servlet 'jasperSpring' configured successfully 11 août 2008 11:19:47 org.apache.coyote.http11.Http11Protocol start INFO: Démarrage de Coyote HTTP/1.1 sur http-8080 11 août 2008 11:19:48 org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 11 août 2008 11:19:48 org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/141 config=null 11 août 2008 11:19:48 org.apache.catalina.startup.Catalina start INFO: Server startup in 11062 ms #################connexion ok #################create statement ok #################excute ok ############# #################Genration du modele net.sf.jasperreports.engine.JRResultSetDataSource@1570945 22937 [http-8080-2] ERROR servlet.DispatcherServlet - Could not complete request java.util.MissingResourceException: Can't find bundle for base name views, locale fr at java.util.ResourceBundle.throwMissingResourceException(Unknown Source) at java.util.ResourceBundle.getBundleImpl(Unknown Source) at java.util.ResourceBundle.getBundle(Unknown Source) at org.springframework.web.servlet.view.ResourceBundleViewResolver.getBundle(ResourceBundleViewResolver.java:222) at org.springframework.web.servlet.view.ResourceBundleViewResolver.initFactory(ResourceBundleViewResolver.java:175) at org.springframework.web.servlet.view.ResourceBundleViewResolver.loadView(ResourceBundleViewResolver.java:148) at org.springframework.web.servlet.view.AbstractCachingViewResolver.createView(AbstractCachingViewResolver.java:146) at org.springframework.web.servlet.view.AbstractCachingViewResolver.resolveViewName(AbstractCachingViewResolver.java:79) at org.springframework.web.servlet.DispatcherServlet.resolveViewName(DispatcherServlet.java:1084) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1028) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:813) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:726) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 11 août 2008 11:20:09 org.apache.catalina.connector.CoyoteAdapter service GRAVE: Une exception ou une erreur s'est produite dans le conteneur durant le traitement de la requête java.lang.StackOverflowError at javax.servlet.ServletException.getRootCause(ServletException.java:96) at org.springframework.web.util.NestedServletException.getCause(NestedServletException.java:69) at javax.servlet.ServletException.getRootCause(ServletException.java:96) at org.springframework.web.util.NestedServletException.getCause(NestedServletException.java:69) at javax.servlet.ServletException.getRootCause(ServletException.java:96) at org.springframework.web.util.NestedServletException.getCause(NestedServletException.java:69) at javax.servlet.ServletException.getRootCause(ServletException.java:96) at org.springframework.web.util.NestedServletException.getCause(NestedServletException.java:69) at javax.servlet.ServletException.getRootCause(ServletException.java:96) at org.springframework.web.util.NestedServletException.getCause(NestedServletException.java:69) at javax.servlet.ServletException.getRootCause(ServletException.java:96)

---

Bonjour ,
Voila j'ai ajouté mes jar dans classpath :
maitenant lorsque je clique sur le bouton pour me generer le rapport il m'affiche le message suivant :

Code:

---

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

Etat HTTP 500 -   --------------------------------------------------------------------------------   type Rapport d'exception   message   description Le serveur a rencontré une erreur interne () qui l'a empêché de satisfaire la requête.   exception   java.util.MissingResourceException: Can't find bundle for base name views, locale fr java.util.ResourceBundle.throwMissingResourceException(Unknown Source) java.util.ResourceBundle.getBundleImpl(Unknown Source) java.util.ResourceBundle.getBundle(Unknown Source) org.springframework.web.servlet.view.ResourceBundleViewResolver.initFactory(ResourceBundleViewResolver.java:149) org.springframework.web.servlet.view.ResourceBundleViewResolver.loadView(ResourceBundleViewResolver.java:122) org.springframework.web.servlet.view.AbstractCachingViewResolver.createView(AbstractCachingViewResolver.java:139) org.springframework.web.servlet.view.AbstractCachingViewResolver.resolveViewName(AbstractCachingViewResolver.java:77) org.springframework.web.servlet.DispatcherServlet.resolveViewName(DispatcherServlet.java:950) org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:909) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:705) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625) org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:386) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:355) javax.servlet.http.HttpServlet.service(HttpServlet.java:710) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)     note La trace complète de la cause mère de cette erreur est disponible dans les fichiers journaux de Apache Tomcat/6.0.14.     --------------------------------------------------------------------------------   Apache Tomcat/6.0.14

---