RE: [birt-dev] Birt report preview error

["Jane Tatchell" <jtatchell@xxxxxxxxxxx>]

Please post "How To" questions on the BIRT Newsgroup. The newsgroup has
a large number of contributors who have used BIRT to perform many
different tasks. This mailing list is reserved for notifications to BIRT
users about BIRT milestone and stable builds and other noteworthy
information. You can access the newsgroup by following the instructions
on this page: http://www.eclipse.org/newsgroups/ 

Regards,
Jane Tatchell 

-----Original Message-----
From: birt-dev-bounces@xxxxxxxxxxx [mailto:birt-dev-bounces@xxxxxxxxxxx]
On Behalf Of Bill Batt
Sent: Wednesday, December 14, 2005 5:34 PM
To: birt-report-designer-dev@xxxxxxxxxxx; birt-dev@xxxxxxxxxxx
Subject: [birt-dev] Birt report preview error

Hi

I am trying to create a simple list report based on an SQL query.

I have created the data source and Data Set successfully. 
I can preview the results of the SQL query OK.

However when I drag one of the data set fields onto the report I get the
following error

There are errors on the report page: 
- There are error(s) in Table:table1
Error0 : odaconsumer.CannotOpenConnection(1 time)detail: Cannot open the
connection for the driver (org.eclipse.birt.report.data.oda.jdbc).Cannot
load JDBC Driver class: [org.gjt.mm.mysql.Driver]. Cannot load JDBC
Driver class: [org.gjt.mm.mysql.Driver]. 


I have attached the config and plugin details. The build info is
included in the plugin doc. 
I believe it is 1.0.1 although confusingly it also say 1.0.0.


The JAR file oda-jdbc.jar exists in both of the following directories
 
C:\Program
Files\Birt\birt-rcp-report-designer-1_0_1\plugins\org.eclipse.birt.repor
t.viewer_1.0.1\birt\plugins\org.eclipse.birt.report.data.oda.jdbc

C:\Program
Files\Birt\birt-rcp-report-designer-1_0_1\plugins\org.eclipse.birt.repor
t.data.oda.jdbc_1.0.1

The following diectories and the JAR files exist
C:\Program
Files\Birt\birt-rcp-report-designer-1_0_1\plugins\org.eclipse.birt.core_
1.0.1 - core.jar
C:\Program
Files\Birt\birt-rcp-report-designer-1_0_1\plugins\org.eclipse.birt.data_
1.0.1 - dte.jar
C:\Program
Files\Birt\birt-rcp-report-designer-1_0_1\plugins\org.eclipse.birt.data.
oda_2.0.1 - oda.jar
C:\Program
Files\Birt\birt-rcp-report-designer-1_0_1\plugins\org.eclipse.birt.repor
t.data.oda.jdbc_1.0.1 - oda-jdbc.jar

Any help would be appreciated.

Regards

Bill Batt

Analyst Programmer
BTG
ING Australia Limited
347 Kent St, Sydney NSW 2000

Ph:      02-9234-8978
Fax:     02-9234-8732
eMail:  Bill.Batt@xxxxxxxxxx

  



IMPORTANT NOTICE
This communication including any file attachments is intended solely for
the use of the individual or entity to whom it is addressed. If you are
not the intended recipient, or the person responsible for delivering
this communication to the intended recipient, please immediately notify
the sender by e-mail and delete the original transmission and its
contents. Any unauthorised use, dissemination, forwarding, printing, or
copying of this communication including any file attachments is
prohibited.

It is your responsibility to scan this communication including any file
attachment for viruses and other defects. To the extent permitted by
law, ING and its associates will not be liable for any loss or damage
arising in any way from this communication including file attachments.