Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Data source URL(When data base server changes how should data source change)
Data source URL [message #636838] Wed, 03 November 2010 04:26 Go to next message
Neo is currently offline Neo
Messages: 12
Registered: November 2010
Junior Member
Hi,
I have one basic question on the deployment of reports to the server.
In a normal scenario the developers work on a development server. Now once the release is closed it has to be migrated. Coming to the reports, all reports use the data source and in this we will give the URL. For development the data base is located as "localhost". But once in production the data base server changes. If this is the case the report where we used the URL using localhost will fail. How would we overcome these kind of problems.

Thanks in advance,
Sham.


--------------------------
Neo
Re: Data source URL [message #636996 is a reply to message #636838] Wed, 03 November 2010 16:55 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

There are a lot of ways to overcome this. a)You can use a connection
profile, b)property binding to change the db url, c)or script to change
the db url.

Take a look at this example that modifies a query using property binding
or script.
http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1 /querymod/index.php

Although you are changing dburl the process will be similar.

Jason

On 11/3/2010 12:28 AM, Neo wrote:
> Hi,
> I have one basic question on the deployment of reports to the server.
> In a normal scenario the developers work on a development server. Now
> once the release is closed it has to be migrated. Coming to the reports,
> all reports use the data source and in this we will give the URL. For
> development the data base is located as "localhost". But once in
> production the data base server changes. If this is the case the report
> where we used the URL using localhost will fail. How would we overcome
> these kind of problems.
>
> Thanks in advance,
> Sham.
Previous Topic:IllegalAccessError when using JNDI Url on Birt 2.5.1
Next Topic:ViewerException in IE
Goto Forum:
  


Current Time: Tue Sep 23 06:40:59 GMT 2014

Powered by FUDForum. Page generated in 0.02173 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software