ODA Datasource?

[Mylsamy Shanmugam]

Hi all,

I am using birt report with glassfish server,

I am trying to integrate the report design file with servlet code and deploy it and run the code means it shows an error : Cannot load JDBC Driver class: com.mysql.jdbc.Driver. I added all jar files for jdbc but still i struck with this error.

And my MySql code in servlet is

OdaDataSourceHandle dsHandle = designFactory.newOdaDataSource(
"dbcrs", "org.eclipse.birt.report.data.oda.jdbc" );

dsHandle.setProperty( "odaDriverClass","com.mysql.jdbc.Driver" );
dsHandle.setProperty( "odaURL", "jdbc:mysql://localhost:3306/dbcrs02" );
dsHandle.setProperty( "odaUser", "root" );
report.getDataSources().add(dsHandle);


Can anyone help this?

Thanks in Advance ,

Myl

Thanx in Advance

Myl