Users - Problems with entity-view

[Dimitri Unruh]

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

[David E. Jones]

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

[Dimitri Unruh]

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
>
>

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

[Jacopo Cappellato]

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

[Dimitri Unruh]

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
>

(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
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users