Database externalization through Connection Profile Storage URL from Property Binding

Hi, We are using Database externalization technique to connect different DB at run time.On Feb, I have downloaded new WAR file from Actuate for Tomcat 64 Bit and tried same DB externalization referring from Connection file (my file name in system devConnection) as below. But it fails to refer this connection. previous WAR file is working fine even now in system, only change is with new WAR file it fails to connect.When I try to run report with new WAR file, report is using JDBC Data Source connection that is HARD coded in report instead of Connection Profile Storage URL, I am not getting any error log, report runs good. Help me if any changes required in devConnection file as below or any other setup, as I am using same file for previous WAR file and new War file, Also using same report, server, settings only change in WAR file. Downloaded WAR file: WL_TOMCAT_ActuateBIRTViewer.warMonth: February 2014, downloaded from <a data-ipb='nomediaparse' href='http://www.actuate.com'>www.actuate.com</a>. Details: Property Binding:Connection Profile Storage URL: reportContext.getAppContext().get("birt.viewer.resource.path")+"/DB/devConnection" devConnection file==============<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DataTools.ServerProfiles version="1.0">
<profile autoconnect="Yes" desc="" id="7cd26e00-dd3b-11e1-9e86-d04b6abe67fa" name="devConnection" providerID="org.eclipse.birt.report.data.oda.jdbc">
<baseproperties><property name="odaJndiName" value=""/>
<property name="odaDriverClass" value="oracle.jdbc.OracleDriver"/>
<property name="odaURL" value="jdbc:oracle:thin:@<db conn string>"/>
<property name="odaPassword" value="<db user>"/><property name="odaUser" value="<db password>"/>
</baseproperties><org.eclipse.datatools.connectivity.versionInfo>
<property name="technology.version.org.eclipse.birt.report.data.oda.jdbc" value="3.0.4"/>
<property name="server.version" value="0.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options"/>
<property name="technology.name.org.eclipse.birt.report.data.oda.jdbc" value="DTP Open Data Access"/>
<property name="server.name" value="Oracle"/></org.eclipse.datatools.connectivity.versionInfo>
</profile>
</DataTools.ServerProfiles> Regards,Sant

Find more posts tagged with

Comments

mwilliams

So, you're using the BIRT Viewer Toolkit, now? What version of BIRT were you using before?

sant

hi, Yes I am using BIRT Viewer Toolkit.We are using BIRT Version: Indigo Release (3.7.0)We are using same version both for previous WAR file and New WAR file. Regards,Sant

mwilliams

Not sure I'm understanding. You're using BIRT 3.7.0 and had BIRT Viewer Toolkit running just fine, now it's not working? At first I thought you were saying you upgraded to BVT from the Sample Viewer and were having issues, now it sounds like you had BVT and then installed a new WAR and it's not working. Let me know. For what it's worth, BIRT Viewer Toolkit uses BIRT 4.2.2 or 4.3. If you can, you might try a newer version of BIRT designer.