Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
RE: [birt-dev] How to create a datasource

Hi Andres,

It seems like an environment problem. Can you check whether the 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:

Any problem please let me know.


Actuate Software ShangHai center.
498 Guoshoujing Rd.Bld 3.Suite 3301. shanghai,201203
Tel: (86)21-50270900 ext:257
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 = 

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

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


I run this class when i an exception is throwed.


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?


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
>You need to create an oda-data-source. We have jdbc data source oda 
>extension plugin that you can use.
>ElementFactory :: newOdaDataSource("youDataSourceName", 
>Then you will get the OdaSourceHandle and set the properties.
>Actuate Software ShangHai center.
>498 Guoshoujing Rd.Bld 3.Suite 3301. shanghai,201203
>Tel: (86)21-50270900 ext:257
>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 
>After the results i´ll show in a table.
>On the road to retirement? Check out MSN Life Events for advice on how to
>get there!
>birt-dev mailing list
>birt-dev mailing list

Express yourself instantly with MSN Messenger! Download today - it's FREE!

birt-dev mailing list

Back to the top