Users - Problems with entity-view
Locked
Reply |
Threaded
Open this post in threaded view
|
More ♦
♦
| Loading... |
| Reply to author |
| Edit post |
| Move post |
| Delete this post |
| Delete this post and replies |
| Change post date |
| Print post |
| Permalink |
| Raw mail |
       |
Jan 12, 2006; 8:53am
Users - Problems with entity-view
 
14 posts
|
Hello,
I changed my entity-view and now I get a new error-message. I don't know why I get this error. Could someone help me please? My definition of the view: ------------------------------------- <view-entity entity-name="testview" package-name="org.ofbiz.order.order" never-cache="true" title="my testview"> <member-entity entity-alias="OH" entity-name="OrderHeader"/> <member-entity entity-alias="TO" entity-name="TrackingCodeOrder"/> <alias entity-alias="OH" name="orderId"/> <alias entity-alias="OH" name="orderTypeId"/> <alias entity-alias="OH" name="orderDate"/> <alias entity-alias="OH" name="statusId"/> <alias entity-alias="OH" name="createdBy"/> <alias entity-alias="OH" name="originFacilityId"/> <alias entity-alias="OH" name="productStoreId"/> <alias entity-alias="OH" name="grandTotal"/> <alias entity-alias="TO" name="trackingCodeId"/> <alias entity-alias="TO" name="trackingCodeTypeId"/> <view-link entity-alias="TO" rel-entity-alias="OH"> <key-map field-name="orderId"/> </view-link> </view-entity> ---------------------------------------- Log-file: ---- exception report ---------------------------------------------------------- Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:SELECT COUNT(*) FROM TRACKING_CODE_ORDER TO INNER JOIN ORDER_HEADER OH ON TO.ORDER_ID = OH.ORDER_ID ([-3008] (at 43): Invalid keyword or missing delimiter) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT COUNT(*) FROM TRACKING_CODE_ORDER TO INNER JOIN ORDER_HEADER OH ON TO.ORDER_ID = OH.ORDER_ID ([-3008] (at 43): Invalid keyword or missing delimiter) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:386) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:351) org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:967) org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(GenericHelperDAO.java:195) org.ofbiz.entity.GenericDelegator.findCountByCondition(GenericDelegator.java:1146) org.apache.jsp.entity.FindGeneric_jsp._jspService(FindGeneric_jsp.java:160) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:590) org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:510) org.ofbiz.content.webapp.view.JspViewHandler.render(JspViewHandler.java:86) org.ofbiz.content.webapp.region.Section.viewHandlerRender(Section.java:174) org.ofbiz.content.webapp.region.Section.render(Section.java:156) org.ofbiz.content.webapp.region.Section.render(Section.java:81) org.ofbiz.content.webapp.region.RenderTag.doEndTag(RenderTag.java:108) org.apache.jsp.templates.main_005ftemplate_jsp._jspx_meth_region_render_5(main_005ftemplate_jsp.java:283) org.apache.jsp.templates.main_005ftemplate_jsp._jspService(main_005ftemplate_jsp.java:162) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:590) org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:510) org.ofbiz.content.webapp.region.Region.render(Region.java:125) org.ofbiz.content.webapp.view.RegionViewHandler.render(RegionViewHandler.java:97) org.ofbiz.content.webapp.control.RequestHandler.renderView(RequestHandler.java:551) org.ofbiz.content.webapp.control.RequestHandler.doRequest(RequestHandler.java:352) org.ofbiz.content.webapp.control.ControlServlet.doGet(ControlServlet.java:186) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) org.ofbiz.content.webapp.control.ContextFilter.doFilter(ContextFilter.java:237) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) java.lang.Thread.run(Thread.java:534) com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3008] (at 43): Invalid keyword or missing delimiter com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69) com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:768) com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:434) com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1498) com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:725) com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:224) com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:175) com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:96) com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:677) org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.prepareStatement(XAClientConnection.java:409) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:374) org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:351) org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:967) org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition(GenericHelperDAO.java:195) org.ofbiz.entity.GenericDelegator.findCountByCondition(GenericDelegator.java:1146) org.apache.jsp.entity.FindGeneric_jsp._jspService(FindGeneric_jsp.java:160) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:590) org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:510) org.ofbiz.content.webapp.view.JspViewHandler.render(JspViewHandler.java:86) org.ofbiz.content.webapp.region.Section.viewHandlerRender(Section.java:174) org.ofbiz.content.webapp.region.Section.render(Section.java:156) org.ofbiz.content.webapp.region.Section.render(Section.java:81) org.ofbiz.content.webapp.region.RenderTag.doEndTag(RenderTag.java:108) org.apache.jsp.templates.main_005ftemplate_jsp._jspx_meth_region_render_5(main_005ftemplate_jsp.java:283) org.apache.jsp.templates.main_005ftemplate_jsp._jspService(main_005ftemplate_jsp.java:162) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:590) org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:510) org.ofbiz.content.webapp.region.Region.render(Region.java:125) org.ofbiz.content.webapp.view.RegionViewHandler.render(RegionViewHandler.java:97) org.ofbiz.content.webapp.control.RequestHandler.renderView(RequestHandler.java:551) org.ofbiz.content.webapp.control.RequestHandler.doRequest(RequestHandler.java:352) org.ofbiz.content.webapp.control.ControlServlet.doGet(ControlServlet.java:186) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) org.ofbiz.content.webapp.control.ContextFilter.doFilter(ContextFilter.java:237) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535) org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) java.lang.Thread.run(Thread.java:534) -------------------------------------------------------------------------------- Kind regards Dimitri How about a little more of your log message?? u.dimi at gmx.de wrote: >Hello all, > >could someone please help me with one "small" entity-view? > >What is wrong with the definition of my view? > >I have to member entities (OrderHeader, TrackingCodeOrder) and as result I >always get one java.lang.NullPointerException > >---------------------------- > ><view-entity entity-name="testview" > package-name="org.ofbiz.order.order" > never-cache="true" > title="testview test"> > <member-entity entity-alias="OH" entity-name="OrderHeader"/> > <member-entity entity-alias="TO" entity-name="TrackingCodeOrder"/> > <alias entity-alias="OH" name="orderId"/> > <alias entity-alias="OH" name="orderTypeId"/> > <alias entity-alias="OH" name="orderDate"/> > <alias entity-alias="OH" name="statusId"/> > <alias entity-alias="OH" name="createdBy"/> > <alias entity-alias="OH" name="originFacilityId"/> > <alias entity-alias="OH" name="productStoreId"/> > <alias entity-alias="OH" name="grandTotal"/> > <alias entity-alias="TO" name="trackingCodeId"/> > <alias entity-alias="TO" name="trackingCodeTypeId"/> > <view-link entity-alias="OH" rel-entity-alias="TO"> > <key-map field-name="orderId"/> > <key-map field-name="trackingCodeTypeId"/> > </view-link> > </view-entity> > >------------------------- > >Kind regards > >_______________________________________________ >Users mailing list >Users at lists.ofbiz.org >http://lists.ofbiz.org/mailman/listinfo/users > > > ... [show rest of quote]
_______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Reply |
Threaded
Open this post in threaded view
|
More ♦
♦
| Loading... |
| Reply to author |
| Edit post |
| Move post |
| Delete this post |
| Delete this post and replies |
| Change post date |
| Print post |
| Permalink |
| Raw mail |
| |
Jan 12, 2006; 9:15am
Re: Users - Problems with entity-view
|
1146 posts
|
Are you getting this error with any other view entities? It looks like use are using either SAP DB or the MySQL MaxDB, is that correct? Are you using settings based on the in the example settings in the entityengine.xml file for SAP DB? -David On Jan 12, 2006, at 1:53 AM, Dimitri Unruh wrote: > Hello, > > I changed my entity-view and now I get a new error-message. I don't > know why > I get this error. > Could someone help me please? > > My definition of the view: > ------------------------------------- > <view-entity entity-name="testview" > package-name="org.ofbiz.order.order" > never-cache="true" > title="my testview"> > <member-entity entity-alias="OH" entity-name="OrderHeader"/> > <member-entity entity-alias="TO" entity- > name="TrackingCodeOrder"/> > <alias entity-alias="OH" name="orderId"/> > <alias entity-alias="OH" name="orderTypeId"/> > <alias entity-alias="OH" name="orderDate"/> > <alias entity-alias="OH" name="statusId"/> > <alias entity-alias="OH" name="createdBy"/> > <alias entity-alias="OH" name="originFacilityId"/> > <alias entity-alias="OH" name="productStoreId"/> > <alias entity-alias="OH" name="grandTotal"/> > <alias entity-alias="TO" name="trackingCodeId"/> > <alias entity-alias="TO" name="trackingCodeTypeId"/> > <view-link entity-alias="TO" rel-entity-alias="OH"> > <key-map field-name="orderId"/> > </view-link> > </view-entity> > > > ---------------------------------------- > > Log-file: > > > ---- exception report > ---------------------------------------------------------- > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception while executing the following:SELECT COUNT > (*) FROM > TRACKING_CODE_ORDER TO INNER JOIN ORDER_HEADER OH ON TO.ORDER_ID = > OH.ORDER_ID ([-3008] (at 43): Invalid keyword or missing delimiter) > ---- stack trace > --------------------------------------------------------------- > org.ofbiz.entity.GenericDataSourceException: SQL Exception while > executing > the following:SELECT COUNT(*) FROM TRACKING_CODE_ORDER TO INNER JOIN > ORDER_HEADER OH ON TO.ORDER_ID = OH.ORDER_ID ([-3008] (at 43): Invalid > keyword or missing > delimiter) > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement > (SQLProcessor.java:386) > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement > (SQLProcessor.java:351) > org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition > (GenericDAO.java:967) > org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition > (GenericHelperDAO.java:195) > org.ofbiz.entity.GenericDelegator.findCountByCondition > (GenericDelegator.java:1146) > org.apache.jsp.entity.FindGeneric_jsp._jspService > (FindGeneric_jsp.java:160) > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.jasper.servlet.JspServletWrapper.service > (JspServletWrapper.java:324) > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: > 292) > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:237) > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:157) > org.apache.catalina.core.ApplicationDispatcher.invoke > (ApplicationDispatcher.java:704) > org.apache.catalina.core.ApplicationDispatcher.doInclude > (ApplicationDispatcher.java:590) > org.apache.catalina.core.ApplicationDispatcher.include > (ApplicationDispatcher.java:510) > org.ofbiz.content.webapp.view.JspViewHandler.render > (JspViewHandler.java:86) > org.ofbiz.content.webapp.region.Section.viewHandlerRender > (Section.java:174) > org.ofbiz.content.webapp.region.Section.render(Section.java:156) > org.ofbiz.content.webapp.region.Section.render(Section.java:81) > org.ofbiz.content.webapp.region.RenderTag.doEndTag(RenderTag.java:108) > org.apache.jsp.templates.main_005ftemplate_jsp._jspx_meth_region_rende > r_5(main_005ftemplate_jsp.java:283) > org.apache.jsp.templates.main_005ftemplate_jsp._jspService > (main_005ftemplate_jsp.java:162) > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.jasper.servlet.JspServletWrapper.service > (JspServletWrapper.java:324) > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: > 292) > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:237) > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:157) > org.apache.catalina.core.ApplicationDispatcher.invoke > (ApplicationDispatcher.java:704) > org.apache.catalina.core.ApplicationDispatcher.doInclude > (ApplicationDispatcher.java:590) > org.apache.catalina.core.ApplicationDispatcher.include > (ApplicationDispatcher.java:510) > org.ofbiz.content.webapp.region.Region.render(Region.java:125) > org.ofbiz.content.webapp.view.RegionViewHandler.render > (RegionViewHandler.java:97) > org.ofbiz.content.webapp.control.RequestHandler.renderView > (RequestHandler.java:551) > org.ofbiz.content.webapp.control.RequestHandler.doRequest > (RequestHandler.java:352) > org.ofbiz.content.webapp.control.ControlServlet.doGet > (ControlServlet.java:186) > javax.servlet.http.HttpServlet.service(HttpServlet.java:689) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:237) > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:157) > org.ofbiz.content.webapp.control.ContextFilter.doFilter > (ContextFilter.java:237) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:186) > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:157) > org.apache.catalina.core.StandardWrapperValve.invoke > (StandardWrapperValve.java:214) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:104) > org.apache.catalina.core.StandardPipeline.invoke > (StandardPipeline.java:520) > org.apache.catalina.core.StandardContextValve.invokeInternal > (StandardContextValve.java:198) > org.apache.catalina.core.StandardContextValve.invoke > (StandardContextValve.java:152) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:104) > org.apache.catalina.core.StandardPipeline.invoke > (StandardPipeline.java:520) > org.apache.catalina.core.StandardHostValve.invoke > (StandardHostValve.java:137) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:104) > org.apache.catalina.valves.ErrorReportValve.invoke > (ErrorReportValve.java:118) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:102) > org.apache.catalina.core.StandardPipeline.invoke > (StandardPipeline.java:520) > org.apache.catalina.core.StandardEngineValve.invoke > (StandardEngineValve.java:109) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:104) > org.apache.catalina.valves.AccessLogValve.invoke > (AccessLogValve.java:535) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:102) > org.apache.catalina.core.StandardPipeline.invoke > (StandardPipeline.java:520) > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java: > 160) > org.apache.coyote.http11.Http11Processor.process > (Http11Processor.java:799) > org.apache.coyote.http11.Http11Protocol > $Http11ConnectionHandler.processConnection(Http11Protocol.java:705) > org.apache.tomcat.util.net.TcpWorkerThread.runIt > (PoolTcpEndpoint.java:577) > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run > (ThreadPool.java:683) > java.lang.Thread.run(Thread.java:534) > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3008] (at 43): > Invalid > keyword or missing > delimiter > com.sap.dbtech.jdbc.packet.ReplyPacket.createException > (ReplyPacket.java:69) > com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError > (ConnectionSapDB.java:768) > com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:434) > com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand > (CallableStatementSapDB.java:1498) > com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:725) > com.sap.dbtech.jdbc.CallableStatementSapDB.doParse > (CallableStatementSapDB.java:224) > com.sap.dbtech.jdbc.CallableStatementSapDB.constructor > (CallableStatementSapDB.java:175) > com.sap.dbtech.jdbc.CallableStatementSapDB.<init> > (CallableStatementSapDB.java:96) > com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement > (ConnectionSapDB.java:677) > org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.prepareState > ment(XAClientConnection.java:409) > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement > (SQLProcessor.java:374) > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement > (SQLProcessor.java:351) > org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition > (GenericDAO.java:967) > org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition > (GenericHelperDAO.java:195) > org.ofbiz.entity.GenericDelegator.findCountByCondition > (GenericDelegator.java:1146) > org.apache.jsp.entity.FindGeneric_jsp._jspService > (FindGeneric_jsp.java:160) > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.jasper.servlet.JspServletWrapper.service > (JspServletWrapper.java:324) > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: > 292) > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:237) > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:157) > org.apache.catalina.core.ApplicationDispatcher.invoke > (ApplicationDispatcher.java:704) > org.apache.catalina.core.ApplicationDispatcher.doInclude > (ApplicationDispatcher.java:590) > org.apache.catalina.core.ApplicationDispatcher.include > (ApplicationDispatcher.java:510) > org.ofbiz.content.webapp.view.JspViewHandler.render > (JspViewHandler.java:86) > org.ofbiz.content.webapp.region.Section.viewHandlerRender > (Section.java:174) > org.ofbiz.content.webapp.region.Section.render(Section.java:156) > org.ofbiz.content.webapp.region.Section.render(Section.java:81) > org.ofbiz.content.webapp.region.RenderTag.doEndTag(RenderTag.java:108) > org.apache.jsp.templates.main_005ftemplate_jsp._jspx_meth_region_rende > r_5(main_005ftemplate_jsp.java:283) > org.apache.jsp.templates.main_005ftemplate_jsp._jspService > (main_005ftemplate_jsp.java:162) > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.jasper.servlet.JspServletWrapper.service > (JspServletWrapper.java:324) > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: > 292) > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:237) > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:157) > org.apache.catalina.core.ApplicationDispatcher.invoke > (ApplicationDispatcher.java:704) > org.apache.catalina.core.ApplicationDispatcher.doInclude > (ApplicationDispatcher.java:590) > org.apache.catalina.core.ApplicationDispatcher.include > (ApplicationDispatcher.java:510) > org.ofbiz.content.webapp.region.Region.render(Region.java:125) > org.ofbiz.content.webapp.view.RegionViewHandler.render > (RegionViewHandler.java:97) > org.ofbiz.content.webapp.control.RequestHandler.renderView > (RequestHandler.java:551) > org.ofbiz.content.webapp.control.RequestHandler.doRequest > (RequestHandler.java:352) > org.ofbiz.content.webapp.control.ControlServlet.doGet > (ControlServlet.java:186) > javax.servlet.http.HttpServlet.service(HttpServlet.java:689) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:237) > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:157) > org.ofbiz.content.webapp.control.ContextFilter.doFilter > (ContextFilter.java:237) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:186) > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:157) > org.apache.catalina.core.StandardWrapperValve.invoke > (StandardWrapperValve.java:214) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:104) > org.apache.catalina.core.StandardPipeline.invoke > (StandardPipeline.java:520) > org.apache.catalina.core.StandardContextValve.invokeInternal > (StandardContextValve.java:198) > org.apache.catalina.core.StandardContextValve.invoke > (StandardContextValve.java:152) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:104) > org.apache.catalina.core.StandardPipeline.invoke > (StandardPipeline.java:520) > org.apache.catalina.core.StandardHostValve.invoke > (StandardHostValve.java:137) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:104) > org.apache.catalina.valves.ErrorReportValve.invoke > (ErrorReportValve.java:118) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:102) > org.apache.catalina.core.StandardPipeline.invoke > (StandardPipeline.java:520) > org.apache.catalina.core.StandardEngineValve.invoke > (StandardEngineValve.java:109) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:104) > org.apache.catalina.valves.AccessLogValve.invoke > (AccessLogValve.java:535) > org.apache.catalina.core.StandardValveContext.invokeNext > (StandardValveContext.java:102) > org.apache.catalina.core.StandardPipeline.invoke > (StandardPipeline.java:520) > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java: > 160) > org.apache.coyote.http11.Http11Processor.process > (Http11Processor.java:799) > org.apache.coyote.http11.Http11Protocol > $Http11ConnectionHandler.processConnection(Http11Protocol.java:705) > org.apache.tomcat.util.net.TcpWorkerThread.runIt > (PoolTcpEndpoint.java:577) > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run > (ThreadPool.java:683) > java.lang.Thread.run(Thread.java:534) > ---------------------------------------------------------------------- > ---------- > > > > > Kind regards > > Dimitri > > > How about a little more of your log message?? > > u.dimi at gmx.de wrote: > >> Hello all, >> >> could someone please help me with one "small" entity-view? >> >> What is wrong with the definition of my view? >> >> I have to member entities (OrderHeader, TrackingCodeOrder) and as >> result I >> always get one java.lang.NullPointerException >> >> ---------------------------- >> >> <view-entity entity-name="testview" >> package-name="org.ofbiz.order.order" >> never-cache="true" >> title="testview test"> >> <member-entity entity-alias="OH" entity-name="OrderHeader"/> >> <member-entity entity-alias="TO" entity- >> name="TrackingCodeOrder"/> >> <alias entity-alias="OH" name="orderId"/> >> <alias entity-alias="OH" name="orderTypeId"/> >> <alias entity-alias="OH" name="orderDate"/> >> <alias entity-alias="OH" name="statusId"/> >> <alias entity-alias="OH" name="createdBy"/> >> <alias entity-alias="OH" name="originFacilityId"/> >> <alias entity-alias="OH" name="productStoreId"/> >> <alias entity-alias="OH" name="grandTotal"/> >> <alias entity-alias="TO" name="trackingCodeId"/> >> <alias entity-alias="TO" name="trackingCodeTypeId"/> >> <view-link entity-alias="OH" rel-entity-alias="TO"> >> <key-map field-name="orderId"/> >> <key-map field-name="trackingCodeTypeId"/> >> </view-link> >> </view-entity> >> >> ------------------------- >> >> Kind regards >> >> _______________________________________________ >> Users mailing list >> Users at lists.ofbiz.org >> http://lists.ofbiz.org/mailman/listinfo/users >> >> >> > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users ... [show rest of quote] ... [show rest of quote] _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
smime.p7s (3K)
Reply |
Threaded
Open this post in threaded view
|
More ♦
♦
| Loading... |
| Reply to author |
| Edit post |
| Move post |
| Delete this post |
| Delete this post and replies |
| Change post date |
| Print post |
| Permalink |
| Raw mail |
| |
Jan 12, 2006; 9:22am
Re: Users - Problems with entity-view
|
14 posts
|
Yes, I'm using the SAP DB. I didn't change the settings in the
entityengine.xml. And also there are no problems with other entity-views. So, maybe I have an error in my definition?! But in my opinion the SQL-statement is okay.. Dimitri > --- Ursprüngliche Nachricht --- > Von: "David E. Jones" <[hidden email]> > An: OFBiz Users / Usage Discussion <[hidden email]> > Betreff: Re: [OFBiz] Users - Problems with entity-view > Datum: Thu, 12 Jan 2006 02:15:23 -0700 > > > Are you getting this error with any other view entities? > > It looks like use are using either SAP DB or the MySQL MaxDB, is that > correct? Are you using settings based on the in the example settings > in the entityengine.xml file for SAP DB? > > -David > > > On Jan 12, 2006, at 1:53 AM, Dimitri Unruh wrote: > > > Hello, > > > > I changed my entity-view and now I get a new error-message. I don't > > know why > > I get this error. > > Could someone help me please? > > > > My definition of the view: > > ------------------------------------- > > <view-entity entity-name="testview" > > package-name="org.ofbiz.order.order" > > never-cache="true" > > title="my testview"> > > <member-entity entity-alias="OH" entity-name="OrderHeader"/> > > <member-entity entity-alias="TO" entity- > > name="TrackingCodeOrder"/> > > <alias entity-alias="OH" name="orderId"/> > > <alias entity-alias="OH" name="orderTypeId"/> > > <alias entity-alias="OH" name="orderDate"/> > > <alias entity-alias="OH" name="statusId"/> > > <alias entity-alias="OH" name="createdBy"/> > > <alias entity-alias="OH" name="originFacilityId"/> > > <alias entity-alias="OH" name="productStoreId"/> > > <alias entity-alias="OH" name="grandTotal"/> > > <alias entity-alias="TO" name="trackingCodeId"/> > > <alias entity-alias="TO" name="trackingCodeTypeId"/> > > <view-link entity-alias="TO" rel-entity-alias="OH"> > > <key-map field-name="orderId"/> > > </view-link> > > </view-entity> > > > > > > ---------------------------------------- > > > > Log-file: > > > > > > ---- exception report > > ---------------------------------------------------------- > > Exception: org.ofbiz.entity.GenericDataSourceException > > Message: SQL Exception while executing the following:SELECT COUNT > > (*) FROM > > TRACKING_CODE_ORDER TO INNER JOIN ORDER_HEADER OH ON TO.ORDER_ID = > > OH.ORDER_ID ([-3008] (at 43): Invalid keyword or missing delimiter) > > ---- stack trace > > --------------------------------------------------------------- > > org.ofbiz.entity.GenericDataSourceException: SQL Exception while > > executing > > the following:SELECT COUNT(*) FROM TRACKING_CODE_ORDER TO INNER JOIN > > ORDER_HEADER OH ON TO.ORDER_ID = OH.ORDER_ID ([-3008] (at 43): Invalid > > keyword or missing > > delimiter) > > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement > > (SQLProcessor.java:386) > > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement > > (SQLProcessor.java:351) > > org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition > > (GenericDAO.java:967) > > org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition > > (GenericHelperDAO.java:195) > > org.ofbiz.entity.GenericDelegator.findCountByCondition > > (GenericDelegator.java:1146) > > org.apache.jsp.entity.FindGeneric_jsp._jspService > > (FindGeneric_jsp.java:160) > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.jasper.servlet.JspServletWrapper.service > > (JspServletWrapper.java:324) > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: > > 292) > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > (ApplicationFilterChain.java:237) > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > (ApplicationFilterChain.java:157) > > org.apache.catalina.core.ApplicationDispatcher.invoke > > (ApplicationDispatcher.java:704) > > org.apache.catalina.core.ApplicationDispatcher.doInclude > > (ApplicationDispatcher.java:590) > > org.apache.catalina.core.ApplicationDispatcher.include > > (ApplicationDispatcher.java:510) > > org.ofbiz.content.webapp.view.JspViewHandler.render > > (JspViewHandler.java:86) > > org.ofbiz.content.webapp.region.Section.viewHandlerRender > > (Section.java:174) > > org.ofbiz.content.webapp.region.Section.render(Section.java:156) > > org.ofbiz.content.webapp.region.Section.render(Section.java:81) > > org.ofbiz.content.webapp.region.RenderTag.doEndTag(RenderTag.java:108) > > org.apache.jsp.templates.main_005ftemplate_jsp._jspx_meth_region_rende > > r_5(main_005ftemplate_jsp.java:283) > > org.apache.jsp.templates.main_005ftemplate_jsp._jspService > > (main_005ftemplate_jsp.java:162) > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.jasper.servlet.JspServletWrapper.service > > (JspServletWrapper.java:324) > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: > > 292) > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > (ApplicationFilterChain.java:237) > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > (ApplicationFilterChain.java:157) > > org.apache.catalina.core.ApplicationDispatcher.invoke > > (ApplicationDispatcher.java:704) > > org.apache.catalina.core.ApplicationDispatcher.doInclude > > (ApplicationDispatcher.java:590) > > org.apache.catalina.core.ApplicationDispatcher.include > > (ApplicationDispatcher.java:510) > > org.ofbiz.content.webapp.region.Region.render(Region.java:125) > > org.ofbiz.content.webapp.view.RegionViewHandler.render > > (RegionViewHandler.java:97) > > org.ofbiz.content.webapp.control.RequestHandler.renderView > > (RequestHandler.java:551) > > org.ofbiz.content.webapp.control.RequestHandler.doRequest > > (RequestHandler.java:352) > > org.ofbiz.content.webapp.control.ControlServlet.doGet > > (ControlServlet.java:186) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:689) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > (ApplicationFilterChain.java:237) > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > (ApplicationFilterChain.java:157) > > org.ofbiz.content.webapp.control.ContextFilter.doFilter > > (ContextFilter.java:237) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > (ApplicationFilterChain.java:186) > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > (ApplicationFilterChain.java:157) > > org.apache.catalina.core.StandardWrapperValve.invoke > > (StandardWrapperValve.java:214) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:104) > > org.apache.catalina.core.StandardPipeline.invoke > > (StandardPipeline.java:520) > > org.apache.catalina.core.StandardContextValve.invokeInternal > > (StandardContextValve.java:198) > > org.apache.catalina.core.StandardContextValve.invoke > > (StandardContextValve.java:152) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:104) > > org.apache.catalina.core.StandardPipeline.invoke > > (StandardPipeline.java:520) > > org.apache.catalina.core.StandardHostValve.invoke > > (StandardHostValve.java:137) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:104) > > org.apache.catalina.valves.ErrorReportValve.invoke > > (ErrorReportValve.java:118) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:102) > > org.apache.catalina.core.StandardPipeline.invoke > > (StandardPipeline.java:520) > > org.apache.catalina.core.StandardEngineValve.invoke > > (StandardEngineValve.java:109) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:104) > > org.apache.catalina.valves.AccessLogValve.invoke > > (AccessLogValve.java:535) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:102) > > org.apache.catalina.core.StandardPipeline.invoke > > (StandardPipeline.java:520) > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) > > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java: > > 160) > > org.apache.coyote.http11.Http11Processor.process > > (Http11Processor.java:799) > > org.apache.coyote.http11.Http11Protocol > > $Http11ConnectionHandler.processConnection(Http11Protocol.java:705) > > org.apache.tomcat.util.net.TcpWorkerThread.runIt > > (PoolTcpEndpoint.java:577) > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run > > (ThreadPool.java:683) > > java.lang.Thread.run(Thread.java:534) > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3008] (at 43): > > Invalid > > keyword or missing > > delimiter > > com.sap.dbtech.jdbc.packet.ReplyPacket.createException > > (ReplyPacket.java:69) > > com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError > > (ConnectionSapDB.java:768) > > com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:434) > > com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand > > (CallableStatementSapDB.java:1498) > > com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:725) > > com.sap.dbtech.jdbc.CallableStatementSapDB.doParse > > (CallableStatementSapDB.java:224) > > com.sap.dbtech.jdbc.CallableStatementSapDB.constructor > > (CallableStatementSapDB.java:175) > > com.sap.dbtech.jdbc.CallableStatementSapDB.<init> > > (CallableStatementSapDB.java:96) > > com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement > > (ConnectionSapDB.java:677) > > org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.prepareState > > ment(XAClientConnection.java:409) > > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement > > (SQLProcessor.java:374) > > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement > > (SQLProcessor.java:351) > > org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition > > (GenericDAO.java:967) > > org.ofbiz.entity.datasource.GenericHelperDAO.findCountByCondition > > (GenericHelperDAO.java:195) > > org.ofbiz.entity.GenericDelegator.findCountByCondition > > (GenericDelegator.java:1146) > > org.apache.jsp.entity.FindGeneric_jsp._jspService > > (FindGeneric_jsp.java:160) > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.jasper.servlet.JspServletWrapper.service > > (JspServletWrapper.java:324) > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: > > 292) > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > (ApplicationFilterChain.java:237) > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > (ApplicationFilterChain.java:157) > > org.apache.catalina.core.ApplicationDispatcher.invoke > > (ApplicationDispatcher.java:704) > > org.apache.catalina.core.ApplicationDispatcher.doInclude > > (ApplicationDispatcher.java:590) > > org.apache.catalina.core.ApplicationDispatcher.include > > (ApplicationDispatcher.java:510) > > org.ofbiz.content.webapp.view.JspViewHandler.render > > (JspViewHandler.java:86) > > org.ofbiz.content.webapp.region.Section.viewHandlerRender > > (Section.java:174) > > org.ofbiz.content.webapp.region.Section.render(Section.java:156) > > org.ofbiz.content.webapp.region.Section.render(Section.java:81) > > org.ofbiz.content.webapp.region.RenderTag.doEndTag(RenderTag.java:108) > > org.apache.jsp.templates.main_005ftemplate_jsp._jspx_meth_region_rende > > r_5(main_005ftemplate_jsp.java:283) > > org.apache.jsp.templates.main_005ftemplate_jsp._jspService > > (main_005ftemplate_jsp.java:162) > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.jasper.servlet.JspServletWrapper.service > > (JspServletWrapper.java:324) > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: > > 292) > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > (ApplicationFilterChain.java:237) > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > (ApplicationFilterChain.java:157) > > org.apache.catalina.core.ApplicationDispatcher.invoke > > (ApplicationDispatcher.java:704) > > org.apache.catalina.core.ApplicationDispatcher.doInclude > > (ApplicationDispatcher.java:590) > > org.apache.catalina.core.ApplicationDispatcher.include > > (ApplicationDispatcher.java:510) > > org.ofbiz.content.webapp.region.Region.render(Region.java:125) > > org.ofbiz.content.webapp.view.RegionViewHandler.render > > (RegionViewHandler.java:97) > > org.ofbiz.content.webapp.control.RequestHandler.renderView > > (RequestHandler.java:551) > > org.ofbiz.content.webapp.control.RequestHandler.doRequest > > (RequestHandler.java:352) > > org.ofbiz.content.webapp.control.ControlServlet.doGet > > (ControlServlet.java:186) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:689) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > (ApplicationFilterChain.java:237) > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > (ApplicationFilterChain.java:157) > > org.ofbiz.content.webapp.control.ContextFilter.doFilter > > (ContextFilter.java:237) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > (ApplicationFilterChain.java:186) > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > (ApplicationFilterChain.java:157) > > org.apache.catalina.core.StandardWrapperValve.invoke > > (StandardWrapperValve.java:214) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:104) > > org.apache.catalina.core.StandardPipeline.invoke > > (StandardPipeline.java:520) > > org.apache.catalina.core.StandardContextValve.invokeInternal > > (StandardContextValve.java:198) > > org.apache.catalina.core.StandardContextValve.invoke > > (StandardContextValve.java:152) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:104) > > org.apache.catalina.core.StandardPipeline.invoke > > (StandardPipeline.java:520) > > org.apache.catalina.core.StandardHostValve.invoke > > (StandardHostValve.java:137) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:104) > > org.apache.catalina.valves.ErrorReportValve.invoke > > (ErrorReportValve.java:118) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:102) > > org.apache.catalina.core.StandardPipeline.invoke > > (StandardPipeline.java:520) > > org.apache.catalina.core.StandardEngineValve.invoke > > (StandardEngineValve.java:109) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:104) > > org.apache.catalina.valves.AccessLogValve.invoke > > (AccessLogValve.java:535) > > org.apache.catalina.core.StandardValveContext.invokeNext > > (StandardValveContext.java:102) > > org.apache.catalina.core.StandardPipeline.invoke > > (StandardPipeline.java:520) > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) > > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java: > > 160) > > org.apache.coyote.http11.Http11Processor.process > > (Http11Processor.java:799) > > org.apache.coyote.http11.Http11Protocol > > $Http11ConnectionHandler.processConnection(Http11Protocol.java:705) > > org.apache.tomcat.util.net.TcpWorkerThread.runIt > > (PoolTcpEndpoint.java:577) > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run > > (ThreadPool.java:683) > > java.lang.Thread.run(Thread.java:534) > > ---------------------------------------------------------------------- > > ---------- > > > > > > > > > > Kind regards > > > > Dimitri > > > > > > How about a little more of your log message?? > > > > u.dimi at gmx.de wrote: > > > >> Hello all, > >> > >> could someone please help me with one "small" entity-view? > >> > >> What is wrong with the definition of my view? > >> > >> I have to member entities (OrderHeader, TrackingCodeOrder) and as > >> result I > >> always get one java.lang.NullPointerException > >> > >> ---------------------------- > >> > >> <view-entity entity-name="testview" > >> package-name="org.ofbiz.order.order" > >> never-cache="true" > >> title="testview test"> > >> <member-entity entity-alias="OH" entity-name="OrderHeader"/> > >> <member-entity entity-alias="TO" entity- > >> name="TrackingCodeOrder"/> > >> <alias entity-alias="OH" name="orderId"/> > >> <alias entity-alias="OH" name="orderTypeId"/> > >> <alias entity-alias="OH" name="orderDate"/> > >> <alias entity-alias="OH" name="statusId"/> > >> <alias entity-alias="OH" name="createdBy"/> > >> <alias entity-alias="OH" name="originFacilityId"/> > >> <alias entity-alias="OH" name="productStoreId"/> > >> <alias entity-alias="OH" name="grandTotal"/> > >> <alias entity-alias="TO" name="trackingCodeId"/> > >> <alias entity-alias="TO" name="trackingCodeTypeId"/> > >> <view-link entity-alias="OH" rel-entity-alias="TO"> > >> <key-map field-name="orderId"/> > >> <key-map field-name="trackingCodeTypeId"/> > >> </view-link> > >> </view-entity> > >> > >> ------------------------- > >> > >> Kind regards > >> > >> _______________________________________________ > >> Users mailing list > >> Users at lists.ofbiz.org > >> http://lists.ofbiz.org/mailman/listinfo/users > >> > >> > >> > > > > _______________________________________________ > > Users mailing list > > [hidden email] > > http://lists.ofbiz.org/mailman/listinfo/users > > > --Apple-Mail-75--163666238 > Content-Transfer-Encoding: base64 > Content-Type: application/pkcs7-signature; > name=smime.p7s > Content-Disposition: attachment; > filename=smime.p7s > > ... [show rest of quote] MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGfTCCAzYw
> ggKfoAMCAQICAw+r8TANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh > d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt > YWlsIElzc3VpbmcgQ0EwHhcNMDUxMDE1MDMzNjQ3WhcNMDYxMDE1MDMzNjQ3WjCBhTEfMB0GA1UE > AxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEgMB4GCSqGSIb3DQEJARYRam9uZXNkZUB5YWhvby5j > b20xIDAeBgkqhkiG9w0BCQEWEWpvbmVzZGVAb2ZiaXoub3JnMR4wHAYJKoZIhvcNAQkBFg9qb25l > c2RlQG1hYy5jb20wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDgKWBlaFeD3yzB6EZa > BjrAruSCZNsPD1hZ9doam5BNw5W/nqo9f+bK18TNnt4YJXOSpTuV4+h5i5qCHt+F2DZGb4/B0jTM > iBLkT75xs/W9i8VccrRf/PG09jWwU4TMVLGAK0iMd+PcgwMTj5oM4Gj1wpo68mV2BhHI3jeZ/wGU > pdWoELDpO4uasK9lzybkkNMRzUJqjJB0gYQccj36309Sh4Plf9anjD4EhqzDB1dKcZEvxv9NlmAA > y9BpY3mbs5ajWH2bZdDVJ/wSTjQRkUR+7zyhGwUUSBOJbqIVqNQUDJ1pSxrV4I2/Ju32QZ2NeIES > oNJomY7EGRgtPWKKJkixAgMBAAGjUjBQMEAGA1UdEQQ5MDeBEWpvbmVzZGVAeWFob28uY29tgRFq > b25lc2RlQG9mYml6Lm9yZ4EPam9uZXNkZUBtYWMuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcN > AQEEBQADgYEAIN0b5SBpiLxmdwf14jTUZT7HTeKqpS6aJ2+tUZAmcq3zGWUY0yEiPAuzAjbRqzAH > +kE973MMscfkUo5Sze5emzr2stV3p2kAJlKNMSXIMHpa3r43zzquQ/IGFN6CKSDYqVQqb/j05vnh > fykr3kWMqMw+dHjzddMUzZvm032YRFkwggM/MIICqKADAgECAgENMA0GCSqGSIb3DQEBBQUAMIHR > MQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24x > GjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZp > Y2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkq > hkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcN > MTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg > KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0Ew > gZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb > 8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9 > A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYD > VR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20v > VGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwx > GjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2j > ZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4l > UJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9d > X2VPMYIC5zCCAuMCAQEwaTBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRp > bmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3Vpbmcg > Q0ECAw+r8TAJBgUrDgMCGgUAoIIBUzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3 > DQEJBTEPFw0wNjAxMTIwOTE1MjRaMCMGCSqGSIb3DQEJBDEWBBTuSzvoZB2AH9GLBDjSM/0+eLnr > jDB4BgkrBgEEAYI3EAQxazBpMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3Vs > dGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWlu > ZyBDQQIDD6vxMHoGCyqGSIb3DQEJEAILMWugaTBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh > d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt > YWlsIElzc3VpbmcgQ0ECAw+r8TANBgkqhkiG9w0BAQEFAASCAQA7EJie5fuhjeHlL2XoaaFI/YNq > lxXaehDNFePgGqkexEdswWBxpUXPrlt8fu/74JYvqO3QHPKbXJqPc6zDl8pdKI61HwqIfq2OyNeq > ILxWu7vDA1NuNxRwgdoXYf4P7JxlWSDZg0Jtr3t//cxIAEF88B823rY6Etw2Hqt4O9AbI3HKv8aR > FN59+OzfnlAwTjWwa/ZdvaX3D5dx57ypJnSmVShUPQs5KSxusoPNZA9yDECMO/j5pjXKbtSicLiJ > Zzvc9DkOGTmanhR6td7/hr8MGwjZbkq/090apIoE8MhTQ0Y7IXGklhnmOkylc/Q4sLrHcjxNVmJ2 > itaUQKv60PGqAAAAAAAA > > --Apple-Mail-75--163666238-- > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Reply |
Threaded
Open this post in threaded view
|
More ♦
♦
| Loading... |
| Reply to author |
| Edit post |
| Move post |
| Delete this post |
| Delete this post and replies |
| Change post date |
| Print post |
| Permalink |
| Raw mail |
| |
Jan 12, 2006; 9:47am
Re: Users - Problems with entity-view
|
1743 posts
|
Hi Dimitri,
the problem is that the "TO" is a reserved keyword for SAPDB (http://www.sapdb.org/7.4/htmhelp/e2/5a131fde7c11d5994e00508b5d5211/content.htm) You should change the name of the alias entity TO to something else. Jacopo Dimitri Unruh wrote: > Yes, I'm using the SAP DB. I didn't change the settings in the > entityengine.xml. And also there are no problems with other entity-views. > So, maybe I have an error in my definition?! > But in my opinion the SQL-statement is okay.. > > Dimitri > > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Reply |
Threaded
Open this post in threaded view
|
More ♦
♦
| Loading... |
| Reply to author |
| Edit post |
| Move post |
| Delete this post |
| Delete this post and replies |
| Change post date |
| Print post |
| Permalink |
| Raw mail |
| |
Jan 12, 2006; 10:05am
Re: Users - Problems with entity-view
|
14 posts
|
Oh Lord...
thank you!!! Dimitri > --- Ursprüngliche Nachricht --- > Von: Jacopo Cappellato <[hidden email]> > An: OFBiz Users / Usage Discussion <[hidden email]> > Betreff: Re: [OFBiz] Users - Problems with entity-view > Datum: Thu, 12 Jan 2006 10:47:26 +0100 > > Hi Dimitri, > > the problem is that the "TO" is a reserved keyword for SAPDB > > > You should change the name of the alias entity TO to something else. > > Jacopo > > Dimitri Unruh wrote: > > Yes, I'm using the SAP DB. I didn't change the settings in the > > entityengine.xml. And also there are no problems with other > entity-views. > > So, maybe I have an error in my definition?! > > But in my opinion the SQL-statement is okay.. > > > > Dimitri > > > > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > ... [show rest of quote]
_______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
«
Return to OFBiz - User
|
81 views
| Free forum by Nabble | Edit this page |