Databases
StackOverflow2013
Postsdbo
POjsp threw exception: javax.el.PropertyNotFoundException in spring 3
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjsp threw exception: javax.el.PropertyNotFoundException in spring 3
    primarykey
    data
    text
    <p>I am getting error when fetching property from my entity class. below is the code. This is my Entity class.</p> <pre><code> @NamedQueries({ @NamedQuery( name = "findAllProduct", //query = "from Product_Catalog prc where prc.id = :productCatalogId" query = "from Product_Catalog" ) }) @Entity public class Product_Catalog extends baseEntity.Entity { @Id @Column(name="Product_Catalog_Id") private int productCatalogId ; @Column(name="Max_Price") private float maxPrice ; @Column(name="Min_Price") private float minPrice; //setters and getters below } </code></pre> <p>DAO / service class similar:-</p> <pre><code>import java.util.List; import com.ecom.data.entities.product.Product_Catalog; public interface ProductDAO { public List&lt;Product_Catalog&gt; getAllProduct(); } </code></pre> <p>DAO Implement:-</p> <pre><code>@Repository public class ProductDaoImpl implements ProductDAO { @Autowired private SessionFactory sessionFactory; @SuppressWarnings("unchecked") @Override public List&lt;Product_Catalog&gt; getAllProduct(){ return this.sessionFactory.getCurrentSession().getNamedQuery("findAllProduct").list(); } } </code></pre> <p>Service Implementation:-</p> <pre><code>@Service public class ProductServiceImpl implements ProductService { @Autowired private ProductDAO productDAO; @Override @Transactional public List&lt;Product_Catalog&gt; getAllProduct(){ return productDAO.getAllProduct(); } } </code></pre> <p>ProductController class:-</p> <pre><code>@Controller public class ProductController { @Autowired private ProductService productService; @RequestMapping(value = "/", method = RequestMethod.GET) public String listProducts(ModelMap map) { map.addAttribute("product", new Product_Catalog()); map.addAttribute("productList", productService.getAllProduct()); return "productList"; } } </code></pre> <p>Below is jsp code where i want to display only list from Database table:-</p> <pre><code>&lt;body&gt; &lt;h2&gt;Product List&lt;/h2&gt; &lt;h3&gt;Products&lt;/h3&gt; &lt;c:if test="${!empty productList}"&gt; &lt;table class="data"&gt; &lt;tr&gt; &lt;th&gt;Max Price&lt;/th&gt; &lt;th&gt;Min_Price&lt;/th&gt; &lt;th&gt;&amp;nbsp;&lt;/th&gt; &lt;/tr&gt; &lt;c:forEach items="${productList}" var="product"&gt; &lt;tr&gt; &lt;td&gt;${product.maxPrice}&lt;/td&gt; &lt;td&gt;${product.minPrice}&lt;/td&gt; &lt;%-- &lt;td&gt;&lt;a href="delete/${prd.id}"&gt;delete&lt;/a&gt;&lt;/td&gt; --%&gt; &lt;/tr&gt; &lt;/c:forEach&gt; &lt;/table&gt; &lt;/c:if&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>I am getting exception after deployement of war at Jboss server.</p> <pre><code>12:38:33,301 INFO [org.jboss.web] (MSC service thread 1-2) registering web context: /usermanagement 12:38:33,334 INFO [org.jboss.as.server.controller] (DeploymentScanner-threads - 2) Deployed "usermanagement.war" 12:38:49,360 INFO [stdout] (http--127.0.0.1-8080-1) Hibernate: 12:38:49,361 INFO [stdout] (http--127.0.0.1-8080-1) select 12:38:49,361 INFO [stdout] (http--127.0.0.1-8080-1) product_ca0_.Product_Catalog_Id as Product1_12_, 12:38:49,361 INFO [stdout] (http--127.0.0.1-8080-1) product_ca0_.Aud_Create_Time as Aud2_12_, 12:38:49,362 INFO [stdout] (http--127.0.0.1-8080-1) product_ca0_.Aud_Update_Time as Aud3_12_, 12:38:49,362 INFO [stdout] (http--127.0.0.1-8080-1) product_ca0_.Is_Active as Is4_12_, 12:38:49,362 INFO [stdout] (http--127.0.0.1-8080-1) product_ca0_.Is_Requester_Product as Is5_12_, 12:38:49,362 INFO [stdout] (http--127.0.0.1-8080-1) product_ca0_.Max_Price as Max6_12_, 12:38:49,363 INFO [stdout] (http--127.0.0.1-8080-1) product_ca0_.Min_Price as Min7_12_, 12:38:49,363 INFO [stdout] (http--127.0.0.1-8080-1) product_ca0_.Requirement_Type_Id as Requirem8_12_ 12:38:49,363 INFO [stdout] (http--127.0.0.1-8080-1) from 12:38:49,364 INFO [stdout] (http--127.0.0.1-8080-1) Product_Catalog product_ca0_ 12:38:49,415 INFO [stdout] (http--127.0.0.1-8080-1) Hibernate: 12:38:49,415 INFO [stdout] (http--127.0.0.1-8080-1) select 12:38:49,415 INFO [stdout] (http--127.0.0.1-8080-1) requiremen0_.Requirement_Type_Id as Requirem1_15_0_, 12:38:49,415 INFO [stdout] (http--127.0.0.1-8080-1) requiremen0_.Description as Descript2_15_0_ 12:38:49,416 INFO [stdout] (http--127.0.0.1-8080-1) from 12:38:49,416 INFO [stdout] (http--127.0.0.1-8080-1) Requirement_type requiremen0_ 12:38:49,416 INFO [stdout] (http--127.0.0.1-8080-1) where 12:38:49,416 INFO [stdout] (http--127.0.0.1-8080-1) requiremen0_.Requirement_Type_Id=? 12:38:49,981 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/usermanagement].[jsp]] (http--127.0.0.1-8080-1) Servlet.service() for servlet jsp threw exception: javax.el.PropertyNotFoundException: The class 'com.ecom.data.entities.product.Product_Catalog' does not have the property 'maxPrice'. at javax.el.BeanELResolver.getBeanProperty(BeanELResolver.java:661) [jboss-el-api_2.2_spec-1.0.0.Final.jar:1.0.0.Final] at javax.el.BeanELResolver.getValue(BeanELResolver.java:290) [jboss-el-api_2.2_spec-1.0.0.Final.jar:1.0.0.Final] at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) [jboss-el-api_2.2_spec-1.0.0.Final.jar:1.0.0.Final] at org.apache.el.parser.AstValue.getValue(AstValue.java:134) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:187) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:935) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.jsp.WEB_002dINF.views.productList_jsp._jspx_meth_c_005fforEach_005f0(productList_jsp.java:152) at org.apache.jsp.WEB_002dINF.views.productList_jsp._jspx_meth_c_005fif_005f0(productList_jsp.java:114) at org.apache.jsp.WEB_002dINF.views.productList_jsp._jspService(productList_jsp.java:76) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:253) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:734) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:541) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:479) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:407) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:238) [spring-webmvc-3.2.2.RELEASE.jar:] at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:264) [spring-webmvc-3.2.2.RELEASE.jar:] at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1208) [spring-webmvc-3.2.2.RELEASE.jar:] at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:992) [spring-webmvc-3.2.2.RELEASE.jar:] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:939) [spring-webmvc-3.2.2.RELEASE.jar:] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) [spring-webmvc-3.2.2.RELEASE.jar:] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936) [spring-webmvc-3.2.2.RELEASE.jar:] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827) [spring-webmvc-3.2.2.RELEASE.jar:] at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812) [spring-webmvc-3.2.2.RELEASE.jar:] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final] at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952) [jbossweb-7.0.1.Final.jar:7.0.2.Final] at java.lang.Thread.run(Thread.java:662) [:1.6.0_43] </code></pre> <p>Please help me to find out the issue because i didnt get any final solution after searching on google too. Thanks in advance for all you guys. looking forward to hear you.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAskSharma
    1. USAskSharma
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload