Eclipse Community Forums: BIRT » BIRT 4.2 Default Value for Dataset Input parameter is not working

Home » Archived » BIRT » BIRT 4.2 Default Value for Dataset Input parameter is not working

BIRT 4.2 Default Value for Dataset Input parameter is not working [message #896081]

Tue, 17 July 2012 04:21

Eclipse User

Im using the latest version of the BIRT All in one 4.2. The below query for the data set works fine with the value for SITE_CODE as '230'.

select SITE_CODE, TRANSACTION_ID, SERIAL_NUMBER from status_header
where STATUS = '120'
and COMPLETE_DATE = '20120716'
and SITE_CODE = '230'

However when the query is modified as below to receive the SITE_CODE as Input by adding he Dataset Input parameter of String type with the same Default Value as 230, the Preview Results of the data set is not showing any results

select SITE_CODE, TRANSACTION_ID, SERIAL_NUMBER from status_header
where STATUS = '120'
and COMPLETE_DATE = '20120716'
and SITE_CODE = '?'

I'm not linking the parameter to any Report Parameter as the basic feature of default value is not working.

Please let me know the issue. Im not able to use Dynamic queries linking the Data Set parameters with Report Parameters as Default value for Data set parameter itself is not working.

Appreciate your help.

Attachment: DataSet_Parameter.JPG
(Size: 24.13KB, Downloaded 440 times)

Re: BIRT 4.2 Default Value for Dataset Input parameter is not working [message #896234 is a reply to message #896081]

Tue, 17 July 2012 12:28

Eclipse User

Try changing this:
and SITE_CODE = '?'
to
and SITE_CODE = ?

Jason

On 7/17/2012 4:21 AM, Rama Krishna wrote:
> Im using the latest version of the BIRT All in one 4.2. The below query for the data set works fine with the value for SITE_CODE as '230'.
>
> select SITE_CODE, TRANSACTION_ID, SERIAL_NUMBER from status_header
> where STATUS = '120'
> and COMPLETE_DATE = '20120716'
> and SITE_CODE = '230'
>
> However when the query is modified as below to receive the SITE_CODE as Input by adding he Dataset Input parameter of String type with the same Default Value as 230, the Preview Results of the data set is not showing any results
>
> select SITE_CODE, TRANSACTION_ID, SERIAL_NUMBER from status_header
> where STATUS = '120'
> and COMPLETE_DATE = '20120716'
> and SITE_CODE = '?'
>
> I'm not linking the parameter to any Report Parameter as the basic feature of default value is not working.
>
> Please let me know the issue. Im not able to use Dynamic queries linking the Data Set parameters with Report Parameters as Default value for Data set parameter itself is not working.
>
> Appreciate your help.
>

Re: BIRT 4.2 Default Value for Dataset Input parameter is not working [message #896240 is a reply to message #896234]

Tue, 17 July 2012 12:55

Eclipse User

I changed '?' to ? removing the quotes in the query but now it gives sql error (Cannot get parameter type, Unsupported feature) :

org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Outbound Site Data Set
Cannot get the type for parameter: 1.
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.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)

Please find the detailed error message attached.

Are String types for dynamic parameters not supported by BIRT?

Attachment: BIRT_Error.txt
(Size: 5.05KB, Downloaded 478 times)

Re: BIRT 4.2 Default Value for Dataset Input parameter is not working [message #896245 is a reply to message #896240]

Tue, 17 July 2012 13:03

Eclipse User

Yes they are supported. What data source are you using?

Jason

On 7/17/2012 12:55 PM, Rama Krishna wrote:
> I changed '?' to ? removing the quotes in the query but now it gives sql error (Cannot get parameter type, Unsupported feature) :
>
> org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
> Failed to prepare the query execution for the data set: Outbound Site Data Set
> Cannot get the type for parameter: 1.
> 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.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
>
> Please find the detailed error message attached.
>
> Are String types for dynamic parameters not supported by BIRT?
>

Re: BIRT 4.2 Default Value for Dataset Input parameter is not working [message #896255 is a reply to message #896245]

Tue, 17 July 2012 14:06

Eclipse User

I tried with both Oracle 10g & Oracle 11g and nothing worked.
And the issue is not specific to datatype as it is not working with Integer type either.

Looks like the latest version of BIRT is not supporting dynamic parameters this way for Oracle datasources as per the below topic:
http://www.eclipse.org/forums/index.php/mv/msg/367290/894990/

Shall I switch to previous version - 3.7.2?

Re: BIRT 4.2 Default Value for Dataset Input parameter is not working [message #896273 is a reply to message #896255]

Tue, 17 July 2012 16:02

Eclipse User

You can use a script work around, but I would give a day or two to see
if the bug:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=384925
gets updated.

Jason

On 7/17/2012 2:06 PM, Rama Krishna wrote:
> I tried with both Oracle 10g & Oracle 11g and nothing worked. And the
> issue is not specific to datatype as it is not working with Integer type
> either.
> Looks like the latest version of BIRT is not supporting dynamic
> parameters this way for Oracle datasources as per the below topic:
> http://www.eclipse.org/forums/index.php/mv/msg/367290/894990/
>
> Shall I switch to previous version - 3.7.2?

Re: BIRT 4.2 Default Value for Dataset Input parameter is not working [message #896291 is a reply to message #896255]

Tue, 17 July 2012 17:56

Eclipse User

I tried with BIRT 3.7.2 and it works fine now.

Previous Topic:	Editable Chart in BIRT doc file
Next Topic:	BIRT temporary files cleanup

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 06 07:29:24 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter