Hi All,
I test the ofbiz with db2, and I get the error info when invoke this method:
private EntityListIterator getEli(GenericValue question) throws
GenericEntityException {
EntityFindOptions efo = new EntityFindOptions();
efo.setResultSetType(EntityFindOptions.TYPE_SCROLL_INSENSITIVE);
efo.setResultSetConcurrency(EntityFindOptions.CONCUR_READ_ONLY);
efo.setSpecifyTypeAndConcur(true);
efo.setDistinct(false);
EntityListIterator eli = null;
eli = delegator.findListIteratorByCondition("SurveyResponseAndAnswer",
makeEliCondition(question), null, null, null, efo);
return eli;
}
it seems the sql error, but I execute this sql "SELECT SR.SURVEY_RESPONSE_ID,
SR.SURVEY_ID, SR.PARTY_ID, SR.RESPONSE_DATE, SR.LAST_MODIFIED_DATE,
SR.REFERENCE_ID, SR.GENERAL_FEEDBACK, SR.ORDER_ID, SR.ORDER_ITEM_SEQ_ID,
SR.STATUS_ID, SRA.SURVEY_QUESTION_ID, SRA.SURVEY_MULTI_RESP_COL_ID,
SRA.SURVEY_MULTI_RESP_ID, SRA.BOOLEAN_RESPONSE, SRA.CURRENCY_RESPONSE,
SRA.FLOAT_RESPONSE, SRA.NUMERIC_RESPONSE, SRA.TEXT_RESPONSE,
SRA.SURVEY_OPTION_SEQ_ID, SRA.CONTENT_ID, SRA.ANSWERED_DATE, SRA.AMOUNT_BASE,
SRA.AMOUNT_BASE_UOM_ID, SRA.WEIGHT_FACTOR, SRA.DURATION, SRA.DURATION_UOM_ID,
SRA.SEQUENCE_NUM FROM OFBIZ.SURVEY_RESPONSE SR INNER JOIN
OFBIZ.SURVEY_RESPONSE_ANSWER SRA ON SR.SURVEY_RESPONSE_ID =
SRA.SURVEY_RESPONSE_ID WHERE (SRA.SURVEY_QUESTION_ID = ? AND SR.SURVEY_ID =
?) " in DB2, it's ok.
Can anybody give me some tips, thanks.
the error info:
Method public java.io.Writer
org.ofbiz.product.store.ProductStoreSurveyWrapper.render() throws
org.ofbiz.content.survey.SurveyWrapper$SurveyWrapperException threw an
exception when invoked on
[EMAIL PROTECTED] The problematic
instruction: ---------- ==> ${randomSurvey.render().toString()} [on line 32,
column 11 in component://ecommerce/webapp/ecommerce/content/minipoll.ftl]
---------- Java backtrace for programmers: ----------
freemarker.template.TemplateModelException: Method public java.io.Writer
org.ofbiz.product.store.ProductStoreSurveyWrapper.render() throws
org.ofbiz.content.survey.SurveyWrapper$SurveyWrapperException threw an
exception when invoked on
[EMAIL PROTECTED] at
freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:134)
at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93) at
freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at
freemarker.core.Dot._getAsTemplateModel(Dot.java:74) at
freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at
freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:86) at
freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at
freemarker.core.Expression.getStringValue(Expression.java:93) at
freemarker.core.DollarVariable.accept(DollarVariable.java:76) at
freemarker.core.Environment.visit(Environment.java:196) at
freemarker.core.MixedContent.accept(MixedContent.java:92) at
freemarker.core.Environment.visit(Environment.java:196) at
freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:79) at
freemarker.core.Environment.visit(Environment.java:196) at
freemarker.core.MixedContent.accept(MixedContent.java:92) at
freemarker.core.Environment.visit(Environment.java:196) at
freemarker.core.Environment.process(Environment.java:176) at
org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(
FreeMarkerWorker.java:198) at
org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(
FreeMarkerWorker.java:163) at
org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplateAtLocation(
FreeMarkerWorker.java:136) at
org.ofbiz.widget.screen.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:96) at
org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString(
HtmlWidget.java:139) at
org.ofbiz.widget.screen.HtmlWidget.renderWidgetString(HtmlWidget.java:68) at
org.ofbiz.widget.screen.ModelScreenWidget$PlatformSpecific.renderWidgetString
(ModelScreenWidget.java:782) at
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(
ModelScreenWidget.java:134) at
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(
ModelScreenWidget.java:220) at
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:142)
at
org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(
ModelScreenWidget.java:374) at
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(
ModelScreenWidget.java:134) at
org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(
ModelScreenWidget.java:279) at
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(
ModelScreenWidget.java:134) at
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(
ModelScreenWidget.java:220) at
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:142)
at
org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(
ModelScreenWidget.java:374) at
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(
ModelScreenWidget.java:134) at
org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(
ModelScreenWidget.java:279) at
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(
ModelScreenWidget.java:134) at
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(
ModelScreenWidget.java:220) at
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:142)
at
org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString
(ModelScreenWidget.java:469) at
org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(
ModelScreenWidget.java:134) at
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(
ModelScreenWidget.java:220) at
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:142)
at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:131) at
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:94) at
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(
ScreenWidgetViewHandler.java:96) at
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:651)
at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:435)
at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:193) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:269) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:188) at
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:215) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:188) at
org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:210) at
org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:174) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:108) at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:542) at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:665) at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:528) at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
LeaderFollowerWorkerThread.java:81) at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:685) at java.lang.Thread.run(Unknown Source) Caused by:
org.ofbiz.content.survey.SurveyWrapper$SurveyWrapperException: SQL Exception
while executing the following:SELECT SR.SURVEY_RESPONSE_ID, SR.SURVEY_ID,
SR.PARTY_ID, SR.RESPONSE_DATE, SR.LAST_MODIFIED_DATE, SR.REFERENCE_ID,
SR.GENERAL_FEEDBACK, SR.ORDER_ID, SR.ORDER_ITEM_SEQ_ID, SR.STATUS_ID,
SRA.SURVEY_QUESTION_ID, SRA.SURVEY_MULTI_RESP_COL_ID,
SRA.SURVEY_MULTI_RESP_ID, SRA.BOOLEAN_RESPONSE, SRA.CURRENCY_RESPONSE,
SRA.FLOAT_RESPONSE, SRA.NUMERIC_RESPONSE, SRA.TEXT_RESPONSE,
SRA.SURVEY_OPTION_SEQ_ID, SRA.CONTENT_ID, SRA.ANSWERED_DATE, SRA.AMOUNT_BASE,
SRA.AMOUNT_BASE_UOM_ID, SRA.WEIGHT_FACTOR, SRA.DURATION, SRA.DURATION_UOM_ID,
SRA.SEQUENCE_NUM FROM OFBIZ.SURVEY_RESPONSE SR INNER JOIN
OFBIZ.SURVEY_RESPONSE_ANSWER SRA ON SR.SURVEY_RESPONSE_ID =
SRA.SURVEY_RESPONSE_ID WHERE (SRA.SURVEY_QUESTION_ID = ? AND SR.SURVEY_ID =
?) (DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63) at
org.ofbiz.content.survey.SurveyWrapper.getOptionResult(SurveyWrapper.java:708)
at org.ofbiz.content.survey.SurveyWrapper.getResultInfo(SurveyWrapper.java:481)
at org.ofbiz.content.survey.SurveyWrapper.getResults(SurveyWrapper.java:450)
at org.ofbiz.content.survey.SurveyWrapper.render(SurveyWrapper.java:171) at
org.ofbiz.content.survey.SurveyWrapper.render(SurveyWrapper.java:158) at
org.ofbiz.product.store.ProductStoreSurveyWrapper.renderSurvey(
ProductStoreSurveyWrapper.java:78) at
org.ofbiz.product.store.ProductStoreSurveyWrapper.render(
ProductStoreSurveyWrapper.java:69) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
java.lang.reflect.Method.invoke(Unknown Source) at
freemarker.ext.beans.BeansWrapper.invokeMethod(BeansWrapper.java:825) at
freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:111)
... 68 more Error rendering included template at location
[component://ecommerce/webapp/ecommerce/content/minipoll.ftl]:
freemarker.template.TemplateModelException: Method public java.io.Writer
org.ofbiz.product.store.ProductStoreSurveyWrapper.render() throws
org.ofbiz.content.survey.SurveyWrapper$SurveyWrapperException threw an
exception when invoked on
[EMAIL PROTECTED]
