DB2 datasources.xml parameters

Hi,

I'm having difficulty connecting my iServer to my DB2 database. I have set the following parameters within the datasources.xml file, but I keep getting an error saying that a databse connection does not exist. The user name and password are correct. Any help would be gratefuly appreciated.

<DataSourceConfig>

<DataSourceHosts>
kfirth-lt.s1ad.s1.com
</DataSourceHosts>

<ConnectionTypes>

<ConnectionType Name="MyDB2">
<JDBCDriver DriverName="com.ibm.db2.jcc.DB2Driver">
<ConnectionString>
jdbc:db2:B21NT01
</ConnectionString>
<ConnectionProperties>
<Property Name="user">devuser</Property>
<Property Name="password">*******</Property>
</ConnectionProperties>
<LibraryPath>

<Location>E:IBMSQLLIBjavadb2java.zip</Location>
<Location>E:IBMSQLLIBjavadb2jcc.jar</Location>
<Location>E:IBMSQLLIBjavadb2jcc_license_cu.jar</Location>
<Location>E:IBMSQLLIBjavadb2policy.jar</Location>
</LibraryPath>
</JDBCDriver>

</ConnectionType>
</ConnectionTypes>

<DatabaseTypes>


<DatabaseType Name="MyDB2v9" DisplayName="MyDB2 v9.1"
ConnectionType="MyDB2" DataSourceMapping="DB2"/>

</DatabaseTypes>
</DataSourceConfig>

Find more posts tagged with

Comments

averma

Hi sroweuk: 
 
Have you placed your JDBC drivers in the correct location? Here is an article that can help you get started: 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/deploying-birt-reports/169-placing-jdbc-drivers-for-birt-and-e-spreadsheet-reports/#description'>Placing JDBC drivers for BIRT and e.Spreadsheet Reports - Tips & Tricks - BIRT Exchange</a> 
 
Are you using information object in your report? Can you send error details from your log file? 
 
Ashwini

sroweuk

Hi,
I made the change that you suggested concerning the JDBC drivers but with no effect.

However, on searching through my logs I cam across the log below. I thought I had broken the config file, so I used the example MySQL datasources.xml and that produced the same error. It appears that its not parsing the file correctly. Not sure why Actuate's own example file would do this:

<ERROR m='' p='ais' t='Thu Dec 18 10:23:03 GMT 2008' id='nie.system.ConnectionConfigurationFileInitError'>
<a>
Failed to initialize the externalized connection configuration file.
Kfirth-ltdata_integrationdatasourcesdb2.xml
The root tag of the file was "DataSourceConfig". The tag should have been: "Config". Error location: //Kfirth-lt/data_integration/datasourcesdb2.xml
</a>
<a>Kfirth-ltdata_integrationdatasourcesdb2.xml</a>
<a>The root tag of the file was "DataSourceConfig". The tag should have been: "Config". Error location: //Kfirth-lt/data_integration/datasourcesdb2.xml</a>
</ERROR>

viyer

Can you remove the "hostname" entry from DataSourceHosts?

cch

hi, can i know where u put the datasoure.xml?

Currently, the report I have done using the sample data source and when i deploy the report in the iserver, can i point to another DB using the datasource configuration?

if possible, how to make it work?

Thanks.

averma

Hi cch:
The file "datasources.xml" is located in:
[InstallDir]iServeretcdata_integrationdatasources.xml

The iServer database connection configuration file can be used to externalize the data source properties in a BIRT Report design. When the report is deployed to the iServer and executed, the server reads the connection profile from the file path specified in the iServer?s database connection configuration file. The file path specified in the report design is ignored.

Ashwini