Null Report Parameter Passed to Data Set [message #256497] |
Fri, 28 September 2007 07:22 |
Eclipse User |
|
|
|
Originally posted by: aituoklis.gmail.com
Hi,
I found example (Bugzilla ID 182197) which illustrates handling a null
report parameter before using it in a data set parameter.
As I understood this workaround is used, because data set parameter can't
be null.
But sometimes you want to write something like this:
select *
from orderdetails
where (? is NULL OR CLASSICMODELS.ORDERDETAILS.ORDERNUMBER =? )
So we having the same result as in example, but
without using Birt scripting posibilities.
And it's working! So were is the problem? Problem is that J2EE server
(in my case JBoss 4.2.0GA) throwing errors like this:
org.eclipse.birt.data.engine.odaconsumer.ParameterMetaData
getRuntimeParameterType
SEVERE: Cannot get parameter type.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get parameter
type.
SQL error #1: Unsupported feature
;
java.sql.SQLException: Unsupported feature
at
org.eclipse.birt.report.data.oda.jdbc.ParameterMetaData.getP arameterT
ype(ParameterMetaData.java:159)
So report is showing correct results, but J2EE server is throwing errors,
it's not critical, but not nice.
So my question is: is it planned to support null data set parameters in
BIRT? And if yes, so in which version?
Thank you in advance for answers.
Aivaras
|
|
|
|
Powered by
FUDForum. Page generated in 0.03756 seconds