bonjour a tous.
quand je crée une classe simple avec connection sur mysql et execution de requete ca marche nikel!ts ça dans le meme projet!mais quand je fais une page JSP ca plante! ca m'envoie le code juste en bas: ya t'il qqchose de plus dans le parametrage de eclipse pr JSP: le pilote JDBC est bien inclu sinon la classe de test a part aurait pas marché!
Merci.
21 janv. 2010 15:56:42 org.apache.tomcat.util.digester.SetPropertiesRule begin
ATTENTION: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:MessagerieManu' did not find a matching property.
21 janv. 2010 15:56:42 org.apache.tomcat.util.digester.SetPropertiesRule begin
ATTENTION: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:MaPremiereMessagerie' did not find a matching property.
21 janv. 2010 15:56:42 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based 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\bin;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre6/bin/client;C:/Program Files/Java/jre6/bin;C:\Program Files\PC Connectivity Solution\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\9.0\DLLShared\;C:\Program Files\Common Files\DivX Shared\;
21 janv. 2010 15:56:43 org.apache.coyote.http11.Http11Protocol init
INFO: Initialisation de Coyote HTTP/1.1 sur http-8080
21 janv. 2010 15:56:43 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 595 ms
21 janv. 2010 15:56:43 org.apache.catalina.core.StandardService start
INFO: Démarrage du service Catalina
21 janv. 2010 15:56:43 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
21 janv. 2010 15:56:43 org.apache.coyote.http11.Http11Protocol start
INFO: Démarrage de Coyote HTTP/1.1 sur http-8080
21 janv. 2010 15:56:43 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
21 janv. 2010 15:56:43 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/28 config=null
21 janv. 2010 15:56:43 org.apache.catalina.startup.Catalina start
INFO: Server startup in 432 ms
21 janv. 2010 15:56:44 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: "Servlet.service()" pour la servlet jsp a généré une exception
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:128)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.apache.jsp.message_jsp._jspService(message_jsp.java:66)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:191)
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:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Unknown Source)
ma page jsp ressemble a ceci:
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
 
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%><html>
<head>
<title>Liste des messages</title></head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection cnx= DriverManager.getConnection("jdbc:mysql://localhost:3306/manu","root","474910");
Statement req= cnx.createStatement();
ResultSet rs=req.executeQuery("select * from message");
out.println("<table border='1'>");
out.println("<tr>");
out.println(" <th>sujet</th><th>message</th>");
out.println("</tr>");
while(rs.next()){
    out.println("<tr>");
    out.println("<td>");
    out.println(rs.getString("sujet"));
    out.println("</td>");
 
    out.println("<td>");
    out.println(rs.getString("text"));
    out.println("</td>");
}
out.println("</table>");
rs.close();
req.close();
cnx.close();
%>
</body>
</html>