An Error Occurred:

/WEB-INF/facelets/tags/listProducts.xhtml @19,72 items="#{product.products}": Exception getting value of property products of base of type : com.orangesoft.catalogo.web.controller.ProductsListController

+ Stack Trace

javax.el.ELException: /WEB-INF/facelets/tags/listProducts.xhtml @19,72 items="#{product.products}": Exception getting value of property products of base of type : com.orangesoft.catalogo.web.controller.ProductsListController
	at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
	at com.sun.facelets.tag.jstl.core.ForEachHandler.apply(ForEachHandler.java:120)
	at com.sun.facelets.tag.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:47)
	at com.sun.facelets.tag.ui.CompositionHandler.apply(CompositionHandler.java:119)
	at com.sun.facelets.compiler.NamespaceHandler.apply(NamespaceHandler.java:49)
	at com.sun.facelets.compiler.EncodingHandler.apply(EncodingHandler.java:25)
	at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:248)
	at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:294)
	at com.sun.facelets.impl.DefaultFaceletContext.includeFacelet(DefaultFaceletContext.java:240)
	at com.sun.facelets.tag.UserTagHandler.apply(UserTagHandler.java:81)
	at com.sun.facelets.tag.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:47)
	at com.sun.facelets.tag.jsf.ComponentHandler.applyNextHandler(ComponentHandler.java:314)
	at com.sun.facelets.tag.jsf.ComponentHandler.apply(ComponentHandler.java:169)
	at com.sun.facelets.tag.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:47)
	at com.sun.facelets.tag.ui.DefineHandler.apply(DefineHandler.java:58)
	at com.sun.facelets.tag.ui.CompositionHandler.apply(CompositionHandler.java:128)
	at com.sun.facelets.impl.DefaultFaceletContext$TemplateManager.apply(DefaultFaceletContext.java:306)
	at com.sun.facelets.impl.DefaultFaceletContext.includeDefinition(DefaultFaceletContext.java:279)
	at com.sun.facelets.tag.ui.InsertHandler.apply(InsertHandler.java:68)
	at com.sun.facelets.tag.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:47)
	at com.sun.facelets.tag.jsf.core.ViewHandler.apply(ViewHandler.java:109)
	at com.sun.facelets.tag.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:47)
	at com.sun.facelets.compiler.NamespaceHandler.apply(NamespaceHandler.java:49)
	at com.sun.facelets.tag.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:47)
	at com.sun.facelets.compiler.EncodingHandler.apply(EncodingHandler.java:25)
	at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:248)
	at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:294)
	at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:273)
	at com.sun.facelets.impl.DefaultFaceletContext.includeFacelet(DefaultFaceletContext.java:143)
	at com.sun.facelets.tag.ui.CompositionHandler.apply(CompositionHandler.java:113)
	at com.sun.facelets.compiler.NamespaceHandler.apply(NamespaceHandler.java:49)
	at com.sun.facelets.compiler.EncodingHandler.apply(EncodingHandler.java:25)
	at com.sun.facelets.impl.DefaultFacelet.apply(DefaultFacelet.java:95)
	at com.sun.facelets.FaceletViewHandler.buildView(FaceletViewHandler.java:503)
	at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:546)
	at com.orangesoft.commons.jsf.DynamicViewHandler.renderView(DynamicViewHandler.java:179)
	at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:41)
	at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:132)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:140)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
	at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334)
	at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126)
	at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
	at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
	at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
	at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
	at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:361)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
	at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
	at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:324)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
	at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:864)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:533)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:207)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:403)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:522)
