Eclipse Community Forums: BIRT » SQL stored procedure query

Home » Archived » BIRT » SQL stored procedure query

SQL stored procedure query [message #209962]

Tue, 09 January 2007 00:42

Eclipse User

Can anyone tell me how to create the birt report by using the SQL stored
procedure Query of the data set??

as i found, i only found the "help-eclipse SDK"
( http://help.eclipse.org/help31/index.jsp?topic=/org.eclipse. birt.doc/birt/birt-04-05.html)
which just shown the way to specify a stored procedure JDBC data set...

is that any further study references on using the "SQL stored procedure
query" ??

thanks...

Re: SQL stored procedure query [message #210010 is a reply to message #209962]

Tue, 09 January 2007 03:56

Eclipse User

...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 #210184 is a reply to message #210010]

Wed, 10 January 2007 01:13

Eclipse User

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 #210504 is a reply to message #210184]

Wed, 10 January 2007 19:12

Eclipse User

thanks jason...

but is that any different of using the data set type "SQL select query"
and "SQL stored procedure query"?

i try to create a simple stored procedure, and in the stored procedure, i
create a temporary table and then i insert some data into the temporary
table.. without using the "SQL stored procedure query", i also can get the
data from the temporary table, so, what the different of the two data set
type??

thanks for reply..

Re: SQL stored procedure query [message #210523 is a reply to message #210184]

Wed, 10 January 2007 19:35

Eclipse User

...and jason...

you said that the arg1... is the in or out parameter...is that mean it
cannot support the inout parameter??

i am using the birt 2.1 with mysql5.0.. thanks

Re: SQL stored procedure query [message #210545 is a reply to message #210184]

Wed, 10 January 2007 20:06

Eclipse User

jason...

i wish to call my stored procedure, and i am using the "SQL stored
procedure query" data set type...

i call the stored procedure as below:

{call `testingPassParameter`(INOUT category VARCHAR(100), INOUT recDate
DATE)}

but it did not pass any data for me...and i could not drag and drop any
data into my table...

is that my way to call the procedure is wrong???

Re: SQL stored procedure query [message #210565 is a reply to message #210523]

Wed, 10 January 2007 22:37

Eclipse User

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: SQL stored procedure query [message #210801 is a reply to message #210565]

Thu, 11 January 2007 12:38

Eclipse User

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: SQL stored procedure query [message #210992 is a reply to message #210801]

Thu, 11 January 2007 20:22

Eclipse User

hai...jason...as you mention, i try to call the stored procedure and also
pass the parameter. i can get the parameter that i passing but the stored
procedure that i wrote seems not been execute....

Then i get the error 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 tmppassinandout(?,?,?,?,?,?,?)} ]
Error preparing SQL statement.
SQL error #1: Callable statments not supported.

what that means callable statments not supported???

and also...i found that i only can drag and drop the parameter that i
create into the table...how if i wish to get the data from the tempory
table i create in the stored procedure?

thanks...

help...execute the stored procedure in birt??? [message #211020 is a reply to message #210545]

Thu, 11 January 2007 22:46

Eclipse User

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

Re: help...execute the stored procedure in birt??? [message #211070 is a reply to message #211020]

Fri, 12 January 2007 00:09

Eclipse User

Originally posted by: JasonWeathersby.alltel.net

I am on the road at the moment, but I will try a procedure similar to yours
if you can post the SQL to create it.

Jason

Re: help...execute the stored procedure in birt??? [message #211093 is a reply to message #211070]

Fri, 12 January 2007 01:15

Eclipse User

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 #211468 is a reply to message #211093]

Sun, 14 January 2007 20:03

Eclipse User

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 #211845 is a reply to message #211468]

Tue, 16 January 2007 12:53

Eclipse User

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 #211929 is a reply to message #211845]

Tue, 16 January 2007 19:16

Eclipse User

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 #211949 is a reply to message #211929]

Wed, 17 January 2007 01:36

Eclipse User

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 #212263 is a reply to message #211949]

Wed, 17 January 2007 19:32

Eclipse User

jason,

i try as what you mention
and i get the error message as below:

The following items have errors:

ReportDesign (id = 1):
+ There are errors evaluating script "importPackage(
Packages.my.javapackage );
myjavaclass = new my.javapackage.StoredProcCreator( params["CateFr"] );
myjavaclass = new my.javapackage.StoredProcCreator( params["CateTo"] );
myjavaclass = new my.javapackage.StoredProcCreator( params["SubCateFr"] );
myjavaclass = new my.javapackage.StoredProcCreator( params["SubCateTo"] );
myjavaclass = new my.javapackage.StoredProcCreator( params["DateFr"] );
myjavaclass = new my.javapackage.StoredProcCreator( params["DateTo"] );
myjavaclass.executeMethod();".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "importPackage( Packages.my.javapackage
);myjavaclass = new my.javapackage.StoredProcCreator( params["CateFr"]
);myjavaclass = new my.javapackage.StoredProcCreator( params["CateTo"]
);myjavaclass = new my.javapackage.StoredProcCreator( params["SubCateFr"]
);myjavaclass = new my.javapackage.StoredProcCreator( params["SubCateTo"]
);myjavaclass = new my.javapackage.StoredProcCreator( params["DateFr"]
);myjavaclass = new my.javapackage.StoredProcCreator( params["DateTo"]
);myjavaclass.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>#2) 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.c62._c0(<inline>:2) at
org.mozilla.javascript.gen.c62.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.c62.call(<inline>) at
org.mozilla.javascript.gen.c62.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

what have i miss up???

Re: help...execute the stored procedure in birt??? [message #212278 is a reply to message #212263]

Thu, 18 January 2007 01:20

Eclipse User

hai jason...

i keep on trying what you teach...
still get the error message...some are as below:

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

and

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

and so on...
it seen that the way that i pass the parameter occurs some problems.. is
that right??

however, no matter how i try to pass the parameter into the stored
procedure, there are not exist the data set for me to drag and drop into
the table when i am using the "sql stored procedure query" data set type...

then, how can i get the data set for me to drag and drop into the table
for a listing report???

thanks...

Re: help...execute the stored procedure in birt??? [message #212301 is a reply to message #212278]

Thu, 18 January 2007 02:35

Eclipse User

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.
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 tmprptdetailtrxthistory.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 #212393 is a reply to message #212301]

Thu, 18 January 2007 11:41

Eclipse User

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 #212597 is a reply to message #212393]

Thu, 18 January 2007 19:23

Eclipse User

ya...jason...below is the 2 report that i try...

1st report
***********

<?xml version="1.0" encoding="UTF-8"?>

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

strTitle = params["titles"].value;
arrTitle1=strTitle.split(",");]]></method>
<method name="beforeFactory"><![CDATA[//importPackage(
Packages.my.javapackage );
//myjavaclass = new my.javapackage.StoredProcCreator( params["cateFr"] );
//myjavaclass = new my.javapackage.StoredProcCreator( params["cateTo"] );
//myjavaclass = new my.javapackage.StoredProcCreator( params["dateFr"] );
//myjavaclass = new my.javapackage.StoredProcCreator( params["cateTo"] );
//myjavaclass = new my.javapackage.StoredProcCreator( params["subCateFr"]
);
//myjavaclass = new my.javapackage.StoredProcCreator( params["subCateTo"]
);
//myjavaclass.executeMethod();]]></method>
<parameters>
<scalar-parameter name="stmt" id="1788">
<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="titles" id="1789">
<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="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"];

importPackage( Packages.my.javapackage );

myjavaclass = new my.javapackage.StoredProcCreator( params["dateFr"] );
myjavaclass = new my.javapackage.StoredProcCreator( params["dateTo"] );
myjavaclass = new my.javapackage.StoredProcCreator( params["cateFr"] );
myjavaclass = new my.javapackage.StoredProcCreator( params["cateTo"] );
myjavaclass = new my.javapackage.StoredProcCreator( params["subCateFr"] );
myjavaclass = new my.javapackage.StoredProcCreator( params["subCateTo"] );

myjavaclass.executeMethod();]]></method>
<list-property name="parameters">
<structure>
<property name="name">cateFr</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">cateTo</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">subCateFr</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">subCateTo</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">dateFr</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">dateTo</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="352">
<property name="fontSize">smaller</property>
<property name="width">100%</property>
<column id="353">
<property name="width">1.2916666667in</property>
</column>
<column id="354">
<property name="width">5.8333333333in</property>
</column>
<column id="355">
<property name="width">1.3645833333in</property>
</column>
<row id="356">
<cell id="357">
<data id="368">
<property name="fontSize">smaller</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">title1</property>
<expression
name="expression">arrTitle1[0]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">title1</property>
</data>
<data id="393">
<property name="fontSize">smaller</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">title2</property>
<expression
name="expression">arrTitle1[1]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">title2</property>
</data>
<data id="394">
<property name="fontSize">smaller</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">title3</property>
<expression
name="expression">arrTitle1[2]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">title3</property>
</data>
<data id="413">
<property name="fontSize">smaller</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">title4</property>
<expression
name="expression">arrTitle1[3]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">title4</property>
</data>
<data id="478">
<property name="fontSize">smaller</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">title5</property>
<expression
name="expression">arrTitle1[4]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">title5</property>
</data>
</cell>
<cell id="358">
<text id="297">
<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="359">
<text id="299">
<property name="fontSize">smaller</property>
<property name="textAlign">right</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>
<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"/>

Re: help...execute the stored procedure in birt??? [message #212606 is a reply to message #212597]

Thu, 18 January 2007 20:04

Eclipse User

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(
"jdbc:mysql://127.0.0.1/ILMS","ilms","123" );
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 #212613 is a reply to message #212597]

Thu, 18 January 2007 20:08

Eclipse User

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 #212810 is a reply to message #212613]

Fri, 19 January 2007 11:05

Eclipse User

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 #212932 is a reply to message #212810]

Sun, 21 January 2007 19:22

Eclipse User

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 #213073 is a reply to message #212932]

Mon, 22 January 2007 12:30

Eclipse User

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 #213186 is a reply to message #213073]

Tue, 23 January 2007 00:41

Eclipse User

hi, jason...this is my report...

<?xml version="1.0" encoding="UTF-8"?>

<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 #213367 is a reply to message #213186]

Tue, 23 January 2007 13:08

Eclipse User

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"?>
> 
> <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 #213510 is a reply to message #213367]

Tue, 23 January 2007 19:16

Eclipse User

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 #213734 is a reply to message #213510]

Wed, 24 January 2007 12:05

Eclipse User

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]

Wed, 24 January 2007 19:09

Eclipse User

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]

Wed, 24 January 2007 21:33

Eclipse User

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 00:58

Eclipse User

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 11:31

Eclipse User

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

Attachment: storedproc.PNG
(Size: 18.67KB, Downloaded 255 times)

Re: help...execute the stored procedure in birt??? [message #214262 is a reply to message #214119]

Thu, 25 January 2007 19:14

Eclipse User

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 #214401 is a reply to message #214262]

Fri, 26 January 2007 12:18

Eclipse User

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

Attachment: storedproc.zip
(Size: 17.21KB, Downloaded 314 times)

Re: help...execute the stored procedure in birt??? [message #214485 is a reply to message #214401]

Fri, 26 January 2007 19:04

Eclipse User

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 #214508 is a reply to message #214485]

Sat, 27 January 2007 00:18

Eclipse User

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]

Sun, 28 January 2007 19:11

Eclipse User

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 15:16

Eclipse User

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 13: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 13: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'

Previous Topic:	Text not justified in PDF(AGAIN!)
Next Topic:	Access to Beans

Goto Forum:

-=] Back to Top [=-

Current Time: Fri May 02 08:47:34 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter