nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dynamic Data Source from Environment properties

quan

I have a report that uses an XML DataSource. In development, I want to connect to my development DB for the data. However, in QA/UAT/PROD environments I want to grab the JDBC Url / user / password from environment variables. (Most examples I see replaces the Datasource.xml file based on a param; however, I choose to use environment variables because I don't want the JDBC properties of Production to be part of the source code / war file.)
 
I refactored the XML Datasource as such:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DataTools.ServerProfiles version="1.0">
 <profile autoconnect="No" desc="" id="a32670c1-562d-11e4-956c-d9f7873a0515" name="SW" providerID="org.eclipse.birt.report.data.oda.jdbc">
 <baseproperties>
 <property name="odaURL" value="${dataSource.url}" />
 <property name="odaDriverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
 <property name="odaPassword" value="${dataSource.password" />
 <property name="odaUser" value="${dataSource.username}" />
 <property name="contentBidiFormatStr" value="ILYNN" />
 <property name="metadataBidiFormatStr" value="ILYNN" />
 </baseproperties>
 </profile>
</DataTools.ServerProfiles>
 
I'm trying to use Spring to replace these property place holder values, but was not successful.
Here is my relevant Spring appContext.xml:
 <bean id="propertyPlaceholder"
 class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
 <property name="systemPropertiesModeName" value="SYSTEM_PROPERTIES_MODE_OVERRIDE"/>
 <property name="locations">
 <list>
 <value>classpath://MyApp.properties</value>
 </list>
 </property>
 
 </bean>
 
MyApp.properties contain the development DB properties. Is anyone using the same pattern and got this to work?
My guess is Spring's PropertyPlaceholderConfigurer only works with Spring beans, or could it be extended to BIRT's Datasource XML file?
 
I imagine a lot of people will find this solution useful.
 
Thank You.

Find more posts tagged with

Comments

mwilliams

Have you tried using the expression builders in the data source's property binding tab to access your environment variables?

quan

In Property Binding, I tried
1. dataSource.url, dataSource.username, dataSource.password
2. as well as ${dataSource.url}, ${dataSource.username}, ${dataSource.password}
 
With no luck. I also added the Resource properties file in Properties / Resources / Properties Files, and it didn't work.
 
What am I doing wrong?

mwilliams

Take a look at this devshare post:
 
<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1039-using-linux-environment-variables/'>http://developer.actuate.com/community/forum/index.php?/files/file/1039-using-linux-environment-variables/</a>