[Need Help]Need help about the db2 error

[guo weizhan]

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
org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882

[guo weizhan]

The view party page also have this problem , both them are the view-entity
type

org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
[component://party/widget/partymgr/ProfileScreens.xml#Notes]:
java.lang.IllegalArgumentException: Error doing entity query by condition:
org.ofbiz.base.util.GeneralException: Error doing find by and:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO,
ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN
OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER
BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997,
SQLERRMC: 63) (SQL Exception while executing the following:SELECT
PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME,
ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON
PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY
ND.NOTE_DATE_TIMEDESC (DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997,
SQLERRMC: 63)) (Error
doing entity query by condition: org.ofbiz.base.util.GeneralException: Error
doing find by and: org.ofbiz.entity.GenericDataSourceException: SQL
Exception while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID =
ND.NOTE_IDWHERE (
PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE:
-270, SQLSTATE: 42997, SQLERRMC: 63) (SQL Exception while executing the
following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO,
ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN
OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER
BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997,
SQLERRMC: 63)))

2008/1/30, guo weizhan <[hidden email]>:

>
> 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_NUMFROM
> 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
> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882
>
>

[guo weizhan]

I try to test the example, Jason
Lane<http://docs.ofbiz.org/display/%7Ejclane>is right, .
The SQL used to pull the data fails when run against DB2 with an error
related to pulling CLOB, is there any solution about this？

2008/1/30, guo weizhan <[hidden email]>:

>
> The view party page also have this problem , both them are the view-entity
> type
>
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://party/widget/partymgr/ProfileScreens.xml#Notes]:
> java.lang.IllegalArgumentException: Error doing entity query by condition:
> org.ofbiz.base.util.GeneralException: Error doing find by and:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO,
> ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN
> OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?)
> ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270, SQLSTATE:
> 42997, SQLERRMC: 63) (SQL Exception while executing the following:SELECT
> PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME,
> ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON
> PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIMEDESC (DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63)) (Error
> doing entity query by condition: org.ofbiz.base.util.GeneralException:
> Error doing find by and: org.ofbiz.entity.GenericDataSourceException: SQL
> Exception while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
> ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
> OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID =
> ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2
> SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63) (SQL Exception
> while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME,
> ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN
> INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (
> PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE:
> -270, SQLSTATE: 42997, SQLERRMC: 63)))
>
> 2008/1/30, guo weizhan <[hidden email]>:
> >
> > 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
> > org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> > org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> > org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882
> >
> >
>

[BJ Freeman]

the only control in ofbiz is the file in
/framework/entity/fieldtype/
there should be one defined in the

/framework/entity/coinfig/entityengine.xml
for your DB.

quick look I don't see one for db2
Other than that, it would be a driver issue.
and you would need to check out IBM for drivers.


guo weizhan sent the following on 1/29/2008 11:02 PM:

> I try to test the example, Jason
> Lane<http://docs.ofbiz.org/display/%7Ejclane>is right, .
> The SQL used to pull the data fails when run against DB2 with an error
> related to pulling CLOB, is there any solution about this？
>
> 2008/1/30, guo weizhan <[hidden email]>:
>> The view party page also have this problem , both them are the view-entity
>> type
>>
>> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
>> [component://party/widget/partymgr/ProfileScreens.xml#Notes]:
>> java.lang.IllegalArgumentException: Error doing entity query by condition:
>> org.ofbiz.base.util.GeneralException: Error doing find by and:
>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
>> the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO,
>> ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN
>> OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?)
>> ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270, SQLSTATE:
>> 42997, SQLERRMC: 63) (SQL Exception while executing the following:SELECT
>> PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME,
>> ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON
>> PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIMEDESC (DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63)) (Error
>> doing entity query by condition: org.ofbiz.base.util.GeneralException:
>> Error doing find by and: org.ofbiz.entity.GenericDataSourceException: SQL
>> Exception while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
>> ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
>> OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID =
>> ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2
>> SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63) (SQL Exception
>> while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME,
>> ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN
>> INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (
>> PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE:
>> -270, SQLSTATE: 42997, SQLERRMC: 63)))
>>
>> 2008/1/30, guo weizhan <[hidden email]>:
>>> 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
>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882
>>>
>>>

[guo weizhan]

I have add the filedType and configurate the entityengine file, I think I
have found the problems, the db2 cannot support the conn.prepareStatement
(sql,1004,1007);
this execute in prepareStatement method in SQLProcessor.java, I don't know
there will cause another issue if I change this, can any body point this
out?

在08-1-30，BJ Freeman <[hidden email]> 写道：

>
> the only control in ofbiz is the file in
> /framework/entity/fieldtype/
> there should be one defined in the
>
> /framework/entity/coinfig/entityengine.xml
> for your DB.
>
> quick look I don't see one for db2
> Other than that, it would be a driver issue.
> and you would need to check out IBM for drivers.
>
>
> guo weizhan sent the following on 1/29/2008 11:02 PM:
> > I try to test the example, Jason
> > Lane<http://docs.ofbiz.org/display/%7Ejclane>is right, .
> > The SQL used to pull the data fails when run against DB2 with an error
> > related to pulling CLOB, is there any solution about this？
> >
> > 2008/1/30, guo weizhan <[hidden email]>:
> >> The view party page also have this problem , both them are the
> view-entity
> >> type
> >>
> >> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> >> [component://party/widget/partymgr/ProfileScreens.xml#Notes]:
> >> java.lang.IllegalArgumentException: Error doing entity query by
> condition:
> >> org.ofbiz.base.util.GeneralException: Error doing find by and:
> >> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> executing
> >> the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME,
> ND.NOTE_INFO,
> >> ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN
> >> OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?)
> >> ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270,
> SQLSTATE:
> >> 42997, SQLERRMC: 63) (SQL Exception while executing the
> following:SELECT
> >> PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME,
> >> ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON
> >> PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY
> ND.NOTE_DATE_TIMEDESC (DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997,
> SQLERRMC: 63)) (Error
> >> doing entity query by condition: org.ofbiz.base.util.GeneralException:
> >> Error doing find by and: org.ofbiz.entity.GenericDataSourceException:
> SQL
> >> Exception while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
> >> ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
> >> OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID =
> >> ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2
> >> SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63) (SQL Exception
> >> while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
> ND.NOTE_NAME,
> >> ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN
> >> INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (
> >> PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error:
> SQLCODE:
> >> -270, SQLSTATE: 42997, SQLERRMC: 63)))
> >>
> >> 2008/1/30, guo weizhan <[hidden email]>:
> >>> 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
> >>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> >>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> >>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882
> >>>
> >>>
>
>
>

[guo weizhan]

if the select sql include pull the data of clob type , it will thrown
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -270, SQLSTATE:
42997, SQLERRMC: 63
**
2008/1/30, guo weizhan <[hidden email]>:

>
> I have add the filedType and configurate the entityengine file, I think I
> have found the problems, the db2 cannot support the conn.prepareStatement
> (sql,1004,1007);
> this execute in prepareStatement method in SQLProcessor.java, I don't know
> there will cause another issue if I change this, can any body point this
> out?
>
> 在08-1-30，BJ Freeman <[hidden email]> 写道：
> >
> > the only control in ofbiz is the file in
> > /framework/entity/fieldtype/
> > there should be one defined in the
> >
> > /framework/entity/coinfig/entityengine.xml
> > for your DB.
> >
> > quick look I don't see one for db2
> > Other than that, it would be a driver issue.
> > and you would need to check out IBM for drivers.
> >
> >
> > guo weizhan sent the following on 1/29/2008 11:02 PM:
> > > I try to test the example, Jason
> > > Lane<http://docs.ofbiz.org/display/%7Ejclane>is right, .
> > > The SQL used to pull the data fails when run against DB2 with an error
> > > related to pulling CLOB, is there any solution about this？
> > >
> > > 2008/1/30, guo weizhan <[hidden email]>:
> > >> The view party page also have this problem , both them are the
> > view-entity
> > >> type
> > >>
> > >> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> > >> [component://party/widget/partymgr/ProfileScreens.xml#Notes]:
> > >> java.lang.IllegalArgumentException: Error doing entity query by
> > condition:
> > >> org.ofbiz.base.util.GeneralException: Error doing find by and:
> > >> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> > executing
> > >> the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME,
> > ND.NOTE_INFO,
> > >> ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN
> > >> OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?)
> > >> ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270,
> > SQLSTATE:
> > >> 42997, SQLERRMC: 63) (SQL Exception while executing the
> > following:SELECT
> > >> PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO,
> > ND.NOTE_DATE_TIME,
> > >> ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND
> > ON
> > >> PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY
> > ND.NOTE_DATE_TIMEDESC (DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997,
> > SQLERRMC: 63)) (Error
> > >> doing entity query by condition: org.ofbiz.base.util.GeneralException
> > :
> > >> Error doing find by and: org.ofbiz.entity.GenericDataSourceException:
> > SQL
> > >> Exception while executing the following:SELECT PN.PARTY_ID,
> > ND.NOTE_ID,
> > >> ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
> > >> OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID =
> > >> ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC
> > (DB2
> > >> SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63) (SQL
> > Exception
> > >> while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
> > ND.NOTE_NAME,
> > >> ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTEPN
> > >> INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (
> > >> PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error:
> > SQLCODE:
> > >> -270, SQLSTATE: 42997, SQLERRMC: 63)))
> > >>
> > >> 2008/1/30, guo weizhan <[hidden email]>:
> > >>> 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
> > >>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> > >>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> > >>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882
> > >>>
> > >>>
> >
> >
> >
>

[BJ Freeman]

I am not familiar with DB2, so I would check to see if db2 supports clob
type. if not then change the file you created in
/framework/entity/fieldtype/
and put the appropiate value in.


guo weizhan sent the following on 1/30/2008 1:38 AM:

> if the select sql include pull the data of clob type , it will thrown
> com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -270, SQLSTATE:
> 42997, SQLERRMC: 63
> **
> 2008/1/30, guo weizhan <[hidden email]>:
>> I have add the filedType and configurate the entityengine file, I think I
>> have found the problems, the db2 cannot support the conn.prepareStatement
>> (sql,1004,1007);
>> this execute in prepareStatement method in SQLProcessor.java, I don't know
>> there will cause another issue if I change this, can any body point this
>> out?
>>
>> 在08-1-30，BJ Freeman <[hidden email]> 写道：
>>> the only control in ofbiz is the file in
>>> /framework/entity/fieldtype/
>>> there should be one defined in the
>>>
>>> /framework/entity/coinfig/entityengine.xml
>>> for your DB.
>>>
>>> quick look I don't see one for db2
>>> Other than that, it would be a driver issue.
>>> and you would need to check out IBM for drivers.
>>>
>>>
>>> guo weizhan sent the following on 1/29/2008 11:02 PM:
>>>> I try to test the example, Jason
>>>> Lane<http://docs.ofbiz.org/display/%7Ejclane>is right, .
>>>> The SQL used to pull the data fails when run against DB2 with an error
>>>> related to pulling CLOB, is there any solution about this？
>>>>
>>>> 2008/1/30, guo weizhan <[hidden email]>:
>>>>> The view party page also have this problem , both them are the
>>> view-entity
>>>>> type
>>>>>
>>>>> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
>>>>> [component://party/widget/partymgr/ProfileScreens.xml#Notes]:
>>>>> java.lang.IllegalArgumentException: Error doing entity query by
>>> condition:
>>>>> org.ofbiz.base.util.GeneralException: Error doing find by and:
>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>> executing
>>>>> the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME,
>>> ND.NOTE_INFO,
>>>>> ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN
>>>>> OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?)
>>>>> ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270,
>>> SQLSTATE:
>>>>> 42997, SQLERRMC: 63) (SQL Exception while executing the
>>> following:SELECT
>>>>> PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO,
>>> ND.NOTE_DATE_TIME,
>>>>> ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND
>>> ON
>>>>> PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY
>>> ND.NOTE_DATE_TIMEDESC (DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997,
>>> SQLERRMC: 63)) (Error
>>>>> doing entity query by condition: org.ofbiz.base.util.GeneralException
>>> :
>>>>> Error doing find by and: org.ofbiz.entity.GenericDataSourceException:
>>> SQL
>>>>> Exception while executing the following:SELECT PN.PARTY_ID,
>>> ND.NOTE_ID,
>>>>> ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
>>>>> OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID =
>>>>> ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC
>>> (DB2
>>>>> SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63) (SQL
>>> Exception
>>>>> while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
>>> ND.NOTE_NAME,
>>>>> ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTEPN
>>>>> INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (
>>>>> PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error:
>>> SQLCODE:
>>>>> -270, SQLSTATE: 42997, SQLERRMC: 63)))
>>>>>
>>>>> 2008/1/30, guo weizhan <[hidden email]>:
>>>>>> 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
>>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
>>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
>>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882
>>>>>>
>>>>>>
>>>
>>>

[guo weizhan]

of course It supports, but cann't support pull the clob data with the ps
create in this way: conn.prepareStatement(sql,1004,1007);

2008/1/30, BJ Freeman <[hidden email]>:

>
> I am not familiar with DB2, so I would check to see if db2 supports clob
> type. if not then change the file you created in
> /framework/entity/fieldtype/
> and put the appropiate value in.
>
>
> guo weizhan sent the following on 1/30/2008 1:38 AM:
> > if the select sql include pull the data of clob type , it will thrown
> > com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -270, SQLSTATE:
> > 42997, SQLERRMC: 63
> > **
> > 2008/1/30, guo weizhan <[hidden email]>:
> >> I have add the filedType and configurate the entityengine file, I think
> I
> >> have found the problems, the db2 cannot support the
> conn.prepareStatement
> >> (sql,1004,1007);
> >> this execute in prepareStatement method in SQLProcessor.java, I don't
> know
> >> there will cause another issue if I change this, can any body point
> this
> >> out?
> >>
> >> 在08-1-30，BJ Freeman <[hidden email]> 写道：
> >>> the only control in ofbiz is the file in
> >>> /framework/entity/fieldtype/
> >>> there should be one defined in the
> >>>
> >>> /framework/entity/coinfig/entityengine.xml
> >>> for your DB.
> >>>
> >>> quick look I don't see one for db2
> >>> Other than that, it would be a driver issue.
> >>> and you would need to check out IBM for drivers.
> >>>
> >>>
> >>> guo weizhan sent the following on 1/29/2008 11:02 PM:
> >>>> I try to test the example, Jason
> >>>> Lane<http://docs.ofbiz.org/display/%7Ejclane>is right, .
> >>>> The SQL used to pull the data fails when run against DB2 with an
> error
> >>>> related to pulling CLOB, is there any solution about this？
> >>>>
> >>>> 2008/1/30, guo weizhan <[hidden email]>:
> >>>>> The view party page also have this problem , both them are the
> >>> view-entity
> >>>>> type
> >>>>>
> >>>>> org.ofbiz.widget.screen.ScreenRenderException: Error rendering
> screen
> >>>>> [component://party/widget/partymgr/ProfileScreens.xml#Notes]:
> >>>>> java.lang.IllegalArgumentException: Error doing entity query by
> >>> condition:
> >>>>> org.ofbiz.base.util.GeneralException: Error doing find by and:
> >>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> >>> executing
> >>>>> the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME,
> >>> ND.NOTE_INFO,
> >>>>> ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN
> >>>>> OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID =
> ?)
> >>>>> ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270,
> >>> SQLSTATE:
> >>>>> 42997, SQLERRMC: 63) (SQL Exception while executing the
> >>> following:SELECT
> >>>>> PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO,
> >>> ND.NOTE_DATE_TIME,
> >>>>> ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND
> >>> ON
> >>>>> PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY
> >>> ND.NOTE_DATE_TIMEDESC (DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997,
> >>> SQLERRMC: 63)) (Error
> >>>>> doing entity query by condition:
> org.ofbiz.base.util.GeneralException
> >>> :
> >>>>> Error doing find by and: org.ofbiz.entity.GenericDataSourceException
> :
> >>> SQL
> >>>>> Exception while executing the following:SELECT PN.PARTY_ID,
> >>> ND.NOTE_ID,
> >>>>> ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
> >>>>> OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID =
> >>>>> ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC
> >>> (DB2
> >>>>> SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63) (SQL
> >>> Exception
> >>>>> while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
> >>> ND.NOTE_NAME,
> >>>>> ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
> OFBIZ.PARTY_NOTEPN
> >>>>> INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (
> >>>>> PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error:
> >>> SQLCODE:
> >>>>> -270, SQLSTATE: 42997, SQLERRMC: 63)))
> >>>>>
> >>>>> 2008/1/30, guo weizhan <[hidden email]>:
> >>>>>> 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
> >>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> >>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> >>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882
> >>>>>>
> >>>>>>
> >>>
> >>>
>
>
>

[guo weizhan]

*Restriction:* If the ResultSet is scrollable, and the ResultSet is used to
select columns from a table on a DB2 Database for Linux, UNIX, and
Windowsserver, the SELECT list of the SELECT statement that defines
the
ResultSet cannot include columns with the following data types:

   - BLOB
   - CLOB
   - XML
   - A distinct type that is based on any of the previous data types in
   this list

here is the restriction note from
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.java.doc/doc/tjvrsush.htm

DB2 sucks

2008/1/30, guo weizhan <[hidden email]>:

>
> of course It supports, but cann't support pull the clob data with the ps
> create in this way: conn.prepareStatement(sql,1004,1007);
>
> 2008/1/30, BJ Freeman <[hidden email]>:
> >
> > I am not familiar with DB2, so I would check to see if db2 supports clob
> > type. if not then change the file you created in
> > /framework/entity/fieldtype/
> > and put the appropiate value in.
> >
> >
> > guo weizhan sent the following on 1/30/2008 1:38 AM:
> > > if the select sql include pull the data of clob type , it will thrown
> > > com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -270,
> > SQLSTATE:
> > > 42997, SQLERRMC: 63
> > > **
> > > 2008/1/30, guo weizhan <[hidden email]>:
> > >> I have add the filedType and configurate the entityengine file, I
> > think I
> > >> have found the problems, the db2 cannot support the
> > conn.prepareStatement
> > >> (sql,1004,1007);
> > >> this execute in prepareStatement method in SQLProcessor.java, I don't
> > know
> > >> there will cause another issue if I change this, can any body point
> > this
> > >> out?
> > >>
> > >> 在08-1-30，BJ Freeman <[hidden email]> 写道：
> > >>> the only control in ofbiz is the file in
> > >>> /framework/entity/fieldtype/
> > >>> there should be one defined in the
> > >>>
> > >>> /framework/entity/coinfig/entityengine.xml
> > >>> for your DB.
> > >>>
> > >>> quick look I don't see one for db2
> > >>> Other than that, it would be a driver issue.
> > >>> and you would need to check out IBM for drivers.
> > >>>
> > >>>
> > >>> guo weizhan sent the following on 1/29/2008 11:02 PM:
> > >>>> I try to test the example, Jason
> > >>>> Lane<http://docs.ofbiz.org/display/%7Ejclane>is right, .
> > >>>> The SQL used to pull the data fails when run against DB2 with an
> > error
> > >>>> related to pulling CLOB, is there any solution about this？
> > >>>>
> > >>>> 2008/1/30, guo weizhan <[hidden email]>:
> > >>>>> The view party page also have this problem , both them are the
> > >>> view-entity
> > >>>>> type
> > >>>>>
> > >>>>> org.ofbiz.widget.screen.ScreenRenderException: Error rendering
> > screen
> > >>>>> [component://party/widget/partymgr/ProfileScreens.xml#Notes]:
> > >>>>> java.lang.IllegalArgumentException: Error doing entity query by
> > >>> condition:
> > >>>>> org.ofbiz.base.util.GeneralException: Error doing find by and:
> > >>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> > >>> executing
> > >>>>> the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME,
> > >>> ND.NOTE_INFO,
> > >>>>> ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER
> > JOIN
> > >>>>> OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID =
> > ?)
> > >>>>> ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270,
> > >>> SQLSTATE:
> > >>>>> 42997, SQLERRMC: 63) (SQL Exception while executing the
> > >>> following:SELECT
> > >>>>> PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO,
> > >>> ND.NOTE_DATE_TIME,
> > >>>>> ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATAND
> > >>> ON
> > >>>>> PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY
> > >>> ND.NOTE_DATE_TIMEDESC (DB2 SQL error: SQLCODE: -270, SQLSTATE:
> > 42997,
> > >>> SQLERRMC: 63)) (Error
> > >>>>> doing entity query by condition:
> > org.ofbiz.base.util.GeneralException
> > >>> :
> > >>>>> Error doing find by and:
> > org.ofbiz.entity.GenericDataSourceException:
> > >>> SQL
> > >>>>> Exception while executing the following:SELECT PN.PARTY_ID,
> > >>> ND.NOTE_ID,
> > >>>>> ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
> > >>>>> OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID =
> > >>>>> ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC
> > >>> (DB2
> > >>>>> SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63) (SQL
> > >>> Exception
> > >>>>> while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
> > >>> ND.NOTE_NAME,
> > >>>>> ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
> > OFBIZ.PARTY_NOTEPN
> > >>>>> INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE (
> > >>>>> PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error:
> > >>> SQLCODE:
> > >>>>> -270, SQLSTATE: 42997, SQLERRMC: 63)))
> > >>>>>
> > >>>>> 2008/1/30, guo weizhan <[hidden email]>:
> > >>>>>> 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_RESPONSESR
> > >>>>>> 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$SurveyWrapperExceptionthrew
> > >>> an
> > >>>>>> exception when invoked on
> > >>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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$SurveyWrapperExceptionthrew
> > >>> an
> > >>>>>> exception when invoked on
> > >>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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_RESPONSESR
> > >>>>>> 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$SurveyWrapperExceptionthrew
> > >>> an
> > >>>>>> exception when invoked on
> > >>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882
> > >>>>>>
> > >>>>>>
> > >>>
> > >>>
> >
> >
> >
>

[David E Jones]

I've seen this sort of thing with other databases, like Oracle a few  
years ago (their JDBC drivers are better now), and SQLServer more  
recently, though they may have fixed some of their JDBC issues in the  
last couple of years since.

The best solution at that time was to use a better JDBC driver. There  
are definitely commercial ones (like from DataDirect), and there may  
be open source ones too.

-David


On Jan 30, 2008, at 8:45 AM, guo weizhan wrote:

> *Restriction:* If the ResultSet is scrollable, and the ResultSet is  
> used to
> select columns from a table on a DB2 Database for Linux, UNIX, and
> Windowsserver, the SELECT list of the SELECT statement that defines
> the
> ResultSet cannot include columns with the following data types:
>
>   - BLOB
>   - CLOB
>   - XML
>   - A distinct type that is based on any of the previous data types in
>   this list
>
> here is the restriction note from
> http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.java.doc/doc/tjvrsush.htm
>
> DB2 sucks
>
> 2008/1/30, guo weizhan <[hidden email]>:
>>
>> of course It supports, but cann't support pull the clob data with  
>> the ps
>> create in this way: conn.prepareStatement(sql,1004,1007);
>>
>> 2008/1/30, BJ Freeman <[hidden email]>:
>>>
>>> I am not familiar with DB2, so I would check to see if db2  
>>> supports clob
>>> type. if not then change the file you created in
>>> /framework/entity/fieldtype/
>>> and put the appropiate value in.
>>>
>>>
>>> guo weizhan sent the following on 1/30/2008 1:38 AM:
>>>> if the select sql include pull the data of clob type , it will  
>>>> thrown
>>>> com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -270,
>>> SQLSTATE:
>>>> 42997, SQLERRMC: 63
>>>> **
>>>> 2008/1/30, guo weizhan <[hidden email]>:
>>>>> I have add the filedType and configurate the entityengine file, I
>>> think I
>>>>> have found the problems, the db2 cannot support the
>>> conn.prepareStatement
>>>>> (sql,1004,1007);
>>>>> this execute in prepareStatement method in SQLProcessor.java, I  
>>>>> don't
>>> know
>>>>> there will cause another issue if I change this, can any body  
>>>>> point
>>> this
>>>>> out?
>>>>>
>>>>> 在08-1-30，BJ Freeman <[hidden email]> 写道：
>>>>>> the only control in ofbiz is the file in
>>>>>> /framework/entity/fieldtype/
>>>>>> there should be one defined in the
>>>>>>
>>>>>> /framework/entity/coinfig/entityengine.xml
>>>>>> for your DB.
>>>>>>
>>>>>> quick look I don't see one for db2
>>>>>> Other than that, it would be a driver issue.
>>>>>> and you would need to check out IBM for drivers.
>>>>>>
>>>>>>
>>>>>> guo weizhan sent the following on 1/29/2008 11:02 PM:
>>>>>>> I try to test the example, Jason
>>>>>>> Lane<http://docs.ofbiz.org/display/%7Ejclane>is right, .
>>>>>>> The SQL used to pull the data fails when run against DB2 with an
>>> error
>>>>>>> related to pulling CLOB, is there any solution about this？
>>>>>>>
>>>>>>> 2008/1/30, guo weizhan <[hidden email]>:
>>>>>>>> The view party page also have this problem , both them are the
>>>>>> view-entity
>>>>>>>> type
>>>>>>>>
>>>>>>>> org.ofbiz.widget.screen.ScreenRenderException: Error rendering
>>> screen
>>>>>>>> [component://party/widget/partymgr/ProfileScreens.xml#Notes]:
>>>>>>>> java.lang.IllegalArgumentException: Error doing entity query by
>>>>>> condition:
>>>>>>>> org.ofbiz.base.util.GeneralException: Error doing find by and:
>>>>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception  
>>>>>>>> while
>>>>>> executing
>>>>>>>> the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME,
>>>>>> ND.NOTE_INFO,
>>>>>>>> ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER
>>> JOIN
>>>>>>>> OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE  
>>>>>>>> (PN.PARTY_ID =
>>> ?)
>>>>>>>> ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270,
>>>>>> SQLSTATE:
>>>>>>>> 42997, SQLERRMC: 63) (SQL Exception while executing the
>>>>>> following:SELECT
>>>>>>>> PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO,
>>>>>> ND.NOTE_DATE_TIME,
>>>>>>>> ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN  
>>>>>>>> OFBIZ.NOTE_DATAND
>>>>>> ON
>>>>>>>> PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY
>>>>>> ND.NOTE_DATE_TIMEDESC (DB2 SQL error: SQLCODE: -270, SQLSTATE:
>>> 42997,
>>>>>> SQLERRMC: 63)) (Error
>>>>>>>> doing entity query by condition:
>>> org.ofbiz.base.util.GeneralException
>>>>>> :
>>>>>>>> Error doing find by and:
>>> org.ofbiz.entity.GenericDataSourceException:
>>>>>> SQL
>>>>>>>> Exception while executing the following:SELECT PN.PARTY_ID,
>>>>>> ND.NOTE_ID,
>>>>>>>> ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY  
>>>>>>>> FROM
>>>>>>>> OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON  
>>>>>>>> PN.NOTE_ID =
>>>>>>>> ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME  
>>>>>>>> DESC
>>>>>> (DB2
>>>>>>>> SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63) (SQL
>>>>>> Exception
>>>>>>>> while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
>>>>>> ND.NOTE_NAME,
>>>>>>>> ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
>>> OFBIZ.PARTY_NOTEPN
>>>>>>>> INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID  
>>>>>>>> WHERE (
>>>>>>>> PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL  
>>>>>>>> error:
>>>>>> SQLCODE:
>>>>>>>> -270, SQLSTATE: 42997, SQLERRMC: 63)))
>>>>>>>>
>>>>>>>> 2008/1/30, guo weizhan <[hidden email]>:
>>>>>>>>> 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_RESPONSESR
>>>>>>>>> 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
>>>>>>>>> $SurveyWrapperExceptionthrew
>>>>>> an
>>>>>>>>> exception when invoked on
>>>>>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
>>>>>>>>> $SurveyWrapperExceptionthrew
>>>>>> an
>>>>>>>>> exception when invoked on
>>>>>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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_RESPONSESR
>>>>>>>>> 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
>>>>>>>>> $SurveyWrapperExceptionthrew
>>>>>> an
>>>>>>>>> exception when invoked on
>>>>>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882
>>>>>>>>>
>>>>>>>>>
>>>>>>
>>>>>>
>>>
>>>
>>>
>>

[guo weizhan]

Do you know any db2 jdbc in open source can fix this problem?

Or in another way, can I change the prepareStatement method in SQLProcessor
class?

2008/1/31, David E Jones <[hidden email]>:

>
>
> I've seen this sort of thing with other databases, like Oracle a few
> years ago (their JDBC drivers are better now), and SQLServer more
> recently, though they may have fixed some of their JDBC issues in the
> last couple of years since.
>
> The best solution at that time was to use a better JDBC driver. There
> are definitely commercial ones (like from DataDirect), and there may
> be open source ones too.
>
> -David
>
>
> On Jan 30, 2008, at 8:45 AM, guo weizhan wrote:
>
> > *Restriction:* If the ResultSet is scrollable, and the ResultSet is
> > used to
> > select columns from a table on a DB2 Database for Linux, UNIX, and
> > Windowsserver, the SELECT list of the SELECT statement that defines
> > the
> > ResultSet cannot include columns with the following data types:
> >
> >   - BLOB
> >   - CLOB
> >   - XML
> >   - A distinct type that is based on any of the previous data types in
> >   this list
> >
> > here is the restriction note from
> >
> http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.java.doc/doc/tjvrsush.htm
> >
> > DB2 sucks
> >
> > 2008/1/30, guo weizhan <[hidden email]>:
> >>
> >> of course It supports, but cann't support pull the clob data with
> >> the ps
> >> create in this way: conn.prepareStatement(sql,1004,1007);
> >>
> >> 2008/1/30, BJ Freeman <[hidden email]>:
> >>>
> >>> I am not familiar with DB2, so I would check to see if db2
> >>> supports clob
> >>> type. if not then change the file you created in
> >>> /framework/entity/fieldtype/
> >>> and put the appropiate value in.
> >>>
> >>>
> >>> guo weizhan sent the following on 1/30/2008 1:38 AM:
> >>>> if the select sql include pull the data of clob type , it will
> >>>> thrown
> >>>> com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -270,
> >>> SQLSTATE:
> >>>> 42997, SQLERRMC: 63
> >>>> **
> >>>> 2008/1/30, guo weizhan <[hidden email]>:
> >>>>> I have add the filedType and configurate the entityengine file, I
> >>> think I
> >>>>> have found the problems, the db2 cannot support the
> >>> conn.prepareStatement
> >>>>> (sql,1004,1007);
> >>>>> this execute in prepareStatement method in SQLProcessor.java, I
> >>>>> don't
> >>> know
> >>>>> there will cause another issue if I change this, can any body
> >>>>> point
> >>> this
> >>>>> out?
> >>>>>
> >>>>> 在08-1-30，BJ Freeman <[hidden email]> 写道：
> >>>>>> the only control in ofbiz is the file in
> >>>>>> /framework/entity/fieldtype/
> >>>>>> there should be one defined in the
> >>>>>>
> >>>>>> /framework/entity/coinfig/entityengine.xml
> >>>>>> for your DB.
> >>>>>>
> >>>>>> quick look I don't see one for db2
> >>>>>> Other than that, it would be a driver issue.
> >>>>>> and you would need to check out IBM for drivers.
> >>>>>>
> >>>>>>
> >>>>>> guo weizhan sent the following on 1/29/2008 11:02 PM:
> >>>>>>> I try to test the example, Jason
> >>>>>>> Lane<http://docs.ofbiz.org/display/%7Ejclane>is right, .
> >>>>>>> The SQL used to pull the data fails when run against DB2 with an
> >>> error
> >>>>>>> related to pulling CLOB, is there any solution about this？
> >>>>>>>
> >>>>>>> 2008/1/30, guo weizhan <[hidden email]>:
> >>>>>>>> The view party page also have this problem , both them are the
> >>>>>> view-entity
> >>>>>>>> type
> >>>>>>>>
> >>>>>>>> org.ofbiz.widget.screen.ScreenRenderException: Error rendering
> >>> screen
> >>>>>>>> [component://party/widget/partymgr/ProfileScreens.xml#Notes]:
> >>>>>>>> java.lang.IllegalArgumentException: Error doing entity query by
> >>>>>> condition:
> >>>>>>>> org.ofbiz.base.util.GeneralException: Error doing find by and:
> >>>>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception
> >>>>>>>> while
> >>>>>> executing
> >>>>>>>> the following:SELECT PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME,
> >>>>>> ND.NOTE_INFO,
> >>>>>>>> ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER
> >>> JOIN
> >>>>>>>> OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID WHERE
> >>>>>>>> (PN.PARTY_ID =
> >>> ?)
> >>>>>>>> ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL error: SQLCODE: -270,
> >>>>>> SQLSTATE:
> >>>>>>>> 42997, SQLERRMC: 63) (SQL Exception while executing the
> >>>>>> following:SELECT
> >>>>>>>> PN.PARTY_ID, ND.NOTE_ID, ND.NOTE_NAME, ND.NOTE_INFO,
> >>>>>> ND.NOTE_DATE_TIME,
> >>>>>>>> ND.NOTE_PARTY FROM OFBIZ.PARTY_NOTE PN INNER JOIN
> >>>>>>>> OFBIZ.NOTE_DATAND
> >>>>>> ON
> >>>>>>>> PN.NOTE_ID = ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY
> >>>>>> ND.NOTE_DATE_TIMEDESC (DB2 SQL error: SQLCODE: -270, SQLSTATE:
> >>> 42997,
> >>>>>> SQLERRMC: 63)) (Error
> >>>>>>>> doing entity query by condition:
> >>> org.ofbiz.base.util.GeneralException
> >>>>>> :
> >>>>>>>> Error doing find by and:
> >>> org.ofbiz.entity.GenericDataSourceException:
> >>>>>> SQL
> >>>>>>>> Exception while executing the following:SELECT PN.PARTY_ID,
> >>>>>> ND.NOTE_ID,
> >>>>>>>> ND.NOTE_NAME, ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY
> >>>>>>>> FROM
> >>>>>>>> OFBIZ.PARTY_NOTE PN INNER JOIN OFBIZ.NOTE_DATA ND ON
> >>>>>>>> PN.NOTE_ID =
> >>>>>>>> ND.NOTE_ID WHERE (PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME
> >>>>>>>> DESC
> >>>>>> (DB2
> >>>>>>>> SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63) (SQL
> >>>>>> Exception
> >>>>>>>> while executing the following:SELECT PN.PARTY_ID, ND.NOTE_ID,
> >>>>>> ND.NOTE_NAME,
> >>>>>>>> ND.NOTE_INFO, ND.NOTE_DATE_TIME, ND.NOTE_PARTY FROM
> >>> OFBIZ.PARTY_NOTEPN
> >>>>>>>> INNER JOIN OFBIZ.NOTE_DATA ND ON PN.NOTE_ID = ND.NOTE_ID
> >>>>>>>> WHERE (
> >>>>>>>> PN.PARTY_ID = ?) ORDER BY ND.NOTE_DATE_TIME DESC (DB2 SQL
> >>>>>>>> error:
> >>>>>> SQLCODE:
> >>>>>>>> -270, SQLSTATE: 42997, SQLERRMC: 63)))
> >>>>>>>>
> >>>>>>>> 2008/1/30, guo weizhan <[hidden email]>:
> >>>>>>>>> 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_RESPONSESR
> >>>>>>>>> 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
> >>>>>>>>> $SurveyWrapperExceptionthrew
> >>>>>> an
> >>>>>>>>> exception when invoked on
> >>>>>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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
> >>>>>>>>> $SurveyWrapperExceptionthrew
> >>>>>> an
> >>>>>>>>> exception when invoked on
> >>>>>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882 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_RESPONSESR
> >>>>>>>>> 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
> >>>>>>>>> $SurveyWrapperExceptionthrew
> >>>>>> an
> >>>>>>>>> exception when invoked on
> >>>>>>>>> org.ofbiz.product.store.ProductStoreSurveyWrapper@1583882
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>
> >>>>>>
> >>>
> >>>
> >>>
> >>
>
>