Caused by: javax.faces.el.EvaluationException: Bean: com.orangesoft.catalogo.web.controller.ProductsListController, property: products
	at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:461)
	at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:85)
	at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:141)
	at com.sun.el.parser.AstValue.getValue(AstValue.java:118)
	at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:192)
	at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
	... 68 more
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.GeneratedMethodAccessor214180.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:457)
	... 73 more
Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b41-beta2 (03/30/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Got error 28 from storage engine
Error Code: 1030
Call: SELECT DISTINCT t0.id, t0.update_date, t0.url_ibv, t0.creation_date, t0.OBSERVATIONS, t0.MODEL, t0.iso_level_id, t0.DESCRIPTION, t0.NAME FROM product t0, product_organization t1 WHERE ((t1.organization_id = ?) AND ((t1.product_id = t0.id) AND (t1.iso_level_id = t0.iso_level_id)))
	bind => [280]
Query: ReportQuery(com.orangesoft.catalogo.model.Product)
	at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:304)
	at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
	at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
	at oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
	at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
	at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
	at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
	at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
	at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2240)
	at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2206)
	at oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuery(ReportQuery.java:774)
	at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
	at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
	at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
	at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
	at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
	at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:346)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:453)
	at com.orangesoft.catalogo.services.CatalogServiceImpl.findProductsByOrganization(CatalogServiceImpl.java:215)
	at com.orangesoft.catalogo.web.controller.ProductsListController.findProductsByOrganization(ProductsListController.java:89)
	at com.orangesoft.catalogo.web.controller.ProductsListController.getProducts(ProductsListController.java:60)
	... 77 more
Caused by: java.sql.SQLException: Got error 28 from storage engine
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
	at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
	at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1253)
	at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
	at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
	... 97 more

+ Component Tree

