Bonjour,j'ai pas mal essayer de resoudre le probleme mais j'y arrive pas.
voici l'erreur que me donne Tomcat5.5.9
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
 
javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.faces.FacesException: javax.faces.FacesException: Can't instantiate class: 'core.walid.NwindManagedBean'.. core.walid.NwindManagedBean
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:844)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:91)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)
	com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)
	com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)
	com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)
	com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
	com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)
 
 
cause mère 
 
javax.faces.el.EvaluationException: javax.faces.FacesException: javax.faces.FacesException: Can't instantiate class: 'core.walid.NwindManagedBean'.. core.walid.NwindManagedBean
	com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:206)
	com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:154)
	javax.faces.component.UIData.getValue(UIData.java:527)
	javax.faces.component.UIData.getDataModel(UIData.java:856)
	javax.faces.component.UIData.setRowIndex(UIData.java:379)
	com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:65)
	javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:683)
	javax.faces.component.UIData.encodeBegin(UIData.java:681)
	javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:591)
	javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:543)
	com.sun.faces.taglib.html_basic.DataTableTag.doEndTag(DataTableTag.java:491)
	org.apache.jsp.index_jsp._jspx_meth_h_dataTable_0(index_jsp.java:161)
	org.apache.jsp.index_jsp._jspx_meth_c_view_0(index_jsp.java:116)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:80)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)
	com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)
	com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)
	com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)
	com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
	com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)
Voici le bean NwindManagedBean que j'utilise pour acceder a la base de données en utilisant Api JDBC
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
import java.sql.*;
import javax.sql.*;
import java.util.ArrayList;
import java.util.Collection;
import java.io.*;
import javax.servlet.jsp.jstl.sql.*;
/**
 *
 * @author XPPRESP3
 */
public class NwindManagedBean implements Serializable{
    private String tableName="Customers";
    private ResultSet resultSet;
    private Connection connection;
    /** Creates a new instance of NwindManagedBean */
    public NwindManagedBean() {
 
    }
    public String getTableName(){
    return tableName;
    }
    public void setTableName(String tableName){
    this.tableName=tableName;
    }
    public void open(){
    String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
    String url = "jdbc:odbc:Nwind";
    String username = "";
    String password = "";
    try{
        Class.forName(driver);
        connection =DriverManager.getConnection(url,username,password);}
    catch(Exception e){System.out.println(e);}
    }
    public void search(){
      try{ Statement statement=connection.createStatement();
       String query ="select * from "+tableName;
        resultSet=statement.executeQuery(query);
 
    }
    catch(Exception cnfe) {};
    }
    public ResultSet getResultSet(){
        open();
        search();
        return resultSet;
    }
    public void showResults(){
        int i=1;
       try{ while(resultSet.next())
        {
        System.out.println(resultSet.getString(i));
        i++;
        }
       }
       catch(Exception e){System.out.println("erreur sql"+e);}
    }
}
ici ma page jsf qui utilise dataTable pour afficher la liste des clients
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
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
 
<html>
   <HEAD><TITLE>Northwind Customers</title>
    </HEAD>
    <body>
        <center>
            <table border="5">
                <tr><th class="Northwind customers"></th></tr>
            </table>
            <p>
            <c:view>
                <h:dataTable value="#{NwindManagedBean.resultSet}"
                var="dbRow"
                border="1"
                >
                <h:column>
                <c:facet name="header">
                <c:verbatim>Company name</c:verbatim>
                </c:facet>
                <h:outputText value="#{dbRow.CompanyName}"/>
                </h:column>
                <h:column>
                <c:facet name="header">
                <c:verbatim>Address</c:verbatim>
                </c:facet>
                <h:outputText 
                value="#{dbRow.Address}"/>
                </h:column>
                <h:column>
                <c:facet name="header">
                <c:verbatim>City</c:verbatim>
                </c:facet>
                <h:outputText 
                value="#{dbRow.City}"/>
                </h:column>
                </h:dataTable>
            </c:view>
            </center>
    </body>
</html>
enfin le faces-config.xml ou je declare le bean
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
<faces-config>
    <managed-bean>
        <managed-bean-name>NwindManagedBean</managed-bean-name>
        <managed-bean-class>core.walid.NwindManagedBean</managed-bean-class>
        <managed-bean-scope>request</managed-bean-scope>
    </managed-bean>
    </faces-config>
si pouvait m'aider je serais tres reconnaissant!!