Eclipse Community Forums: BIRT » Library Data Source Is Hardcoded Into Reports

Help

Home

Home » Archived » BIRT » Library Data Source Is Hardcoded Into Reports

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

Library Data Source Is Hardcoded Into Reports [message #1232739]

Fri, 17 January 2014 16:04

Eric Daly

Messages: 11
Registered: January 2013

Junior Member

All of our reports use a linked SQL data source that is defined in a rptlibrary file. This allows us to move copies of the reports to the test server, and it automatically uses the library file on the test server to connect to the test database. However, I noticed that all of the reports are still querying the production database, and discovered that the linked data source becomes "edited" automatically when adding any new datasets. Examining the XML, it goes from linked:

<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="SQLSource_[databasename]" id="599"
 extends="General.SQLSource_[databasename]"/>

<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="SQLSource_[databasename]" id="599"
 extends="General.SQLSource_[databasename]">
            <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
            <property name="odaURL">jdbc:mysql://[production database path]</property>
            <property name="odaUser">[username]</property>
            <encrypted-property name="odaPassword" encryptionID="base64">[encrypted password]==</encrypted-property>
        </oda-data-source>

WHY? Is there a way to prevent BIRT from automatically overriding the library link? I don't want to hardcode the connection parameters into every report, because this defeats the purpose of linking to the library.

Report message to a moderator

Re: Library Data Source Is Hardcoded Into Reports [message #1244411 is a reply to message #1232739]

Wed, 12 February 2014 09:43

Stathis Alexopoulos

Messages: 42
Registered: September 2010

Member

Hello Eric,

I faced the same problem and i discovered the following message

Quote:

NOTE: This report item from the library has been modified. To restore the original library item, click on "Restore Properties"

at property editor of report data source. So, after the addition of datasets i am clicking that button.

I know it is not the wanted behavior, but at least it wotks.

Report message to a moderator

Previous Topic:	Which is the correct lifecycle of the BIRT runtime to create multiple reports
Next Topic:	Event not fired with dynamic table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:18:43 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter