Remplir un selectOneMenu à partir d'une BD oracle

Remplir un selectOneMenu à partir d'une BD oracle - Java - Programmation

Marsh Posté le 22-05-2011 à 00:15:23    

Salut
j'ai une liste déroulante que je veux la remplir via une base de donnée oracle(noté que je travaille avec jsf 2.0 sous netbeans)
mais un message d'erreur s'affiche:

Code :
  1. An Error Occurred:
  2. Cannot convert [javax.faces.model.SelectItem@61d27a] of type class java.util.ArrayList to class javax.faces.model.SelectItem
  5. java.lang.IllegalArgumentException: Cannot convert [javax.faces.model.SelectItem@61d27a] of type class java.util.ArrayList to class javax.faces.model.SelectItem
  6. at com.sun.el.lang.ELSupport.coerceToType(ELSupport.java:397)
  7. at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:222)
  8. at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:190)
  9. at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:178)
  10. at javax.faces.component.UISelectItem.getValue(UISelectItem.java:231)
  11. at com.sun.faces.renderkit.SelectItemsIterator.initializeItems(SelectItemsIterator.java:189)
  12. at com.sun.faces.renderkit.SelectItemsIterator.hasNext(SelectItemsIterator.java:135)
  13. at com.sun.faces.renderkit.html_basic.MenuRenderer.renderOptions(MenuRenderer.java:760)
  14. at com.sun.faces.renderkit.html_basic.MenuRenderer.renderSelect(MenuRenderer.java:842)
  15. at com.sun.faces.renderkit.html_basic.MenuRenderer.encodeEnd(MenuRenderer.java:296)
  16. at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:878)
  17. at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1620)
  18. at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1616)
  19. at com.sun.faces.application.view.JspViewHandlingStrategy.doRenderView(JspViewHandlingStrategy.java:420)
  20. at com.sun.faces.application.view.JspViewHandlingStrategy.renderView(JspViewHandlingStrategy.java:209)
  21. at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:126)
  22. at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:127)
  23. at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
  24. at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
  25. at javax.faces.webapp.FacesServlet.service(FacesServlet.java:313)
  26. at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1523)
  27. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
  28. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188)
  29. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:641)
  30. at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:97)
  31. at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:85)
  32. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:185)
  33. at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:332)
  34. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:233)
  35. at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:165)
  36. at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:791)
  37. at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:693)
  38. at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:954)
  39. at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:170)
  40. at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135)
  41. at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102)
  42. at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88)
  43. at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
  44. at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53)
  45. at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57)
  46. at com.sun.grizzly.ContextTask.run(ContextTask.java:69)
  47. at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330)
  48. at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309)
  49. at java.lang.Thread.run(Thread.java:619)


voici mon bean:
 

Code :
  1. import java.sql.SQLException;
  2. import java.util.ArrayList;
  3. import java.util.List;
  4. import javax.faces.model.SelectItem;
  6. import java.sql.*;
  7. import java.sql.DriverManager;
  8. import java.util.logging.Level;
  9. import java.util.logging.Logger;
  10. /*
  11. * To change this template, choose Tools | Templates
  12. * and open the template in the editor.
  13. */
  16. /**
  17. *
  18. * @author utilisateur
  19. */
  20. public class Monbean {
  21. private String maValeur;
  22. Connection con ;
  23. private List<SelectItem> mesElements;
  26. public String getmaValeur() {
  27. return maValeur;
  28. }
  30. public void setmaValeur(String maValeur) {
  31. this.maValeur = maValeur;
  32. }
  33. private Iterable<String> getMaliste() throws SQLException {
  34. ArrayList unelist = new ArrayList();
  39. try
  40. {
  41. Class.forName("oracle.jdbc.driver.OracleDriver" );
  42. System.out.println ("driver etablie" );
  43. }
  44. catch(Exception e)
  45. {
  46. System.out.println ("erreur:Driver int" +
  47. "rouvable" );
  48. }
  53. try
  55. {
  56. String URL = "jdbc:oracle:thin:@localhost:1521:gmao";
  57. String USER = "pfe";
  58. String PASSWD = "gmao";
  60. con =DriverManager.getConnection(URL,USER, PASSWD);
  61. System.out.println ("connexion base pfe etablie" );
  62. }
  63. catch(Exception e)
  64. {
  65. System.out.println ("erreur: base introuvable" );
  67. }
  70. Statement st = con.createStatement();
  72. ResultSet resultats = null;
  73. try {
  74. resultats = st.executeQuery("select * from auteur" );
  75. }
  76. catch (SQLException ex) {
  77. Logger.getLogger(Monbean.class.getName()).log(Level.SEVERE, null, ex);
  78. }
  80. try {
  81. while(resultats.next()){
  83. String num=resultats.getString("nomaut" ).toString();
  84. unelist.add(num);
  86. }
  87. }
  88. //session.close();
  89. catch (Exception e) {
  90. e.printStackTrace();
  91. }
  92. return (List) unelist;
  93. }
  96. public List<SelectItem> getMesElements() throws SQLException {
  98. if (mesElements == null) {
  99. mesElements = new ArrayList<SelectItem>();
  100. for (String val : getMaliste()) {
  101. mesElements.add(new SelectItem(val));
  102. }
  104. }
  105. return mesElements;
  107. /** Creates a new instance of Monbean */
  110. }
  112. public Monbean() throws SQLException{
  115. }
  116. }


 
------------------------------
et dans ma page jsf
j'ai mis

Code :
  1. <h:selectOneMenu value=" # {Monbean.maValeur}" >
  2. <f:selectItem value="#{Monbean .mesElements}"/>


Pourriez vous s'il vous plait m'aider à corriger mon code source
je vous remercie

Reply

Marsh Posté le 22-05-2011 à 00:15:23   

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed