Home » Archived » BIRT » SQL stored procedure query
| |
| Re: SQL stored procedure query [message #210184 is a reply to message #210010] |
Wed, 10 January 2007 06:13   |
|
The arg1,.. are input or output parameters.
If you are passing a parameter to the procedure use
{call testProcedure(?)}
and then set the parameter in the dataset.
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:c2b293b07ad370339278353983830438$1@www.eclipse.org...
> ..and...
>
> when i wish to add a new data set, i right click then select the "new data
> set", at data set type, i select the "sql stored procedure query", then i
> will get "{call procedure-name(arg1,arg2, ...)} "
>
> what is the arg1,arg2...mean?? is that the parameter that i passing in the
> stored procedure??
>
> if i want to select something from the stored procedure, how can i make
> it??
>
> thanks for help.....
>
|
|
| | | | |
| Re: SQL stored procedure query [message #210801 is a reply to message #210565] |
Thu, 11 January 2007 17:38 |
|
Your call should have ? instead of INOUT category VARCHAR(100), and
another ? for INOUT recDate DATE. Then go to the dataset parameter page
and specifiy in/out and the data type.
So it should look like
{call testingPassParameter(?,?)}
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:906c727dd65346f65928c7ae98d5f43f$1@www.eclipse.org...
>i try to call the stored procedure and get the error message as below:
>
> A BIRT exception occurred.
> Plug-in Provider:Eclipse.org
> Plug-in Name:BIRT Data Engine
> Plug-in ID:org.eclipse.birt.data
> Version:2.1.1.v20060922-1058
> Error Code:odaconsumer.CannotPrepareStatement
> Error Message:Failed to prepare the following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
> [{call `testingPassParameter`(INOUT category VARCHAR(100), INOUT recDate
> DATE)
> select category} ]
> Error preparing SQL statement.
> SQL error #1: Callable statments not supported.
>
>
> is that mean that birt 2.1.1 cannot support the INOUT parameter???
>
|
|
| | | |
| Re: help...execute the stored procedure in birt??? [message #211093 is a reply to message #211070] |
Fri, 12 January 2007 06:15 |
 ice70
Messages: 193
Registered: July 2009 |
Senior Member |
|
|
what i done is just create a simple stored procedure as below:
CREATE PROCEDURE `testInAndOut`(IN stmt VARCHAR(300), IN recDateIn DATE,
IN cateInOut VARCHAR(100), IN recDateInOut DATE, OUT cateOut VARCHAR(100),
OUT recDateOut DATE, IN cateIn VARCHAR(100))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
BEGIN
set cateOut = cateIn;
set recDateOut = recDateIn;
/*drop table tmpPassInAndOut;*/
CREATE TABLE IF NOT EXISTS `tmpPassInAndOut`(
point VARCHAR(20),
part_no VARCHAR(100),
category VARCHAR(100),
recDate DATE
);
insert into `tmpPassInAndOut`(point, part_no, category, recDate)
select h.`POINT`, d.PART_ID, i.category, h.`INVOICE_DATE`
from sp_inv_iss h inner join sp_inv_iss_item d ON
h.ID = d.INV_ISS_ID inner join sp_inventory i ON d.PART_ID=i.PART_NO;
/*set @query = CONCAT('Select * ', stmt );
PREPARE qry FROM @query;*/
/*drop table tmpPassInAndOut;*/
END;
then i wish to get the data set from the table "tmpPassInAndOut" from the
stored procedure...
thanks for help....
|
|
| |
| Re: help...execute the stored procedure in birt??? [message #211845 is a reply to message #211468] |
Tue, 16 January 2007 17:53 |
|
Gary posted on the problem with tmp tables and SQL Stored Proecedures.
There is a problem with BIRT trying to use the create return value.
You should be able to call your Java program from BIRT. Then you would be
able to pass your parameter to
the Java program. Is this what you want to do?
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:3ea5b16cbb734261fe42c892ff010e7e$1@www.eclipse.org...
> hi...i found another way to execute my stored procedure...
>
> i create a connection at my java, then i call the stored procedure and
> execute the stored procedure as usual that we execute the stored procedure
> in mySQL...
>
> then, i can get the data set with the "sql select query" data set type...
> but now i wish to pass the inout parameter in my stored procedure... is
> that the only way by using the "sql stored procedure query" data set type
> to pass the inout parameter for stored procedure??
>
> as i know, if i used the "sql stored procedure query", i cannot select
> from the temporary table that i create in the stored procedure...then, i
> cannot drag and drop the data set into my table for creating a listing
> report...
>
> any ideas on it??? Thanks...
>
|
|
| |
| Re: help...execute the stored procedure in birt??? [message #211949 is a reply to message #211929] |
Wed, 17 January 2007 06:36 |
|
You should be able to do it in script like:
importPackage( Packages.my.javapackage );
myjavaclass = new my.javapackage.StoredProcCreator( params["myparameter"] );
myjavaclass.executeMethod();
The only issue I see is that it may not be finished before your dataset
executes.
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:386e718cfbf7f2a2d2a30f934b496b65$1@www.eclipse.org...
> ya...that is what i want...and the problems that i am facing now is unable
> to pass the parameter....
>
> how can i pass the parameter from java into the stored procedure and how
> can i retrieve the parameter as the filter for my report???
>
|
|
| | | |
| Re: help...execute the stored procedure in birt??? [message #212393 is a reply to message #212301] |
Thu, 18 January 2007 16:41 |
|
Where are you putting your classes?
Can you post your report?
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:632ebfab89806ede54bfaea57c438aad$1@www.eclipse.org...
> jason...i keep on trying to pass the parameter into the stored
> procedure...
> and below are the error messages i get:
>
> The following items have errors:
>
> Table (id = 1520): + Failed to prepare the following query for the data
> set type org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [Select *
> from tmprptdetailtrxthistory and
> mprptdetailtrxthistory.category='bell' ]
> Error preparing SQL statement.
> SQL error #1: Callable statments not supported.
>
> odaconsumer.CannotPrepareStatement ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: Failed to
> prepare the following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [Select * from
> tmprptdetailtrxthistory and
> mprptdetailtrxthistory.category='bell' ]Error preparing SQL statement.SQL
> error #1: Callable statments not supported. at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:232)
> at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
> at
> org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:187)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:244)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL
> statement.SQL error #1: Callable statments not supported. ;
> java.sql.SQLException: Callable statments not supported. at
> org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:147)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:210)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:167)
> at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
> .. 51 moreCaused by: java.sql.SQLException: Callable statments not
> supported. at com.mysql.jdbc.Connection.prepareCall(Connection.java:1225)
> at
> org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:142)
> .. 54 more
>
>
>
>
> The following items have errors:
>
> Table (id = 1520): + Cannot set the string value for parameter: 1
> Cannot set preparedStatement parameter string value.
> SQL error #1: Parameter index out of range (1 > 0).
>
> odaconsumer.CannotSetStringParameter ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: Cannot set the
> string value for parameter: 1Cannot set preparedStatement parameter string
> value.SQL error #1: Parameter index out of range (1 > 0). at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oSetString(PreparedStatement.java:3703)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etString(PreparedStatement.java:3381)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etParameterValue(PreparedStatement.java:2754)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etParameterValue(PreparedStatement.java:2699)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.setInp utParameterBinding(DataSourceQuery.java:555)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.addPar ameterDefns(DataSourceQuery.java:335)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:252)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot set
> preparedStatement parameter string value.SQL error #1: Parameter index out
> of range (1 > 0). ; java.sql.SQLException: Parameter index out of range
> (1 > 0). at
> org.eclipse.birt.report.data.oda.jdbc.Statement.setString(St atement.java:526)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.setString(OdaQuery.java:711)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oSetString(PreparedStatement.java:3696)
> .. 54 moreCaused by: java.sql.SQLException: Parameter index out of range
> (1 > 0). at
> com.mysql.jdbc.PreparedStatement.setInternal(PreparedStateme nt.java:1940)
> at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement .java:1075)
> at
> org.eclipse.birt.report.data.oda.jdbc.Statement.setString(St atement.java:522)
> .. 56 more
>
>
> what does these error means???
>
> as your references, i am using birt2.1.1 with mysql5.0
>
|
|
| | | |
| Re: help...execute the stored procedure in birt??? [message #212810 is a reply to message #212613] |
Fri, 19 January 2007 16:05 |
|
StoredProcCreator was an example of what your Java class could be called.
In your case it will be
importPackage( Packages.mypackage );
myjavaclass = new mypackage.StoredProcedure()
myjavaclass.callProc1( params["myparameter"] )
Note that you will have to modify callProc1 to accept the parameter.
You may also want to get a return value from the call.
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:ce302a48c48611418156fe85e04bbf5d$1@www.eclipse.org...
> sorry...write too fast...
> hi jason...
>
> last time you said that i can pass the parameter as below:
>
> importPackage( Packages.my.javapackage );
> myjavaclass = new my.javapackage.StoredProcCreator(
> params["myparameter"] );
> myjavaclass.executeMethod();
>
> may i know the "StoredProcCreator" means???
>
>
> the way that i execute my stored procedure from java is as below:
>
> package mypackage;
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.SQLException;
>
> public class StoredProcedure {
> public static void callProc1(){
> Connection con = getConnection();
> if(con != null){
> try {
> con.prepareCall("{call newProc(myParameter)}").executeQuery(); }
> catch (SQLException e) {
> e.printStackTrace();
> }finally{
> try {
> con.close();
> } catch (SQLException e) {
> e.printStackTrace();
> }
> }
> }
> }
>
> public static Connection getConnection(){
> try {
> Class.forName( "com.mysql.jdbc.Driver" );
> Connection con = DriverManager.getConnection("root","user","password" );
> return con;
> } catch (ClassNotFoundException e) {
> e.printStackTrace();
> return null;
> }catch (SQLException e) {
> e.printStackTrace();
> return null;
> }
> }
> }
>
>
|
|
| |
| Re: help...execute the stored procedure in birt??? [message #213073 is a reply to message #212932] |
Mon, 22 January 2007 17:30 |
|
Please post the report.
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:1ca6c4c71eeb6eb432e992f8c9a208e5$1@www.eclipse.org...
> jason...
>
> it still have the error message as below:
>
> The following items have errors:
>
> Table (id = 1520): + There are errors evaluating script
> "this.queryText="Select * "+ params["stmt"];
>
> importPackage(Packages.my.com.shinyang.ilms.ui.report;
>
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["cateFr"]);
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["cateTo"]);
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["dateFr"]);
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["dateTo"]);
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateFr"]);
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateTo"]);
>
> StoredProcedure.executeMethod();". Error.ScriptEvaluationError ( 1
> time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "this.queryText="Select * "+
> params["stmt" ];importPackage(Packages.my.com.shinyang.ilms.ui.report;Stor edProcedure
> = new my.com.shinyang.ilms.ui.report.callProc1(
> params["cateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["cateTo"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["dateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["dateTo"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateTo"]);StoredProcedure.executeMethod();". at
> org.eclipse.birt.report.engine.script.internal.DtEScriptExec utor.handleJS(DtEScriptExecutor.java:76)
> at
> org.eclipse.birt.report.engine.script.internal.DataSetScript Executor.handleJS(DataSetScriptExecutor.java:159)
> at
> org.eclipse.birt.report.engine.script.internal.DataSetScript Executor.handleBeforeOpen(DataSetScriptExecutor.java:64)
> at
> org.eclipse.birt.data.engine.impl.DataSetRuntime.beforeOpen( DataSetRuntime.java:495)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:204)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.eclipse.birt.data.engine.core.DataException: A BIRT exception
> occurred: Error evaluating Javascript expression. Script engine error:
> missing ) after argument list
> (DataSet[OpenCloseAnalysis].__bm_beforeOpen#4) Script source:
> DataSet[OpenCloseAnalysis].__bm_beforeOpen, line: 1, text:function
> __bm_beforeOpen() {this.queryText="Select * "+
> params["stmt" ];importPackage(Packages.my.com.shinyang.ilms.ui.report;Stor edProcedure
> = new my.com.shinyang.ilms.ui.report.callProc1(
> params["cateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["cateTo"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["dateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["dateTo"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateTo"]);StoredProcedure.executeMethod();} . See next
> exception for more information.Error evaluating Javascript expression.
> Script engine error: missing ) after argument list
> (DataSet[OpenCloseAnalysis].__bm_beforeOpen#4) Script source:
> DataSet[OpenCloseAnalysis].__bm_beforeOpen, line: 1, text:function
> __bm_beforeOpen() {this.queryText="Select * "+
> params["stmt" ];importPackage(Packages.my.com.shinyang.ilms.ui.report;Stor edProcedure
> = new my.com.shinyang.ilms.ui.report.callProc1(
> params["cateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["cateTo"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["dateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["dateTo"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateTo"]);StoredProcedure.executeMethod();} at
> org.eclipse.birt.data.engine.core.DataException.wrap(DataExc eption.java:118)
> at
> org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJ SAsExpr(ScriptEvalUtil.java:552)
> at
> org.eclipse.birt.data.engine.script.JSMethodRunner.runScript (JSMethodRunner.java:74)
> at
> org.eclipse.birt.report.engine.script.internal.DtEScriptExec utor.handleJS(DtEScriptExecutor.java:71)
> .. 50 moreCaused by: org.eclipse.birt.core.exception.CoreException: Error
> evaluating Javascript expression. Script engine error: missing ) after
> argument list (DataSet[OpenCloseAnalysis].__bm_beforeOpen#4) Script
> source: DataSet[OpenCloseAnalysis].__bm_beforeOpen, line: 1, text:function
> __bm_beforeOpen() {this.queryText="Select * "+
> params["stmt" ];importPackage(Packages.my.com.shinyang.ilms.ui.report;Stor edProcedure
> = new my.com.shinyang.ilms.ui.report.callProc1(
> params["cateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["cateTo"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["dateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["dateTo"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateFr"]);StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateTo"]);StoredProcedure.executeMethod();} at
> org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoExc eption(JavascriptEvalUtil.java:281)
> at
> org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawS cript(JavascriptEvalUtil.java:105)
> at
> org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScri pt(JavascriptEvalUtil.java:137)
> at
> org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJ SAsExpr(ScriptEvalUtil.java:548)
> .. 52 moreCaused by: org.mozilla.javascript.EvaluatorException: missing )
> after argument list (DataSet[OpenCloseAnalysis].__bm_beforeOpen#4) at
> org.mozilla.javascript.DefaultErrorReporter.runtimeError(Def aultErrorReporter.java:95)
> at
> org.mozilla.javascript.DefaultErrorReporter.error(DefaultErr orReporter.java:82)
> at org.mozilla.javascript.Parser.addError(Parser.java:120) at
> org.mozilla.javascript.Parser.reportError(Parser.java:126) at
> org.mozilla.javascript.Parser.mustMatchToken(Parser.java:212 ) at
> org.mozilla.javascript.Parser.argumentList(Parser.java:1595) at
> org.mozilla.javascript.Parser.memberExprTail(Parser.java:172 4) at
> org.mozilla.javascript.Parser.memberExpr(Parser.java:1640) at
> org.mozilla.javascript.Parser.unaryExpr(Parser.java:1500) at
> org.mozilla.javascript.Parser.mulExpr(Parser.java:1429) at
> org.mozilla.javascript.Parser.addExpr(Parser.java:1410) at
> org.mozilla.javascript.Parser.shiftExpr(Parser.java:1390) at
> org.mozilla.javascript.Parser.relExpr(Parser.java:1364) at
> org.mozilla.javascript.Parser.eqExpr(Parser.java:1320) at
> org.mozilla.javascript.Parser.bitAndExpr(Parser.java:1309) at
> org.mozilla.javascript.Parser.bitXorExpr(Parser.java:1298) at
> org.mozilla.javascript.Parser.bitOrExpr(Parser.java:1287) at
> org.mozilla.javascript.Parser.andExpr(Parser.java:1275) at
> org.mozilla.javascript.Parser.orExpr(Parser.java:1263) at
> org.mozilla.javascript.Parser.condExpr(Parser.java:1246) at
> org.mozilla.javascript.Parser.assignExpr(Parser.java:1228) at
> org.mozilla.javascript.Parser.expr(Parser.java:1217) at
> org.mozilla.javascript.Parser.statementHelper(Parser.java:11 04) at
> org.mozilla.javascript.Parser.statement(Parser.java:616) at
> org.mozilla.javascript.Parser.parseFunctionBody(Parser.java: 409) at
> org.mozilla.javascript.Parser.function(Parser.java:515) at
> org.mozilla.javascript.Parser.parse(Parser.java:342) at
> org.mozilla.javascript.Parser.parse(Parser.java:287) at
> org.mozilla.javascript.Context.compileImpl(Context.java:2349 ) at
> org.mozilla.javascript.Context.compileString(Context.java:13 72) at
> org.mozilla.javascript.Context.compileString(Context.java:13 61) at
> org.eclipse.birt.core.script.JavascriptEvalUtil.getCompiledS cript(JavascriptEvalUtil.java:155)
> at
> org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawS cript(JavascriptEvalUtil.java:94)
> .. 54 more
> + Failed to prepare the following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [{call
> rptOpenClose(?)};]
> Error preparing SQL statement.
> SQL error #1: Callable statments not supported.
>
> odaconsumer.CannotPrepareStatement ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: Failed to
> prepare the following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [{call
> rptOpenClose(?)};]Error preparing SQL statement.SQL error #1: Callable
> statments not supported. at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:232)
> at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
> at
> org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:187)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:244)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL
> statement.SQL error #1: Callable statments not supported. ;
> java.sql.SQLException: Callable statments not supported. at
> org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:147)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:210)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:167)
> at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
> .. 51 moreCaused by: java.sql.SQLException: Callable statments not
> supported. at com.mysql.jdbc.Connection.prepareCall(Connection.java:1225)
> at
> org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:142)
> .. 54 more
>
>
>
> how comes? and what this error message means??
>
|
|
| |
| Re: help...execute the stored procedure in birt??? [message #213367 is a reply to message #213186] |
Tue, 23 January 2007 18:08 |
|
A couple of things:
params["stmt"]. I did not see this in your list of parameters.
Also the parameter names are case sensitive.
I am not certain how your code is configured, but this will create 6
instances of callProc1, and
only the last will use the executeMethod.
Jason
str1 = params["stmt"].value;
importPackage(Packages.my.com.shinyang.ilms.ui.report;
StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
params["cateFr"]);
StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
params["cateTo"]);
StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
params["dateFr"]);
StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
params["dateTo"]);
StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
params["subCateFr"]);
StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
params["subCateTo"]);
StoredProcedure.executeMethod();
"70" <klhuang@shinyang.com.my> wrote in message
news:162a4055505cd65de4623f86260a968f$1@www.eclipse.org...
> hi, jason...this is my report...
>
> <?xml version="1.0" encoding="UTF-8"?>
> <!-- Written by Eclipse BIRT 2.0 -->
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.1.1.v20060922-1058 Build <20060926-0959></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2006 <<Your Company Name
> here>></property>
> <method name="initialize"><![CDATA[str1 = params["stmt"].value;
>
> importPackage(Packages.my.com.shinyang.ilms.ui.report;
>
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["cateFr"]);
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["cateTo"]);
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["dateFr"]);
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["dateTo"]);
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateFr"]);
> StoredProcedure = new my.com.shinyang.ilms.ui.report.callProc1(
> params["subCateTo"]);
>
> StoredProcedure.executeMethod();]]></method>
> <parameters>
> <scalar-parameter name="CateFr" id="6">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="CateTo" id="7">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="DateFr" id="10">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="DateTo" id="11">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="SubCateFr" id="8">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="SubCateTo" id="9">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="4">
> <property
> name="odaDriverClass">com.mysql.jdbc.Driver</property>
> <property
> name="odaURL">jdbc:mysql://127.0.0.1:3306/ILMS</property>
> <property name="odaUser">ilms</property>
> <encrypted-property
> name="odaPassword">MTIz</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet "
> name="OpenCloseAnalysis" id="5">
> <structure name="cachedMetaData"/>
> <property name="dataSource">Data Source</property>
> <method name="beforeOpen"><![CDATA[//this.queryText="Select *
> "+ params["stmt"];]]></method>
> <list-property name="parameters">
> <structure>
> <property name="name">param1</property>
> <property name="paramName">CateFr</property>
> <property name="nativeName"></property>
> <property name="dataType">any</property>
> <property name="nativeDataType">0</property>
> <property name="position">1</property>
> <property name="isOptional">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">param2</property>
> <property name="paramName">CateTo</property>
> <property name="nativeName"></property>
> <property name="dataType">any</property>
> <property name="nativeDataType">0</property>
> <property name="position">2</property>
> <property name="isOptional">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">param3</property>
> <property name="paramName">SubCateFr</property>
> <property name="nativeName"></property>
> <property name="dataType">any</property>
> <property name="nativeDataType">0</property>
> <property name="position">3</property>
> <property name="isOptional">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">param4</property>
> <property name="paramName">SubCateTo</property>
> <property name="nativeName"></property>
> <property name="dataType">any</property>
> <property name="nativeDataType">0</property>
> <property name="position">4</property>
> <property name="isOptional">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">param5</property>
> <property name="paramName">DateFr</property>
> <property name="nativeName"></property>
> <property name="dataType">any</property>
> <property name="nativeDataType">0</property>
> <property name="position">5</property>
> <property name="isOptional">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">param6</property>
> <property name="paramName">DateTo</property>
> <property name="nativeName"></property>
> <property name="dataType">any</property>
> <property name="nativeDataType">0</property>
> <property name="position">6</property>
> <property name="isOptional">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> </list-property>
> <property name="queryText">{call rptOpenClose(?)};</property>
> <xml-property name="designerValues"><![CDATA[<?xml
> version="1.0" encoding="UTF-8"?>
> <model:DesignValues
> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>1.0</Version>
> <design:DataSetParameters>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name></design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints/>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> <design:masksValue>false</design:masksValue>
> <design:uiHints>
> <design:promptStyle>TextField</design:promptStyle>
> </design:uiHints>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name></design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints/>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> <design:masksValue>false</design:masksValue>
> <design:uiHints>
> <design:promptStyle>TextField</design:promptStyle>
> </design:uiHints>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name></design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints/>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> <design:masksValue>false</design:masksValue>
> <design:uiHints>
> <design:promptStyle>TextField</design:promptStyle>
> </design:uiHints>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name></design:name>
> <design:position>4</design:position>
> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints/>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> <design:masksValue>false</design:masksValue>
> <design:uiHints>
> <design:promptStyle>TextField</design:promptStyle>
> </design:uiHints>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name></design:name>
> <design:position>5</design:position>
> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints/>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> <design:masksValue>false</design:masksValue>
> <design:uiHints>
> <design:promptStyle>TextField</design:promptStyle>
> </design:uiHints>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name></design:name>
> <design:position>6</design:position>
> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
> <design:nullability>Unknown</design:nullability>
> <design:uiHints/>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</design:optional>
> <design:masksValue>false</design:masksValue>
> <design:uiHints>
> <design:promptStyle>TextField</design:promptStyle>
> </design:uiHints>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> </design:DataSetParameters>
> </model:DesignValues>]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="HeaderStyle" id="1790">
> <property name="fontWeight">bolder</property>
> <property name="textUnderline">underline</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <property name="type">a4</property>
> <property name="orientation">landscape</property>
> </simple-master-page>
> </page-setup>
> <body>
> <grid id="1447">
> <property name="fontSize">smaller</property>
> <property name="width">100%</property>
> <column id="1448">
> <property name="width">1.6041666667in</property>
> </column>
> <column id="1449">
> <property name="width">2.7708333333in</property>
> </column>
> <column id="1450">
> <property name="width">1.625in</property>
> </column>
> <row id="1451">
> <cell id="1452">
> <grid id="1749">
> <property name="width">100%</property>
> <column id="1776">
> <property name="fontWeight">bold</property>
> </column>
> <column id="1750"/>
> <column id="1751"/>
> <row id="1752">
> <cell id="1770">
> <label id="1777">
> <property
> name="fontSize">x-small</property>
> <text-property name="text">Category
> :</text-property>
> </label>
> </cell>
> <cell id="1753">
> <data id="1748">
> <property
> name="fontSize">x-small</property>
> <property
> name="textAlign">right</property>
> <list-property name="boundDataColumns">
> <structure>
> <property
> name="name">CateFr</property>
> <expression
> name="expression">params["CateFr"]</expression>
> <property
> name="dataType">any</property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">CateFr</property>
> </data>
> </cell>
> <cell id="1754">
> <data id="1783">
> <property
> name="fontSize">x-small</property>
> <list-property name="boundDataColumns">
> <structure>
> <property
> name="name">cateTo</property>
> <expression name="expression">"
> to "+params["CateTo"]</expression>
> <property
> name="dataType">any</property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">cateTo</property>
> </data>
> </cell>
> </row>
> <row id="1755">
> <cell id="1771">
> <label id="1778">
> <property
> name="fontSize">x-small</property>
> <text-property name="text">Sub Cate
> :</text-property>
> </label>
> </cell>
> <cell id="1756">
> <data id="1784">
> <property
> name="fontSize">x-small</property>
> <property
> name="textAlign">right</property>
> <list-property name="boundDataColumns">
> <structure>
> <property
> name="name">subCateFr</property>
> <expression
> name="expression">params["SubCateFr"]</expression>
> <property
> name="dataType">any</property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">subCateFr</property>
> </data>
> </cell>
> <cell id="1757">
> <data id="1785">
> <property
> name="fontSize">x-small</property>
> <list-property name="boundDataColumns">
> <structure>
> <property
> name="name">subCateTo</property>
> <expression name="expression">"
> to "+params["SubCateTo"]</expression>
> <property
> name="dataType">any</property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">subCateTo</property>
> </data>
> </cell>
> </row>
> <row id="1758">
> <cell id="1772">
> <label id="1779">
> <property
> name="fontSize">x-small</property>
> <text-property name="text">Date
> :</text-property>
> </label>
> </cell>
> <cell id="1759">
> <data id="1786">
> <property
> name="fontSize">x-small</property>
> <property
> name="textAlign">right</property>
> <list-property name="boundDataColumns">
> <structure>
> <property
> name="name">dateFr</property>
> <expression
> name="expression">params["DateFr"]</expression>
> <property
> name="dataType">any</property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">dateFr</property>
> </data>
> </cell>
> <cell id="1760">
> <data id="1787">
> <property
> name="fontSize">x-small</property>
> <list-property name="boundDataColumns">
> <structure>
> <property
> name="name">dateTo</property>
> <expression name="expression">"
> to "+params["DateTo"]</expression>
> <property
> name="dataType">any</property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">dateTo</property>
> </data>
> </cell>
> </row>
> </grid>
> </cell>
> <cell id="1453">
> <text id="1517">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<center>
> <h3>Shin Yang Sdn Bhd</h3><br>
> <h4>Stock Opening And Closing Analysis Report</h4>
> </center><br>]]></text-property>
> </text>
> </cell>
> <cell id="1455">
> <grid id="1710">
> <property name="width">100%</property>
> <column id="1711"/>
> <column id="1712">
> <property name="fontSize">smaller</property>
> <property name="textAlign">left</property>
> </column>
> <column id="1713">
> <property name="fontSize">smaller</property>
> <property name="textAlign">left</property>
> </column>
> <row id="1743">
> <cell id="1744">
> <label id="1747">
> <text-property name="text">Date
> :</text-property>
> </label>
> </cell>
> <cell id="1745">
> <property name="colSpan">2</property>
> <property name="rowSpan">1</property>
> <text id="1518">
> <property
> name="textAlign">left</property>
> <property
> name="contentType">html</property>
> <text-property
> name="content"><![CDATA[<value-of format="dd-MM-yyyy">new
> Date()</value-of>]]></text-property>
> </text>
> </cell>
> </row>
> </grid>
> </cell>
> </row>
> </grid>
> <grid id="746">
> <property name="fontSize">x-small</property>
> <property name="width">100%</property>
> <column id="747">
> <property name="width">3cm</property>
> </column>
> <column id="748">
> <property name="width">5cm</property>
> <property name="textAlign">center</property>
> </column>
> <column id="749">
> <property name="width">7cm</property>
> <property name="textAlign">center</property>
> </column>
> <column id="750">
> <property name="width">7cm</property>
> <property name="textAlign">center</property>
> </column>
> <column id="751">
> <property name="width">5cm</property>
> <property name="textAlign">center</property>
> </column>
> <row id="752">
> <cell id="753"/>
> <cell id="754">
> <label id="758">
> <property name="textAlign">center</property>
> <text-property name="text"><-----OPENING
> BALANCE-----></text-property>
> </label>
> </cell>
> <cell id="755">
> <label id="759">
> <property name="textAlign">center</property>
> <text-property
> name="text"><------------------RECEIVINGS------------------ ></text-property>
> </label>
> </cell>
> <cell id="756">
> <label id="760">
> <property name="textAlign">center</property>
> <text-property
> name="text"><--------------------ISSUINGS-------------------- ></text-property>
> </label>
> </cell>
> <cell id="757">
> <label id="761">
> <property name="textAlign">center</property>
> <text-property name="text"><-----CLOSING
> BALANCE-----></text-property>
> </label>
> </cell>
> </row>
> </grid>
> <table id="1520">
> <property name="fontSize">x-small</property>
> <property name="width">100%</property>
> <property name="dataSet">OpenCloseAnalysis</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">data item</property>
> <expression
> name="expression">Total.runningCount()+"."</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <column id="1593">
> <property name="width">1cm</property>
> </column>
> <column id="1596">
> <property name="width">2cm</property>
> </column>
> <column id="1684">
> <property name="width">0.1cm</property>
> </column>
> <column id="1599">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1600">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1601">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1602">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1688">
> <property name="width">0.1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1603">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1604">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1605">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1606">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1607">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1608">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1692">
> <property name="width">0.1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1609">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1610">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1611">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1612">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1613">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1614">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1696">
> <property name="width">0.1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1615">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1663">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1671">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1667">
> <property name="width">1cm</property>
> <property name="textAlign">right</property>
> </column>
> <column id="1700">
> <property name="width">0.1cm</property>
> <property name="textAlign">right</property>
> </column>
> <header>
> <row id="1521">
> <cell id="1522">
> <label id="527">
> <property name="style">HeaderStyle</property>
> <text-property name="text">No</text-property>
> </label>
> </cell>
> <cell id="1525">
> <label id="525">
> <property name="style">HeaderStyle</property>
> <text-property
> name="text">Category</text-property>
> </label>
> </cell>
> <cell id="1681"/>
> <cell id="1528">
> <label id="794">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Qty
> (+)</text-property>
> </label>
> </cell>
> <cell id="1529">
> <label id="795">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Amt
> ($)</text-property>
> </label>
> </cell>
> <cell id="1530">
> <label id="796">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Qty
> (-)</text-property>
> </label>
> </cell>
> <cell id="1531">
> <label id="805">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Rtn
> Amt($)</text-property>
> </label>
> </cell>
> <cell id="1685"/>
> <cell id="1532">
> <label id="530">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Qty
> (+)</text-property>
> </label>
> </cell>
> <cell id="1533">
> <label id="531">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Amt
> ($)</text-property>
> </label>
> </cell>
> <cell id="1534">
> <label id="532">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Qty
> (-)</text-property>
> </label>
> </cell>
> <cell id="1535">
> <label id="533">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Rtn
> Amt($)</text-property>
> </label>
> </cell>
> <cell id="1536">
> <label id="1061">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Nett
> Qty</text-property>
> </label>
> </cell>
> <cell id="1537">
> <label id="1062">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Nett
> Amt($)</text-property>
> </label>
> </cell>
> <cell id="1689"/>
> <cell id="1538">
> <label id="538">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Qty
> (+)</text-property>
> </label>
> </cell>
> <cell id="1539">
> <label id="539">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Amt
> ($)</text-property>
> </label>
> </cell>
> <cell id="1540">
> <label id="540">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Qty
> (-)</text-property>
> </label>
> </cell>
> <cell id="1541">
> <label id="541">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Rtn
> Amt($)</text-property>
> </label>
> </cell>
> <cell id="1542">
> <label id="1077">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Nett
> Qty</text-property>
> </label>
> </cell>
> <cell id="1543">
> <label id="1078">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Nett
> Amt($)</text-property>
> </label>
> </cell>
> <cell id="1693"/>
> <cell id="1544">
> <label id="846">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Qty
> (+)</text-property>
> </label>
> </cell>
> <cell id="1660">
> <label id="847">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Amt
> ($)</text-property>
> </label>
> </cell>
> <cell id="1668">
> <label id="848">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Qty
> (-)</text-property>
> </label>
> </cell>
> <cell id="1664">
> <label id="849">
> <property name="style">HeaderStyle</property>
> <text-property name="text">Rtn
> Amt($)</text-property>
> </label>
> </cell>
> <cell id="1697"/>
> </row>
> </header>
> <detail>
> <row id="1545">
> <cell id="1546">
> <data id="1701">
> <property name="resultSetColumn">data
> item</property>
> </data>
> </cell>
> <cell id="1549"/>
> <cell id="1682"/>
> <cell id="1552"/>
> <cell id="1553"/>
> <cell id="1554"/>
> <cell id="1555"/>
> <cell id="1686"/>
> <cell id="1556"/>
> <cell id="1557"/>
> <cell id="1558"/>
> <cell id="1559"/>
> <cell id="1560"/>
> <cell id="1561"/>
> <cell id="1690"/>
> <cell id="1562"/>
> <cell id="1563"/>
> <cell id="1564"/>
> <cell id="1565"/>
> <cell id="1566"/>
> <cell id="1567"/>
> <cell id="1694"/>
> <cell id="1568"/>
> <cell id="1661"/>
> <cell id="1669"/>
> <cell id="1665"/>
> <cell id="1698"/>
> </row>
> </detail>
> <footer>
> <row id="1569">
> <cell id="1570"/>
> <cell id="1573"/>
> <cell id="1683"/>
> <cell id="1576"/>
> <cell id="1577"/>
> <cell id="1578"/>
> <cell id="1579"/>
> <cell id="1687"/>
> <cell id="1580"/>
> <cell id="1581"/>
> <cell id="1582"/>
> <cell id="1583"/>
> <cell id="1584"/>
> <cell id="1585"/>
> <cell id="1691"/>
> <cell id="1586"/>
> <cell id="1587"/>
> <cell id="1588"/>
> <cell id="1589"/>
> <cell id="1590"/>
> <cell id="1591"/>
> <cell id="1695"/>
> <cell id="1592"/>
> <cell id="1662"/>
> <cell id="1670"/>
> <cell id="1666"/>
> <cell id="1699"/>
> </row>
> </footer>
> </table>
> </body>
> </report>
>
>
|
|
| |
| Re: help...execute the stored procedure in birt??? [message #213734 is a reply to message #213510] |
Wed, 24 January 2007 17:05 |
|
when you use the new keyword you are creating an instance of the class.
I do not understand the question about the call rptOpenClose(), because I
thought you were not
doing a stored procedure call in the data set. If you were there would be a
? for each parameter.
Did you check the case on all your parameters?
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:89ef37119f50dd1421ff1507da06202e$1@www.eclipse.org...
> hi, jason...
>
> i add on the params["stmt"]...but it still not working...
> and what do you mean by " this will create 6 instances of callProc1, and
> only the last will use the executeMethod." ???
>
> is that related to the query i write? [{call rptOpenClose(?)};]
> or it should be write as [{call rptOpenClose(?,?,?,?,?,?)};] because i am
> passing six params???
>
> is that all code as below,written at the script where method is
> "initialize" ?
>
> str1 = params["stmt"].value;
> importPackage(Packages.my.com.shinyang.ilms.ui.report;
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["cateFr"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["cateTo"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["dateFr"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["dateTo"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["subCateFr"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["subCateTo"]);
> StoredProcedure.executeMethod();
>
> very thanks for help...
>
>
|
|
|
| Re: help...execute the stored procedure in birt??? [message #213870 is a reply to message #213734] |
Thu, 25 January 2007 00:09 |
ice70
Messages: 193
Registered: July 2009 |
Senior Member |
|
|
actually that is also what i wonder.is that the query {call
rptOpenClose(?)}; where i write at the "data set--> query" means that i am
calling the stored procedure from the data set?
can you get what i mean?
yes, i check all the case for the parameter...still got the error message
as below:
The following items have errors:
ReportDesign (id = 1):
+ There are errors evaluating script "str1 = params["stmt"].value;
importPackage(Packages.my.com.shinyang.ilms.ui.report;
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["cateFr"]);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["cateTo"]);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["dateFr"]);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["dateTo"]);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["subCateFr"]);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["subCateTo"]);
StoredProcedure.executeMethod();".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "str1 =
params["stmt" ].value;importPackage(Packages.my.com.shinyang.ilms.ui.repor t;StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["cateFr"]);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["cateTo"]);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["dateFr"]);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["dateTo"]);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["subCateFr"]);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["subCateTo"]);StoredProcedure.executeMethod(); ".
at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
at
org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJSInternal(ScriptExecutor.java:66)
at
org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJS(ScriptExecutor.java:50)
at
org.eclipse.birt.report.engine.script.internal.ReportScriptE xecutor.handleInitialize(ReportScriptExecutor.java:28)
at
org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesig n(EngineTask.java:860)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:149)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at
org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)Caused by:
org.mozilla.javascript.EvaluatorException: missing ) after argument list
(<inline>#3) at
org.mozilla.javascript.DefaultErrorReporter.runtimeError(Def aultErrorReporter.java:95)
at
org.mozilla.javascript.DefaultErrorReporter.error(DefaultErr orReporter.java:82)
at org.mozilla.javascript.Parser.addError(Parser.java:120) at
org.mozilla.javascript.Parser.reportError(Parser.java:126) at
org.mozilla.javascript.Parser.mustMatchToken(Parser.java:212 ) at
org.mozilla.javascript.Parser.argumentList(Parser.java:1595) at
org.mozilla.javascript.Parser.memberExprTail(Parser.java:172 4) at
org.mozilla.javascript.Parser.memberExpr(Parser.java:1640) at
org.mozilla.javascript.Parser.unaryExpr(Parser.java:1500) at
org.mozilla.javascript.Parser.mulExpr(Parser.java:1429) at
org.mozilla.javascript.Parser.addExpr(Parser.java:1410) at
org.mozilla.javascript.Parser.shiftExpr(Parser.java:1390) at
org.mozilla.javascript.Parser.relExpr(Parser.java:1364) at
org.mozilla.javascript.Parser.eqExpr(Parser.java:1320) at
org.mozilla.javascript.Parser.bitAndExpr(Parser.java:1309) at
org.mozilla.javascript.Parser.bitXorExpr(Parser.java:1298) at
org.mozilla.javascript.Parser.bitOrExpr(Parser.java:1287) at
org.mozilla.javascript.Parser.andExpr(Parser.java:1275) at
org.mozilla.javascript.Parser.orExpr(Parser.java:1263) at
org.mozilla.javascript.Parser.condExpr(Parser.java:1246) at
org.mozilla.javascript.Parser.assignExpr(Parser.java:1228) at
org.mozilla.javascript.Parser.expr(Parser.java:1217) at
org.mozilla.javascript.Parser.statementHelper(Parser.java:11 04) at
org.mozilla.javascript.Parser.statement(Parser.java:616) at
org.mozilla.javascript.Parser.parse(Parser.java:347) at
org.mozilla.javascript.Parser.parse(Parser.java:287) at
org.mozilla.javascript.Context.compileImpl(Context.java:2349 ) at
org.mozilla.javascript.Context.compileString(Context.java:13 72) at
org.mozilla.javascript.Context.compileString(Context.java:13 61) at
org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:221) at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
... 38 more
Table (id = 1520):
+ Failed to prepare the following query for the data set type
org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
[{call rptOpenClose(?,?,?,?,?,?)};]
Error preparing SQL statement.
SQL error #1: Callable statments not supported.
odaconsumer.CannotPrepareStatement ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: Failed to
prepare the following query for the data set type
org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [{call
rptOpenClose(?,?,?,?,?,?)};]Error preparing SQL statement.SQL error #1:
Callable statments not supported. at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:232)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
at
org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:187)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:244)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at
org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)Caused by:
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL
statement.SQL error #1: Callable statments not supported. ;
java.sql.SQLException: Callable statments not supported. at
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:147)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:210)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:167)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
... 51 moreCaused by: java.sql.SQLException: Callable statments not
supported. at com.mysql.jdbc.Connection.prepareCall(Connection.java:1225)
at
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:142)
... 54 more
|
|
|
| Re: help...execute the stored procedure in birt??? [message #213879 is a reply to message #213870] |
Thu, 25 January 2007 02:33 |
|
I just looked at your report again and I did not realize you were calling
the stored procedure in code and in the data set.
If you call it in the dataset you need a ? for every parameter so ?, ?, ..
If the initialize you are calling
importPackage(Packages.my.com.shinyang.ilms.ui.report;
You are missing the close paren.
importPackage(Packages.my.com.shinyang.ilms.ui.report);
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:eea5765d916ab8c686d75e5337801cb9$1@www.eclipse.org...
> actually that is also what i wonder.is that the query {call
> rptOpenClose(?)}; where i write at the "data set--> query" means that i am
> calling the stored procedure from the data set?
>
> can you get what i mean?
>
> yes, i check all the case for the parameter...still got the error message
> as below:
>
> The following items have errors:
>
> ReportDesign (id = 1): + There are errors evaluating script "str1 =
> params["stmt"].value;
>
> importPackage(Packages.my.com.shinyang.ilms.ui.report;
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["cateFr"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["cateTo"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["dateFr"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["dateTo"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["subCateFr"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["subCateTo"]);
> StoredProcedure.executeMethod();". Error.ScriptEvaluationError ( 1
> time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "str1 =
> params["stmt" ].value;importPackage(Packages.my.com.shinyang.ilms.ui.repor t;StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["cateFr"]);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["cateTo"]);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["dateFr"]);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["dateTo"]);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["subCateFr"]);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["subCateTo"]);StoredProcedure.executeMethod(); ".
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
> at
> org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJSInternal(ScriptExecutor.java:66)
> at
> org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJS(ScriptExecutor.java:50)
> at
> org.eclipse.birt.report.engine.script.internal.ReportScriptE xecutor.handleInitialize(ReportScriptExecutor.java:28)
> at
> org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesig n(EngineTask.java:860)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:149)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.mozilla.javascript.EvaluatorException: missing ) after argument list
> (<inline>#3) at
> org.mozilla.javascript.DefaultErrorReporter.runtimeError(Def aultErrorReporter.java:95)
> at
> org.mozilla.javascript.DefaultErrorReporter.error(DefaultErr orReporter.java:82)
> at org.mozilla.javascript.Parser.addError(Parser.java:120) at
> org.mozilla.javascript.Parser.reportError(Parser.java:126) at
> org.mozilla.javascript.Parser.mustMatchToken(Parser.java:212 ) at
> org.mozilla.javascript.Parser.argumentList(Parser.java:1595) at
> org.mozilla.javascript.Parser.memberExprTail(Parser.java:172 4) at
> org.mozilla.javascript.Parser.memberExpr(Parser.java:1640) at
> org.mozilla.javascript.Parser.unaryExpr(Parser.java:1500) at
> org.mozilla.javascript.Parser.mulExpr(Parser.java:1429) at
> org.mozilla.javascript.Parser.addExpr(Parser.java:1410) at
> org.mozilla.javascript.Parser.shiftExpr(Parser.java:1390) at
> org.mozilla.javascript.Parser.relExpr(Parser.java:1364) at
> org.mozilla.javascript.Parser.eqExpr(Parser.java:1320) at
> org.mozilla.javascript.Parser.bitAndExpr(Parser.java:1309) at
> org.mozilla.javascript.Parser.bitXorExpr(Parser.java:1298) at
> org.mozilla.javascript.Parser.bitOrExpr(Parser.java:1287) at
> org.mozilla.javascript.Parser.andExpr(Parser.java:1275) at
> org.mozilla.javascript.Parser.orExpr(Parser.java:1263) at
> org.mozilla.javascript.Parser.condExpr(Parser.java:1246) at
> org.mozilla.javascript.Parser.assignExpr(Parser.java:1228) at
> org.mozilla.javascript.Parser.expr(Parser.java:1217) at
> org.mozilla.javascript.Parser.statementHelper(Parser.java:11 04) at
> org.mozilla.javascript.Parser.statement(Parser.java:616) at
> org.mozilla.javascript.Parser.parse(Parser.java:347) at
> org.mozilla.javascript.Parser.parse(Parser.java:287) at
> org.mozilla.javascript.Context.compileImpl(Context.java:2349 ) at
> org.mozilla.javascript.Context.compileString(Context.java:13 72) at
> org.mozilla.javascript.Context.compileString(Context.java:13 61) at
> org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:221) at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
> .. 38 more
>
>
> Table (id = 1520): + Failed to prepare the following query for the data
> set type org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [{call
> rptOpenClose(?,?,?,?,?,?)};]
> Error preparing SQL statement.
> SQL error #1: Callable statments not supported.
>
> odaconsumer.CannotPrepareStatement ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: Failed to
> prepare the following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [{call
> rptOpenClose(?,?,?,?,?,?)};]Error preparing SQL statement.SQL error #1:
> Callable statments not supported. at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:232)
> at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
> at
> org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:187)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:244)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL
> statement.SQL error #1: Callable statments not supported. ;
> java.sql.SQLException: Callable statments not supported. at
> org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:147)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:210)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:167)
> at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
> .. 51 moreCaused by: java.sql.SQLException: Callable statments not
> supported. at com.mysql.jdbc.Connection.prepareCall(Connection.java:1225)
> at
> org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:142)
> .. 54 more
>
>
>
|
|
|
| Re: help...execute the stored procedure in birt??? [message #213921 is a reply to message #213879] |
Thu, 25 January 2007 05:58 |
ice70
Messages: 193
Registered: July 2009 |
Senior Member |
|
|
hi jason...
thank you for pay attention on my problem...
i don't think that cause the error because after i add on the missing ")",
there still exist the error message..
The following items have errors:
ReportDesign (id = 1):
+ There are errors evaluating script "str1 = params["stmt"].value;
importPackage(Packages.my.com.shinyang.ilms.ui.report);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["cateFr"]);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["cateTo"]);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["dateFr"]);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["dateTo"]);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["subCateFr"]);
StoredProcedure = new
my.com.shinyang.ilms.ui.report.callProc1(params["subCateTo"]);
StoredProcedure.executeMethod();".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "str1 =
params["stmt" ].value;importPackage(Packages.my.com.shinyang.ilms.ui.repor t);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["cateFr"]);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["cateTo"]);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["dateFr"]);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["dateTo"]);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["subCateFr"]);StoredProcedure
= new
my.com.shinyang.ilms.ui.report.callProc1(params["subCateTo"]);StoredProcedure.executeMethod(); ".
at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
at
org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJSInternal(ScriptExecutor.java:66)
at
org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJS(ScriptExecutor.java:50)
at
org.eclipse.birt.report.engine.script.internal.ReportScriptE xecutor.handleInitialize(ReportScriptExecutor.java:28)
at
org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesig n(EngineTask.java:860)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:149)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at
org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)Caused by:
org.mozilla.javascript.EcmaError: ReferenceError: "my" is not defined.
(<inline>#4) at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
at
org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRun time.java:3303)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java :1566) at
org.mozilla.javascript.gen.c61._c0(<inline>:4) at
org.mozilla.javascript.gen.c61.call(<inline>) at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at org.mozilla.javascript.gen.c61.call(<inline>) at
org.mozilla.javascript.gen.c61.exec(<inline>) at
org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
... 38 more
Table (id = 1520):
+ Failed to prepare the following query for the data set type
org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
[{call rptOpenClose(?,?,?,?,?,?)};]
Error preparing SQL statement.
SQL error #1: Callable statments not supported.
odaconsumer.CannotPrepareStatement ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: Failed to
prepare the following query for the data set type
org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [{call
rptOpenClose(?,?,?,?,?,?)};]Error preparing SQL statement.SQL error #1:
Callable statments not supported. at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:232)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
at
org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:187)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:244)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at
org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)Caused by:
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL
statement.SQL error #1: Callable statments not supported. ;
java.sql.SQLException: Callable statments not supported. at
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:147)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:210)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:167)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
... 51 moreCaused by: java.sql.SQLException: Callable statments not
supported. at com.mysql.jdbc.Connection.prepareCall(Connection.java:1225)
at
org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:142)
... 54 more
it has the message "Callable statements not supported" is that got any
specific meaning ???
thanks...
|
|
|
| Re: help...execute the stored procedure in birt??? [message #214119 is a reply to message #213921] |
Thu, 25 January 2007 16:31 |
|
The first error has to do with the my.com lines
try new Packages.my.com.... If this does not work, then it is probably not
finding your package.
The second error looks like you are not using the store procedure data set.
Look at the attached picture.
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:64bc90ad36a053e65ee4c94443d9f095$1@www.eclipse.org...
> hi jason...
> thank you for pay attention on my problem...
> i don't think that cause the error because after i add on the missing ")",
> there still exist the error message..
>
> The following items have errors:
>
>
> ReportDesign (id = 1):
> + There are errors evaluating script "str1 = params["stmt"].value;
>
> importPackage(Packages.my.com.shinyang.ilms.ui.report);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["cateFr"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["cateTo"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["dateFr"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["dateTo"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["subCateFr"]);
> StoredProcedure = new
> my.com.shinyang.ilms.ui.report.callProc1(params["subCateTo"]);
> StoredProcedure.executeMethod();".
> Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "str1 =
> params["stmt" ].value;importPackage(Packages.my.com.shinyang.ilms.ui.repor t);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["cateFr"]);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["cateTo"]);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["dateFr"]);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["dateTo"]);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["subCateFr"]);StoredProcedure
> = new
> my.com.shinyang.ilms.ui.report.callProc1(params["subCateTo"]);StoredProcedure.executeMethod(); ".
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
> at
> org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJSInternal(ScriptExecutor.java:66)
> at
> org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJS(ScriptExecutor.java:50)
> at
> org.eclipse.birt.report.engine.script.internal.ReportScriptE xecutor.handleInitialize(ReportScriptExecutor.java:28)
> at
> org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesig n(EngineTask.java:860)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:149)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.mozilla.javascript.EcmaError: ReferenceError: "my" is not defined.
> (<inline>#4) at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
> at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
> at
> org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRun time.java:3303)
> at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java :1566) at
> org.mozilla.javascript.gen.c61._c0(<inline>:4) at
> org.mozilla.javascript.gen.c61.call(<inline>) at
> org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
> at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
> at org.mozilla.javascript.gen.c61.call(<inline>) at
> org.mozilla.javascript.gen.c61.exec(<inline>) at
> org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
> .. 38 more
>
>
> Table (id = 1520):
> + Failed to prepare the following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
> [{call rptOpenClose(?,?,?,?,?,?)};]
> Error preparing SQL statement.
> SQL error #1: Callable statments not supported.
>
> odaconsumer.CannotPrepareStatement ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: Failed to
> prepare the following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [{call
> rptOpenClose(?,?,?,?,?,?)};]Error preparing SQL statement.SQL error #1:
> Callable statments not supported. at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:232)
> at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareS tatement(Connection.java:158)
> at
> org.eclipse.birt.data.engine.executor.DataSource.prepareStat ement(DataSource.java:187)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:244)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL
> statement.SQL error #1: Callable statments not supported. ;
> java.sql.SQLException: Callable statments not supported. at
> org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:147)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doPrepare(OdaQuery.java:210)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.prepare(OdaQuery.java:167)
> at
> org.eclipse.birt.data.engine.odaconsumer.Connection.prepareO daQuery(Connection.java:221)
> .. 51 moreCaused by: java.sql.SQLException: Callable statments not
> supported. at com.mysql.jdbc.Connection.prepareCall(Connection.java:1225)
> at
> org.eclipse.birt.report.data.oda.jdbc.CallStatement.prepare( CallStatement.java:142)
> .. 54 more
>
>
> it has the message "Callable statements not supported" is that got any
> specific meaning ???
>
> thanks...
>
|
|
| |
| Re: help...execute the stored procedure in birt??? [message #214401 is a reply to message #214262] |
Fri, 26 January 2007 17:18 |
|
Can you download the attached zip.
Create a new data set. Set the Data Set Type From SQL Select Query to
SQL Stored Procedure Query.
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:a66dafe7ae8cfe6f102f0132755f00cb$1@www.eclipse.org...
> jason...
>
> it still have the same error message...
> your attached picture cannot open...how can i open it for a look?
>
> i also wonder that i am not using the store procedure data set...is that
> any online reference that can give me the guide for using the store
> procedure data set? i really need some guides...
>
> thanks...
>
>
|
|
| |
| Re: help...execute the stored procedure in birt??? [message #214508 is a reply to message #214485] |
Sat, 27 January 2007 05:18 |
|
This zip file only contains an image of adding a new dataset and setting it
to a stored procedure.
Just create a new data set and set the type to the stored procedure. Then
enter your call as before with multiple ?, ?, ?
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:62a19633f741787818a55087d0e7327a$1@www.eclipse.org...
> jason...
>
> thanks for help...
>
> but the zip file that you attached look like corrupted...or is that
> "specific" way to get it? i don't know how to get the file...
>
> or can you tell give me the address to download..that is easy...
>
|
|
|
| Re: help...execute the stored procedure in birt??? [message #214654 is a reply to message #214508] |
Mon, 29 January 2007 00:11 |
ice70
Messages: 193
Registered: July 2009 |
Senior Member |
|
|
jason,
i add a new data set, and named it "stored_procedure". Then select the
"sql stored procedure query" data set type.
then i write {call stored_procedure(?,?,?)} when edit the data set.
but when i go to the preview result, there pop up an error message as
below:
A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.1.1.v20060922-1058
Error Code:odaconsumer.CannotPrepareStatement
Error Message:Failed to prepare the following query for the data set
type org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet.
[{call stored_procedure(?,?,?)} ]
Error preparing SQL statement.
SQL error #1: Callable statments not supported.
what is that means??
beside, if i just click "ok" after the {call stored_procedure(?,?,?)},
there is not exist any data from data set stored_procedure for me to drag
and drop into the report's table...
thanks for help.....
|
|
|
| Re: help...execute the stored procedure in birt??? [message #214908 is a reply to message #214654] |
Mon, 29 January 2007 20:16 |
|
See my reply to your later post.
Jason
"70" <klhuang@shinyang.com.my> wrote in message
news:1bd9987e634a172be681a8e4a52997ea$1@www.eclipse.org...
> jason,
> i add a new data set, and named it "stored_procedure". Then select the
> "sql stored procedure query" data set type.
>
> then i write {call stored_procedure(?,?,?)} when edit the data set.
> but when i go to the preview result, there pop up an error message as
> below:
>
> A BIRT exception occurred.
> Plug-in Provider:Eclipse.org
> Plug-in Name:BIRT Data Engine
> Plug-in ID:org.eclipse.birt.data
> Version:2.1.1.v20060922-1058
> Error Code:odaconsumer.CannotPrepareStatement
> Error Message:Failed to prepare the following query for the data set type
> org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [{call
> stored_procedure(?,?,?)} ]
> Error preparing SQL statement.
> SQL error #1: Callable statments not supported.
>
>
> what is that means??
>
> beside, if i just click "ok" after the {call stored_procedure(?,?,?)},
> there is not exist any data from data set stored_procedure for me to drag
> and drop into the report's table...
>
> thanks for help.....
>
|
|
|
| Re: help...execute the stored procedure in birt??? [message #217509 is a reply to message #211020] |
Wed, 07 February 2007 18:13 |
Eclipse User |
|
|
|
Originally posted by: jarif.despammed.com
70 wrote:
> jason...
>
> i try the way you teach me, how to pass the parameter to the stored
> procedure...
> but i got the error message as below:
>
> The following items have errors:
>
> Table (id = 7): + Failed to prepare the following query for the data set
> type org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [{call
> procedure testInAndOut(?,?,?,?,?,?,?)} ]
> Error preparing SQL statement.
> SQL error #1: Callable statments not supported.
>
> is that my used birt version cannot support something??
> i am using birt 2.1.1 with mySQL5.0
>
WRONG: {call procedure testInAndOut(?,?,?,?,?,?,?)}
RIGHT: {call testInAndOut(?,?,?,?,?,?,?)}
|
|
|
| Re: help...execute the stored procedure in birt??? [message #217513 is a reply to message #212301] |
Wed, 07 February 2007 18:20 |
| Eclipse User |
|
|
|
Originally posted by: jarif.despammed.com
70 wrote:
> jason...i keep on trying to pass the parameter into the stored procedure...
> and below are the error messages i get:
>
> The following items have errors:
>
> Table (id = 1520): + Failed to prepare the following query for the data
> set type org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet. [Select
> * from tmprptdetailtrxthistory and
> tmprptdetailtrxthistory.category='bell' ]
> Error preparing SQL statement.
Your SQL statement lacks WHERE, it has "and" where it should have "where"
CORRECT:
Select * from tmprptdetailtrxthistory where
tmprptdetailtrxthistory.category='bell'
|
|
|
Goto Forum:
Current Time: Sun Nov 03 06:46:36 GMT 2024
Powered by FUDForum. Page generated in 0.08373 seconds |
] 
Search
Help
Register
Login
Home
