Posted by
Dimitri Unruh on
Jan 12, 2006; 8:53am
URL: http://ofbiz.116.s1.nabble.com/Users-Problems-with-entity-view-tp136898.html
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>
>
>
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users