Externalizing connection property values for a preconfigured connection type
The connection properties for the following connection types are specified in the <BDPro_HOME>\eclipse\plugins\com.actuate.ais.embeddable_<version> \Config\aisconfigfiles\etc\intsrvrsources.xml file and the $AC_SERVER_HOME/etc/intsrvrsources.xml file:
DB2
Informix
MySQL Enterprise
Oracle
PostgreSQL
SQL Server
Sybase
For example, the connection properties for the DB2 connection type are:
server
database
username
password
port
appcodepage
The connection properties are specified as follows:
<ConnectionType Name="DB2">
…
<ConnectionParams>
<ConnectionParam Name="server"
Display="Server"
Type="string"
ValueIsCaseSensitive="false" />
<ConnectionParam Name="database"
Display="Database"Type="string"
ValueIsCaseSensitive="false" />
<ConnectionParam Name="username"
Display="User name"
Type="string" />
<ConnectionParam Name="password"
Display="Password"
Type="masked" />
<ConnectionParam Name="port"
Display="Port"
Type="integer"
Optional="true"
DefaultValue="50000" />
<ConnectionParam Name="appcodepage"
Display="IANAAppCodePage"
Type="integer"
Optional="true"
DefaultValue="" />
</ConnectionParams>
</ConnectionType>
To externalize the connection property values for a DB2 connection, add a ConnectOptions element to the Runtime element in data source connection configuration file. For example:
The property names listed in the ConnectOptions element must match the connection parameter names listed in the ConnectionParams element in intsrvrsources.xml. The match is case-sensitive.
DB2