Bonjour,

J'ai créé une JSP d'authentification qui gère la connexion avec un login et d'un password à l'application JEE et je vérifie que le login et le password entrés se trouvent dans la table 'user' de ma base de données 'sitdeco'.

Quand j'exécute (sous Tomcat 7 avec Eclipse Luna) l'interface est là mais quand j'essaye de m'authentifier l'erreur suivant est lancée
Etat HTTP 500 - java.lang.NullPointerException
Et voilà ce qui s'affiche dans la console :
Jan 11, 2014 4:57:45 AM org.apache.catalina.core.AprLifecycleListener init
Infos: 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\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre7/bin/client;C:/Program Files/Java/jre7/bin;C:/Program Files/Java/jre7/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\MySQL\MySQL Utilities 1.3.5\;C:\Program Files\Java\jdk1.6.0_20\bin\;C:\Users\You Rin\Downloads\Compressed\eclipse;;.
Jan 11, 2014 4:57:45 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
Avertissement: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:test' did not find a matching property.
Jan 11, 2014 4:57:45 AM org.apache.coyote.AbstractProtocol init
Infos: Initializing ProtocolHandler ["http-bio-8080"]
Jan 11, 2014 4:57:45 AM org.apache.coyote.AbstractProtocol init
Infos: Initializing ProtocolHandler ["ajp-bio-8009"]
Jan 11, 2014 4:57:45 AM org.apache.catalina.startup.Catalina load
Infos: Initialization processed in 397 ms
Jan 11, 2014 4:57:45 AM org.apache.catalina.core.StandardService startInternal
Infos: Démarrage du service Catalina
Jan 11, 2014 4:57:45 AM org.apache.catalina.core.StandardEngine startInternal
Infos: Starting Servlet Engine: Apache Tomcat/7.0.47
Jan 11, 2014 4:57:45 AM org.apache.coyote.AbstractProtocol start
Infos: Starting ProtocolHandler ["http-bio-8080"]
Jan 11, 2014 4:57:45 AM org.apache.coyote.AbstractProtocol start
Infos: Starting ProtocolHandler ["ajp-bio-8009"]
Jan 11, 2014 4:57:45 AM org.apache.catalina.startup.Catalina start
Infos: Server startup in 376 ms
Problème de pilote
Jan 11, 2014 4:57:53 AM org.apache.catalina.core.StandardWrapperValve invoke
Grave: Servlet.service() for servlet [jsp] in context with path [/test] threw exception [java.lang.NullPointerException] with root cause
java.lang.NullPointerException
at bdd.connexion.Lire(connexion.java:44)
at org.apache.jsp.PageAdmin_jsp._jspService(PageAdmin_jsp.java:184)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Voilà le code de la jsp 'PageAdmin':
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
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
<%@page import="bdd.connexion"%>
<%@page import="uuu.user"%>
 
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<!-- refresh toutes les 60 secondes -->
<title>Acceuil</title>
 
<style>
<!--
.text
{
background-color:white;
color:#413C3C;
        -moz-border-radius: 30px;
        -webkit-border-radius: 0px;
        border-radius:5px;
        width:80%;
        margin-top: 0%;
        margin-bottom: 2%;
        margin-left:0%;
        margin-right:0%;
}
.text:hover
{
background-color: #FFD9DF;
}
-->
</style>
 
</head>
 
<body background="images//dec.jpg">
<%@ include file="date.jsp" %>
<%! connexion cnx; String res;%>
 
    <form action="" method="post">
    <div style="position: absolute; top: 200px; right:510px">
    <table align="center" frame="above"style="color:#413C3C">
           <tr><th colspan="2" align="center">Connexion</th></tr>
           <tr><th>Login : </th><td><input type="text" name="login" style="width:9.5em"  class="text"/></td></tr>
           <tr><th>Password : </th><td><input type="password" name="password" style="width:9.5em"  class="text" /></td></tr>
 
           <tr></tr><tr></tr><tr></tr><tr></tr>
<tr>
<td><input type="submit" value="Connect" style="width:7em; height:2em; margin-left:5em;"></td>
<td><input type="reset" value="Reset" style="width:7em; height:2em"></td>
</tr>
 
    </table>
    </div>
    </form>
 
<%
if(request.getParameter("login")!=null && request.getParameter("password")!=null )
{
        cnx = new connexion("sitedeco");
        String lg = request.getParameter("login");
        String pass = request.getParameter("password");
 
            cnx.Lire("select * from `user` where userLogin='"+lg+"' and userPassword='"+pass+"'");
 
            while(cnx.Suiv())                     
            {
                        user uu = new user(cnx.getrs().getString(1),cnx.getrs().getString(2),cnx.getrs().getString(3),cnx.getrs().getString(4),cnx.getrs().getString(5));
 
                        if(uu.getUser_state()=="active" )
                                {
                                      request.getSession().setAttribute("user",uu);
                                      request.getRequestDispatcher("NewFile.jsp").forward(request, response);  
                                }        
            }
}
%>
</body>
</html>
Quelqu'un saurait-il m'indiquer d'où peut venir le problème ?

Merci d'avance pour votre aide.