<UIViewRoot locale="en_US" renderKitId="HTML_BASIC" rendered="true" transient="false" viewId="/organization.xhtml">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >
<html xml:lang="es" lang="es" xmlns="http://www.w3.org/1999/xhtml">
<head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title>
<HtmlOutputFormat escape="false" id="_id3" rendered="true" transient="false" value="Empresa {0}">
<UIParameter id="_id4" rendered="true" transient="false" value="NICE AUTOMATISMOS ESPAÑA"/>
</HtmlOutputFormat>
<HtmlOutputFormat escape="false" id="_id5" rendered="false" transient="false" value="Empresa {0} (página {1})">
<UIParameter id="_id6" rendered="true" transient="false" value="NICE AUTOMATISMOS ESPAÑA"/>
<UIParameter id="_id7" rendered="true" transient="false" value="1"/>
</HtmlOutputFormat>
</title> <link rel="start" title="Página de inicio" href="#{facesContext.externalContext.requestContextPath}/"/> <link rel="shortcut icon" type="image/x-icon" href="#{facesContext.externalContext.requestContextPath}/images/favicon.ico"/> <link rel="stylesheet" type="text/css" href="#{facesContext.externalContext.requestContextPath}/styles/catalogo.css"/> </head> <body id="#{bodyId}"> <!-- Jello mold --> <div id="sizer"> <div id="expander"> <!-- Header --> <div id="header" class="clearfix"> <h1><a rel="start" href="#{facesContext.externalContext.requestContextPath}/" title="#{msg['catalog.site.name.title']}"><span>#{msg['catalog.site.name']}</span></a></h1> <a id="skip" href="#content" title="#{msg['catalog.skip.link.title']}"> #{msg['catalog.skip.link']}</a> </div> <div id="menu" class="clearfix"> <!-- Site info --> <ul id="info"> <li><a href="#{facesContext.externalContext.requestContextPath}/accessibility.jsf" title="#{msg['catalog.accessibility.link.title']}">#{msg['catalog.accessibility.link']}</a></li> <li>
<HtmlOutputLink id="_id9" rendered="true" title="Ponte en contacto con los responsables del sitio" transient="false" value="/contact.jsf">
#{msg['catalog.contact.link']}
</HtmlOutputLink>
</li> </ul> <!-- Navigation --> <ul id="navigation"> <li>
<HtmlOutputLink id="_id12" rendered="true" title="Información sobre el Catálogo" transient="false" value="/about.jsf">
#{msg['catalog.about.link']}
</HtmlOutputLink>
</li> <li>
<HtmlOutputLink id="_id15" rendered="true" title="Preguntas más frecuentes sobre el Catálogo" transient="false" value="/faq.jsf">
#{msg['catalog.faq.link']}
</HtmlOutputLink>
</li> </ul> </div> <div id="wrapper" class="clearfix"> <!-- Search --> <div id="search">
<HtmlForm enctype="application/x-www-form-urlencoded" id="searchForm" rendered="true" submitted="false" transient="false">
<HtmlInputText disabled="false" id="query" immediate="false" localValueSet="false" maxlength="-2147483648" readonly="false" rendered="true" required="false" size="50" styleClass="text" transient="false" valid="true"/>
<HtmlCommandButton action="#{search.search}" disabled="false" id="_id18" immediate="false" readonly="false" rendered="true" styleClass="button" transient="false" type="submit" value="Buscar en el Catálogo"/>
</HtmlForm>
</div> <!-- Main content --> <div id="content">
<!-- Breadcrumb --> <div id="breadcrumb"> <ul> <li>
<HtmlOutputLink id="_id21" rendered="true" transient="false" value="/">
Inicio
</HtmlOutputLink>
> <ul> <li>
<HtmlOutputLink id="_id24" rendered="true" transient="false" value="/organizations.jsf">
Empresas
</HtmlOutputLink>
> </li> </ul> </li> </ul> </div> <h2>
<HtmlOutputText escape="true" id="_id27" rendered="true" transient="false" value="NICE AUTOMATISMOS ESPAÑA"/>
</h2> <!-- #{catalog.organization.name} hCard --> <div class="vcard"> <div class="fn org">#{catalog.organization.name}</div> <div class="addr">
<ComponentRef id="_id29" rendered="true" transient="false">
<span class="street-address">#{catalog.organization.street}</span>
</ComponentRef>
<ComponentRef id="_id31" rendered="true" transient="false">
<span class="locality">#{catalog.organization.town}</span>
</ComponentRef>
<ComponentRef id="_id33" rendered="true" transient="false">
<span class="region">(#{catalog.organization.province})</span>
</ComponentRef>
<ComponentRef id="_id35" rendered="true" transient="false">
<span class="postal-code">#{catalog.organization.postalCode}</span>
</ComponentRef>
<ComponentRef id="_id37" rendered="true" transient="false">
<span class="country-name">#{catalog.organization.country}</span>
</ComponentRef>
</div> <div class="tel">
<ComponentRef id="_id40" rendered="true" transient="false">
<abbr class="type" title="Teléfono">Tel.:</abbr> <span class="value">#{catalog.organization.telephone1}</span>
<ComponentRef id="_id42" rendered="false" transient="false">
- <span class="value">#{catalog.organization.telephone2}</span>
</ComponentRef>
</ComponentRef>
</div> <div class="tel">
<ComponentRef id="_id45" rendered="true" transient="false">
<abbr class="type" title="Fax">Fax:</abbr> <span class="value">#{catalog.organization.fax}</span>
</ComponentRef>
</div>
<ComponentRef id="_id48" rendered="false" transient="false">
<div class="email"><a href="mailto:#{catalog.organization.mail}">#{catalog.organization.mail}</a></div>
</ComponentRef>
<ComponentRef id="_id50" rendered="true" transient="false">
<div class="url"><a href="#{catalog.organization.web}">#{catalog.organization.web}</a></div>
</ComponentRef>
</div>
<HtmlOutputText escape="false" id="_id53" rendered="true" transient="false" value="<a class="up" href="#content" title="vuelve al comienzo de la página">subir</a>"/>
<h3>#{msg['organization.products.header']}</h3>
</UIViewRoot>

+ Scoped Variables

Request Parameters
NameValue
organizationId280
Request Attributes
NameValue
catalogcom.orangesoft.catalogo.web.controller.CatalogController@7ed50a
jsf_sequence1
msgcom.sun.facelets.tag.jsf.core.LoadBundleHandler$ResourceBundleMap@d486da
productcom.orangesoft.catalogo.web.controller.ProductsListController@e18c15
searchcom.orangesoft.catalogo.web.controller.SearchController@1b3bf5b
Session Attributes
NameValue
jsf_sequence1
Application Attributes
NameValue
nutchBeanorg.apache.nutch.searcher.NutchBean@c4a4b1
May 3, 2015 1:50:57 PM - Generated by Facelets