I have a report that is based on a data source stored within a report library.
When the report design is opened in a text editor (notepad or wordpad), the data source within the library is visible, and there is also a hard coded reference to the database connections including ip address.
<list-property name="libraries">
<structure>
<property name="fileName">Whatever.rptlibrary</property>
<property name="namespace">Whatever DataSource</property>
</structure>
</list-property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="name here" id="7"
extends="DataSource.text">
<property name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property>
<property name="odaURL">jdbc:oracle:thin:
@***.**.**.**:***/dbschema</property>
<property name="odaUser">net</property>
<encrypted-property name="odaPassword" encryptionID="base64">SKSFSX=</encrypted-property>
<property name="odaJndiName">name</property>
</oda-data-source>
</data-sources>
*'s indicate the ip address
When the hard coded reference to the database connections are manually removed, the following error is not displayed and the report generates on it's own. (everything within the <data-sources> tags)
Partial Error text: "org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details br>Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
Missing properties in Connection.open(Properties)"
1. Do not know why this information is embedded in the files in the first place, there are several other reports based on the library file that do not contain these.
2. Do not know if these can be automatically removed using BIRT or if it has to be a manual process.
Any assistance would be greatly appreciated!!
Thanks!
