Hi
Does it work without el? I guess thats an issue in derby dictiinnary config
Le 8 févr. 2014 10:58, "mauro2java2011" <[email protected]> a écrit :
> 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.
>
