Re: Users - Problems with entity-view
Posted by David E. Jones on Jan 12, 2006; 9:15am
URL: http://ofbiz.116.s1.nabble.com/Users-Problems-with-entity-view-tp136898p136899.html
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
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
URL: http://ofbiz.116.s1.nabble.com/Users-Problems-with-entity-view-tp136898p136899.html
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
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
smime.p7s (3K) | Free forum by Nabble | Edit this page |