http://ofbiz.116.s1.nabble.com/Users-Problems-with-entity-view-tp136898p136900.html
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.
> --- 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
>
>