Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » Data sources (How to change connection to DB)

Show: Today's Messages :: Show Polls :: Message Navigator

Data sources [message #523962]

Tue, 30 March 2010 04:45

moloco

Messages: 7
Registered: March 2010

Junior Member

Sorry for may bad En Embarrassed

Situation :

We have several DB servers (mirrors) and one tomcat
instance with BIRT. How we can select datasource in BIRT
on the fly?
What the best point in BIRT engine to insert code for this?

Report message to a moderator

Re: Data sources [message #524414 is a reply to message #523962]

Wed, 31 March 2010 20:24

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

You should be able to use script or property binding for this.
In the beforeOpen you could do this:

this.setExtensionProperty("odaURL","jdbc:mysql://localhost/mysql");
if you pass in the db url as a parameter
this.setExtensionProperty("odaURL",params["mydburlparameter "].value);
You can also set the value the value in property binding in the
datasource editor to params["mydburlparameter"].value;

Jason

moloco wrote:
> Sorry for may bad En :blush:
> Situation :
>
> We have several DB servers (mirrors) and one tomcat
> instance with BIRT. How we can select datasource in BIRT
> on the fly? What the best point in BIRT engine to insert code for this?
>
>

Report message to a moderator

Previous Topic:	BIRT Scripted Data Source Question
Next Topic:	platform startup and shutdown

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 24 20:19:23 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter