RE: [birt-dev] How to create a datasource

["Yu Li" <yli@xxxxxxxxxxx>]

Hi Andres,

It seems like an environment problem. Can you check whether the org.eclipse.birt.report.data.oda.jdbc is in your eclipse plugin directory?

If yes, you need to give the argument when you run your code:
-DBIRT_HOME="your eclipse home".

Or you can specify your own BIRT_HOME directory. But the following plugins and jar should exist in your BIRT_HOME/plugin:
org.eclipse.birt.core
org.eclipse.birt.data
org.eclipse.birt.data.oda
org.eclipse.birt.report.data.oda.jdbc

Any problem please let me know.

Thanks!


 
Ivy 
 
Actuate Software ShangHai center.
498 Guoshoujing Rd.Bld 3.Suite 3301. shanghai,201203
Tel: (86)21-50270900 ext:257
Fax:(86)21-50270901
Email: yli@xxxxxxxxxxx
 

-----Original Message-----
From: birt-dev-bounces@xxxxxxxxxxx [mailto:birt-dev-bounces@xxxxxxxxxxx] On Behalf Of Andres Felipe Gomez Mondragon
Sent: Monday, July 11, 2005 12:08 PM
To: birt-dev@xxxxxxxxxxx
Subject: RE: [birt-dev] How to create a datasource

Hi Yu Li,
Yes, I did that but i dont know why the extension is not found.
I dont know if i need to configure something. I use the runtime libraries.
You can help me ?

I have this class,

SessionHandle session = DesignEngine.newSession(null);
ReportDesignHandle design = session.createDesign();
ElementFactory factory = design.getElementFactory();
OdaDataSourceHandle dataSource = 
factory.newOdaDataSource("dataSource","org.eclipse.birt.report.data.oda.jdbc");

dataSource .setBeforeOpen("extensionProperties.odaUser = \"\";" +
"extensionProperties.odaPassword = \"\";" +
"extensionProperties.odaURL = \"jdbc:mysql://Andres1:3306/hermes1\";" +
"extensionProperties.odaDriverClass = \"com.mysql.jdbc.Driver\";");

OdaDataSetHandle dataSetHandle = factory.newOdaDataSet("Conexiones");
dataSetHandle.setProperty(OdaDataSetHandle.QUERY_TEXT_PROP,
				"select code, desc from departament");

....

I run this class when i an exception is throwed.

java.lang.IllegalArgumentException: org.eclipse.birt.report.data.oda.jdbc
	at 
org.eclipse.birt.data.oda.util.manifest.ManifestExplorer.getExtensionManifest(ManifestExplorer.java:141)
	at 
org.eclipse.birt.report.model.extension.oda.ODAManifestUtil.getDataSourceExtension(ODAManifestUtil.java:33)
	at 
org.eclipse.birt.report.model.api.ElementFactory.newOdaDataSource(ElementFactory.java:731)
	at org.eclipse.org.demo.de.DeDemo.buildReport(DeDemo.java:74)
	at org.eclipse.org.demo.de.DeDemo.main(DeDemo.java:46)


Or sometimes when i pass only one parameter in the datasource, the 
extensionID is not generated.

What can i do, Can you give me an example where you can generate a report 
using jdbc?

Please.

Thanks for your help.

>From: "Yu Li" <yli@xxxxxxxxxxx>
>Reply-To: For developers on the BIRT project <birt-dev@xxxxxxxxxxx>
>To: "For developers on the BIRT project" <birt-dev@xxxxxxxxxxx>
>Subject: RE: [birt-dev] How to create a datasource
>Date: Sun, 10 Jul 2005 19:14:58 -0700
>
>
>Hi,
>
>You need to create an oda-data-source. We have jdbc data source oda 
>extension plugin that you can use.
>
>ElementFactory :: newOdaDataSource("youDataSourceName", 
>"org.eclipse.birt.report.data.oda.jdbc");
>
>Then you will get the OdaSourceHandle and set the properties.
>
>Thanks!
>
>Ivy
>
>Actuate Software ShangHai center.
>498 Guoshoujing Rd.Bld 3.Suite 3301. shanghai,201203
>Tel: (86)21-50270900 ext:257
>Fax:(86)21-50270901
>Email: yli@xxxxxxxxxxx
>
>
>-----Original Message-----
>From: birt-dev-bounces@xxxxxxxxxxx [mailto:birt-dev-bounces@xxxxxxxxxxx] On 
>Behalf Of Andres Felipe Gomez Mondragon
>Sent: Sunday, July 10, 2005 3:23 AM
>To: birt-dev@xxxxxxxxxxx
>Subject: [birt-dev] How to create a datasource
>
>Hello, I need your help.
>I need to create a datasource using java code but i dont know how to write
>the datasource with the properties like driverclass, url,  user, password
>and the metadata with a query like "select code, description from 
>conexion".
>After the results i´ll show in a table.
>
>Thanks.
>
>_________________________________________________________________
>On the road to retirement? Check out MSN Life Events for advice on how to
>get there! http://lifeevents.msn.com/category.aspx?cid=Retirement
>
>_______________________________________________
>birt-dev mailing list
>birt-dev@xxxxxxxxxxx
>https://dev.eclipse.org/mailman/listinfo/birt-dev
>_______________________________________________
>birt-dev mailing list
>birt-dev@xxxxxxxxxxx
>https://dev.eclipse.org/mailman/listinfo/birt-dev

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

_______________________________________________
birt-dev mailing list
birt-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/birt-dev