Showing Hibernate/JPA results in JSF datatable causes: java.lang.NumberFormatException: For input string: “[propertyname]”

by

Your Hibernate query is actually returning a List<Object[]>, not a List<Employee> as you incorrectly assumed during the unchecked cast.

Evidence is in the stack trace:

java.lang.NumberFormatException: For input string: "name"
    at java.lang.NumberFormatException.forInputString(Unknown source)
    at java.lang.Integer.parseInt(Unknown source)
    at java.lang.Integer.parseInt(Unknown source)
    at javax.el.ArrayELResolver.toInteger(ArrayELResolver.java:166)
    at javax.el.ArrayELResolver.getValue(ArrayELResolver.java:46)
    ...

The ArrayELResolver is only involved when the base of name (thus, the #{employee}) represents an array like Object[] not a javabean like Bean. EL is attempting to use the name to obtain the array item by index, which can only be an integer like so #{employee[0]} for the 1st item. However, the string value "name" is not parseable as an integer and hence this exception.

You have 2 options to solve this problem:

  • Alter the JSF code to expect a List<Object[]>. Use e.g. #{employee[0]}, #{employee[1]}, etc.

    <p:dataTable var="employee" value="#{bean.employees}">
    <p:column id="name" headerText="Name">
        <h:outputText value="#{employee[0]}" />
    </p:column>
    <p:column id="id" headerText="ID" >
        <h:outputText value="#{employee[1]}" />
    </p:column>
</p:dataTable>

  • Fix the Hibernate query to return a real List<Employee>.

See also:

More Related Contents:

  1. How to show details of current row from p:dataTable in a p:dialog and update after save
  2. p:dataExporter does not recognize p:cellEditor
  3. LazyInitializationException in selectManyCheckbox on @ManyToMany(fetch=LAZY)
  4. Understanding PrimeFaces process/update and JSF f:ajax execute/render attributes
  5. How can I pass selected row to commandLink inside dataTable or ui:repeat?
  6. How and when should I load the model from database for h:dataTable
  7. JSTL c:if doesn’t work inside a JSF h:dataTable
  8. Unicode input retrieved via PrimeFaces input components become corrupted
  9. PrimeFaces CSS look’n’feel missing and JS “Uncaught Reference Error: PrimeFaces is not defined”
  10. How do PrimeFaces Selectors as in update=”@(.myClass)” work?
  11. Display database blob images in inside
  12. File upload doesn’t work with AJAX in PrimeFaces 4.0/JSF 2.2.x – javax.servlet.ServletException: The request content-type is not a multipart/form-data
  13. @SessionScoped bean looses scope and gets recreated all the time, fields become null
  14. PrimeFaces validator not fired
  15. How to do double-click prevention in JSF
  16. How to bind dynamic content using ?
  17. Difference between rendered and visible attributes of
  18. How to create a composite component for a datatable column?
  19. h:messages does not display messages when p:commandButton is pressed
  20. JSF convertDateTime with timezone in datatable
  21. PrimeFaces commandButton doesn’t navigate or update
  22. Using java.util.Map in h:dataTable
  23. How and when should I load the model from database for JSF dataTable
  24. How do UISelectOne and UISelectMany components preselect defaults in f:selectItems
  25. Updating entire on complete of
  26. c:forEach inside primefaces(e.g. p:panelgrid) inside ui:repeat
  27. How to use java.time.ZonedDateTime / LocalDateTime in p:calendar
  28. Calling Primefaces dialog box from Managed Bean function
  29. Remove all styling from Primefaces components?
  30. JSF resource versioning

Leave a Comment