Dynamic datasource in application

erg

I'm doing what I thought would be an easy task - generating a report from our build process (from an ant task).

I'm using birt 2.3.1 to design and test the reports. Once the reports are created, i want to move them to the build machine and run them from within continuum build process.

The data source is a jdbc datasource populated from our build process.

When connecting from within the birt viewer, all is well. When run from my own machine, all is well, when run form the remote machine I can not find the datasource profile (I think I'm using the correct terms)

from the errors it seems I need to set a PROFILE_STORE_FILE_PATH_PROP_KEY - (see error below)

How is this stuff set in a non-web application?

It seems it can not find the connection profile, hence the errors. I also note that the connection profile seems to be hard coded into the report xml. That directory structure does not exist on the build machine.





I get the following errors:

[java] Apr 5, 2009 4:30:31 PM org.eclipse.datatools.connectivity.oda.profile.provider.ProfilePropertyProviderImpl g
etProfileStoreFile
[java] WARNING: getProfileStoreFile( String ): java.net.MalformedURLException: unknown protocol: c
[java] Apr 5, 2009 4:30:31 PM org.eclipse.datatools.connectivity.oda.profile.provider.ProfilePropertyProviderImpl g
etProfileStoreFile
[java] WARNING: getProfileStoreFile( Properties ): Ignoring the PROFILE_STORE_FILE_PATH_PROP_KEY value in connectio
n properties. The specified path does not exist in file system.
[java] Apr 5, 2009 4:30:31 PM org.eclipse.datatools.connectivity.oda.profile.provider.ProfilePropertyProviderImpl g
etConnectionProfile
[java] WARNING: org.eclipse.datatools.connectivity.oda.OdaException ;
[java] org.eclipse.core.runtime.CoreException: Error loading connection profile data.
[java] org.eclipse.datatools.connectivity.internal.ConnectionProfileMgmt.loadCPs(ConnectionProfileMgmt.java:492)
[java] org.eclipse.datatools.connectivity.oda.profile.OdaProfileExplorer.loadProfiles(OdaProfileExplorer.java:278)
[java] org.eclipse.datatools.connectivity.oda.profile.OdaProfileExplorer.getProfileByName(OdaProfileExplorer.java:4
58)


thanks for any help

JasonW

You can change the path to the connection profile using property binding. Take a look at this video.<br />
<br />
<a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/querymod/index.php'>BIRT Example Reports</a><br />
It shows query modification but the same proecedure can be used to modify the profile location.<br />
<br />
Jason