i havew a entity with id=
@Id
@Basic(optional = false)
@NotNull
@Size(min = 1, max = 1)
@Column(name = "STATUS_ID")
private String statusId;
when i list all entity into the db with #{consultantStatusController.items}
into a datatable with method into the cotroller=
public List<ConsultantStatus> getItems() {
if (items == null) {
items = getFacade().findAll();
}
return items;
}
items = DataModel
i get:
javax.el.ELException: Error reading 'items' on type
jsf.ConsultantStatusController$$OwbNormalScopeProxy0
viewId=/consultantStatus/List.xhtml
location=/home/utente_javaee7/NetBeansProjects/progetti_netbeans8/ConsultingRifattoTomeePrimefaces/build/web/consultantStatus/List.xhtml
phaseId=RENDER_RESPONSE(6)
Caused by:
java.lang.NumberFormatException - A
at org.apache.derby.client.am.CrossConverters.parseInt(Unknown Source)
/consultantStatus/List.xhtml at line 25 and column 35
value="#{consultantStatusController.items}"+
---------------------------------------------
org.apache.myfaces.view.facelets.el.ContextAwareELException:
javax.el.ELException: Error reading 'items' on type
jsf.ConsultantStatusController$$OwbNormalScopeProxy0
at
org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:104)
at
javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:249)
at javax.faces.component.UIData.getValue(UIData.java:2036)
at
org.primefaces.component.datatable.DataTable.getValue(DataTable.java:910)
at org.primefaces.component.api.UIData.getDataModel(UIData.java:615)
at org.primefaces.component.api.UIData.setRowModel(UIData.java:422)
at org.primefaces.component.api.UIData.setRowIndex(UIData.java:414)
at javax.faces.component.UIData.encodeEnd(UIData.java:1698)
at
org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:74)
at
org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:57)
at
org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:204)
at
org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:121)
at
org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:58)
at
javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:665)
at
org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:74)
at
org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:57)
at
org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:72)
at
org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:57)
at
org.primefaces.component.layout.LayoutUnitRenderer.encodeEnd(LayoutUnitRenderer.java:51)
at
javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:665)
at
javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:545)
at
javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
at
javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
at
javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
at
org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981)
at
org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:305)
at
javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59)
at
org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116)
at
org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:199)
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.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45)
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(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: javax.el.ELException: Error reading 'items' on type
jsf.ConsultantStatusController$$OwbNormalScopeProxy0
at javax.el.BeanELResolver.getValue(BeanELResolver.java:68)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:58)
at
org.apache.myfaces.el.unified.resolver.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:179)
at org.apache.el.parser.AstValue.getValue(AstValue.java:183)
at
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:185)
at
org.apache.webbeans.el22.WrappedValueExpression.getValue(WrappedValueExpression.java:70)
at
org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96)
... 49 more
Caused by: javax.ejb.EJBException: The bean encountered a non-application
exception; nested exception is:
<openjpa-2.3.0-nonfinal-1540826-r422266:1542644 fatal general error>
org.apache.openjpa.persistence.PersistenceException: Formato stringa di
caratteri non valido per il tipo int.
at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:403)
at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:307)
at
jpa.session.ConsultantStatusFacade$$LocalBeanProxy.findRange(jpa/session/ConsultantStatusFacade.java)
at
jsf.ConsultantStatusController$1.createPageDataModel(ConsultantStatusController.java:62)
at
jsf.ConsultantStatusController.getItems(ConsultantStatusController.java:169)
at
jsf.ConsultantStatusController$$OwbNormalScopeProxy0.getItems(jsf/ConsultantStatusController.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:64)
... 55 more
Caused by: <openjpa-2.3.0-nonfinal-1540826-r422266:1542644 fatal general
error> org.apache.openjpa.persistence.PersistenceException: Formato stringa
di caratteri non valido per il tipo int.
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4974)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4934)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:116)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:68)
at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
at
org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2111)
at
org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:275)
at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:291)
at
jpa.session.ConsultantStatusFacade.findRange(ConsultantStatusFacade.java:51)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:182)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:164)
at
org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:180)
at
org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:99)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:182)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:164)
at
org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:80)
at
org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:212)
at
org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:181)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:268)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:263)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:86)
at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:303)
... 64 more
Caused by: java.sql.SQLDataException: Formato stringa di caratteri non
valido per il tipo int.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.ResultSet.getInt(Unknown Source)
at
org.apache.openjpa.lib.jdbc.DelegatingResultSet.getInt(DelegatingResultSet.java:137)
at
org.apache.openjpa.jdbc.sql.DBDictionary.getInt(DBDictionary.java:839)
at
org.apache.openjpa.jdbc.sql.DBDictionary.getChar(DBDictionary.java:738)
at
org.apache.openjpa.jdbc.sql.ResultSetResult.getCharInternal(ResultSetResult.java:300)
at
org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:377)
at
org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:696)
at
org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.getPrimaryKeyValue(HandlerFieldStrategy.java:328)
at
org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:188)
at
org.apache.openjpa.jdbc.meta.ClassMapping.getObjectId(ClassMapping.java:147)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1023)
at
org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:280)
at
org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2383)
at
org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:274)
at
org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.getResultObject(InstanceResultObjectProvider.java:60)
at
org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.getResultObject(QueryImpl.java:2075)
at
org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36)
... 93 more
Caused by: org.apache.derby.client.am.SqlException: Formato stringa di
caratteri non valido per il tipo int.
at org.apache.derby.client.am.CrossConverters.getIntFromString(Unknown
Source)
at org.apache.derby.client.am.Cursor.getInt(Unknown Source)
... 110 more
Caused by: java.lang.NumberFormatException: A
at org.apache.derby.client.am.CrossConverters.parseInt(Unknown Source)
... 112 more
--
View this message in context:
http://openejb.979440.n4.nabble.com/error-from-a-ID-of-entity-java-lang-NumberFormatException-A-at-org-apache-derby-client-am-CrossConve-tp4667560.html
Sent from the OpenEJB User mailing list archive at Nabble.com.
