Unable execute query

tcskurra

Hi,<br />
<br />
I am trying to generate a report with the data in DB2 9.0. I am able to define the data source and also able to connect succesfully. But when i am defining a dataset with a query,the query is showing the output columns but its not showing the output.<br />
<br />
i am getting the following error<br />
<br />
<strong class='bbc'>A BIRT exception occurred.<br />
Plug-in Provider:Eclipse.org<br />
Plug-in Name:BIRT Data Engine<br />
Plug-in ID:org.eclipse.birt.data<br />
Version:2.1.2.v20070205-1728<br />
Error Code:odaconsumer.CannotGetMaxStatements<br />
Error Message:Cannot get the maximum number of queries for the data source.<br />
odajdbc.CannotGetMaxQuerie<br />
SQL error #1: DatabaseMetaData information is not known for server DB2/NTSQL09015 by this version of JDBC driver</strong><br />
<br />
I have also tried with the lates version of DB2 drivers but still the same issue.<br />
Any suggestions..<br />
<br />
Thanks in advance.<br />
<br />
Regards<br />
Praveen

mwilliams

Hi Praveen,<br />
<br />
The following posts in the devShare linking to the IBM tutorial on this subject should help you with setting up BIRT with DB2 correctly and with creating basic and complex reports:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/45-birt-with-db2-dwe-part-i-setup/'>BIRT with DB2 DWE Part I - Setup - Tutorials - BIRT Exchange</a><br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/252-birt-with-db2-dwe-part-2-basic-report-and-charts/'>BIRT with DB2 DWE Part 2 - Basic Report and Charts - Tutorials - BIRT Exchange</a><br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/253-birt-with-db2-dwe-part-3-complex-reports/'>BIRT with DB2 DWE Part 3 - Complex Reports - Tutorials - BIRT Exchange</a><br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/328-birt-with-db2-dwe-part-4-interactivity-in-reports-and-charts/'>BIRT with DB2 DWE Part 4 - Interactivity in reports and charts - Tutorials - BIRT Exchange</a><br />
<br />
Hope this helps.