Skip to Content
0
Former Member
Mar 24, 2009 at 10:38 AM

Multivalue parameter: problem

41 Views

Hi All,

I am a newbie in this forum.

I'm developing a web application written in J2EE that uses Java Reporting Component (JRC) to display crystal reports from some filters recovered from a jsp and passed to a report .rpt previously designed and invoked just at runtime.

I have a problem with multivalue parameters. Let me explain.

I need to switch a parameter that can take multiple values from a jsp.

Within the report I used a Command in which I entered the query that pulls out the data to be displayed in the report.

In the query, with the "Command Parameter" I have defined a parameter in which I selected the check "Allows multiple values",

The query is the following:

"SELECT * FROM Table WHERE COGNOME = ANY {?par_Products}"

To retrieve the report from Java, I used the Java Reporting Component (JRC). The class of the JRC is used for export is ReportExportControl.

For the transition of the multi-parameter, I wrote the following code:

....

String cognome1 = "ROSSI";

String cognome2 = "BIANCHI";

Object[] multiVals = {cognome1, cognome2};

paramFieldController.setCurrentValues("", par_Products, multiVals);

....

Setting the two parameters above, I get this message testing the code:

17:19:28,683 ERROR [reportdefinition] com.crystaldecisions.reports.queryengine.driverImpl.m: Errore JDBC: ORA-00904: "ROSSI": identificativo non valido

17:19:28,683 ERROR [datasource] Failed to open rowset: the query failed to open rowset

com.crystaldecisions.reports.reportdefinition.datainterface.n: Errore JDBC: ORA-00904: "ROSSI": identificativo non valido

at com.crystaldecisions.reports.reportdefinition.datainterface.p.a(Unknown Source)

at com.crystaldecisions.reports.dataengine.n.else(Unknown Source)

at com.crystaldecisions.reports.dataengine.n.ns(Unknown Source)

at com.crystaldecisions.reports.dataengine.n.bn(Unknown Source)

at com.crystaldecisions.reports.dataengine.n.bp(Unknown Source)

at com.crystaldecisions.reports.dataengine.n.else(Unknown Source)

at com.crystaldecisions.reports.dataengine.s.a(Unknown Source)

at com.crystaldecisions.reports.dataengine.bk.a(Unknown Source)

at com.crystaldecisions.reports.dataengine.bk.aa(Unknown Source)

at com.crystaldecisions.reports.dataengine.bk.<init>(Unknown Source)

at com.crystaldecisions.reports.dataengine.bk.<init>(Unknown Source)

at com.crystaldecisions.reports.dataengine.bk.<init>(Unknown Source)

at com.crystaldecisions.reports.dataengine.bk.a(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.<init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.if(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.e.l.<init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.e.p.<init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.e.p.a(Unknown Source)

at com.crystaldecisions.reports.formatter.a.c.a(Unknown Source)

at com.crystaldecisions.reports.formatter.a.c.if(Unknown Source)

at com.crystaldecisions.reports.formatter.a.c.a(Unknown Source)

at com.businessobjects.reports.sdk.b.b.int(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.x.a(Unknown Source)

at com.crystaldecisions.proxy.remoteagent.q.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.dd.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.export(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.export(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReportSource.export(Unknown Source)

at com.crystaldecisions.reports.reportengineinterface.JPEReportSource.export(Unknown Source)

at com.crystaldecisions.report.web.event.br.a(Unknown Source)

at com.crystaldecisions.report.web.event.w.a(Unknown Source)

at com.crystaldecisions.report.web.event.b7.broadcast(Unknown Source)

at com.crystaldecisions.report.web.event.av.a(Unknown Source)

at com.crystaldecisions.report.web.WorkflowController.do(Unknown Source)

at com.crystaldecisions.report.web.WorkflowController.doLifecycle(Unknown Source)

at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)

at com.crystaldecisions.report.web.viewer.ReportExportControl.a(Unknown Source)

at com.crystaldecisions.report.web.ServerControl.getHtmlContent(Unknown Source)

at it.svimservice.nsisr.web.acur.servlet.reportpagamentoticket.SvltReportPagamentoTicket.processPageReportPagamentoTicket(SvltReportPagamentoTicket.java:238)

at it.svimservice.nsisr.web.acur.servlet.reportpagamentoticket.SvltReportPagamentoTicket.switchPagina(SvltReportPagamentoTicket.java:87)

at it.svimservice.nsisr.web.condivisi.servlet.MainServlet.processSvlt(MainServlet.java:2006)

at it.svimservice.nsisr.web.condivisi.servlet.MainServlet.doPost(MainServlet.java:77)

at it.svimservice.nsisr.web.condivisi.servlet.MainServlet.doGet(MainServlet.java:64)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)

at it.svimservice.nsisr.web.condivisi.servlet.MainServlet.inviaPagina(MainServlet.java:1325)

at it.svimservice.nsisr.web.condivisi.servlet.MainServlet.processSvlt(MainServlet.java:2023)

at it.svimservice.nsisr.web.condivisi.servlet.MainServlet.doPost(MainServlet.java:77)

at it.svimservice.nsisr.web.condivisi.servlet.MainServlet.doGet(MainServlet.java:64)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)

at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)

at java.lang.Thread.run(Unknown Source)

Caused by: com.crystaldecisions.reports.queryengine.driverImpl.m: Errore JDBC: ORA-00904: "ROSSI": identificativo non valido

at com.crystaldecisions.reports.queryengine.driverImpl.o.eC(Unknown Source)

at com.crystaldecisions.reports.queryengine.driverImpl.o.if(Unknown Source)

at com.crystaldecisions.reports.queryengine.ap.ea(Unknown Source)

at com.crystaldecisions.reports.queryengine.ap.h(Unknown Source)

at com.crystaldecisions.reports.queryengine.ap.dV(Unknown Source)

at com.crystaldecisions.reports.queryengine.ax.if(Unknown Source)

at com.crystaldecisions.reports.queryengine.bc.if(Unknown Source)

at com.crystaldecisions.reports.queryengine.bc.do(Unknown Source)

at com.crystaldecisions.reports.queryengine.bc.do(Unknown Source)

at com.crystaldecisions.reports.queryengine.ae.cy(Unknown Source)

at com.crystaldecisions.reports.queryengine.ae.cz(Unknown Source)

at com.crystaldecisions.reports.queryengine.b1.bc(Unknown Source)

... 78 more

Caused by: java.sql.SQLException: ORA-00904: "ROSSI": identificativo non valido

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)

at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)

at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)

at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1679)

at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1645)

... 90 more

17:19:28,730 ERROR [datasource] Failed to regenerate saved records: cleaning up errors.

17:19:28,730 ERROR [datasource] Failed to do first pass: failed to regenerate saved records.

Hoping your advices can be useful, wish

a great day to You all.