Home
Analytics
connection profile issue
purushdk
Hi ,
Am using birt.2.5.1 all in one eclipse windows version.
i have different environment for development and production server.
i have stored connection profile xml file in the under application web-inf folder.
Example
to get parameter list am using connection profile which is working fine in the development environment, since we don't have production server db credentials, we can't configure in the application.
after deploy the reports war file in the production server, we try to change connection profile information for database connectivity, but its taking from rptdesing xml what development phase DB details used.
kindly provide solution to rectify automatically take db credentials once change connection profile
example
connection profile format in development phase
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DataTools.ServerProfiles version="1.0">
<profile autoconnect="Yes" desc="" id="75a1e9f0-1df6-11df-91e9-949bd125e079" name="profileconnection" providerID="org.eclipse.birt.report.data.oda.jdbc">
<baseproperties>
<property name="odaURL" value="jdbc:oracle:thin:sirisha/sirisha@192.168.2.180:1521:XE"/>
<property name="odaDriverClass" value="oracle.jdbc.driver.OracleDriver"/>
<property name="odaPassword" value="sirisha"/>
<property name="odaUser" value="sirisha"/>
<property name="contentBidiFormatStr" value="ILYNN"/>
<property name="metadataBidiFormatStr" value="ILYNN"/>
</baseproperties>
</profile>
</DataTools.ServerProfiles>
production phase after chaging
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DataTools.ServerProfiles version="1.0">
<profile autoconnect="Yes" desc="" id="75a1e9f0-1df6-11df-91e9-949bd125e079" name="profileconnection" providerID="org.eclipse.birt.report.data.oda.jdbc">
<baseproperties>
<property name="odaURL" value="jdbc:oracle:thin:abc/abc1234@192.168.2.100:1521:XE"/>
<property name="odaDriverClass" value="oracle.jdbc.driver.OracleDriver"/>
<property name="odaPassword" value="abc1234"/>
<property name="odaUser" value="abc"/>
<property name="contentBidiFormatStr" value="ILYNN"/>
<property name="metadataBidiFormatStr" value="ILYNN"/>
</baseproperties>
</profile>
</DataTools.ServerProfiles>
Find more posts tagged with
Comments
mwilliams
Take a look at this devShare entry. It may help:
http://www.birt-exchange.org/org/devshare/deploying-birt-reports/1298-development-to-live-server-using-connection-profiles/
Geetha87
Hi ,
I'm using Birt 2.6.1 version and i'm new to Birt.
I'm working on a product application and presently I need to generate a report .As a part of this, the input for the 'datasource' comes dynamically from my JSP page. And so now, upon receiving this datasource the further report generation proceeds. For now, how do i fetch this datasource coming from JSP (dynamically) and insert as a part of a report criteria ?
I would really appreciate if the explaination is done in detail.
Thanks in advace.
Help seeker,
Geetha.