Installation guide

21
– If you are using Java 5 and the ojdbc5.jar driver file, add a connection
property element defining the property oracle.jdbc.V8Compatible=true.
For example:
<connection-property name="oracle.jdbc.V8Compatible">true</connection-property>
Note: If you are using Java 6 and the ojdbc6.jar driver file, the
V8Compatible setting is not required.
UDB
<connection-
url>jdbc:db2://[hostname]:[port]/yourdatabase</connection-
url>
– Replace [hostname] with the hostname of your database server.
– Replace [port] with the port number of your database server.
– Replace yourdatabase with the name of your Process Commander
database.
– Add connection property elements for the following 6 properties:
<connection-property
name="currentSchema">[
SCHEMANAME]</connection-property>
Replace [
SCHEMANAME]with the user schema name for your Process
Commander database.
<connection-property name="currentFunctionPath">
SYSIBM,SYSFUN,[
SCHEMANAME]</connection-property>
Replace [
SCHEMANAME] with the user schema name for your Process
Commander database. SYSIBM and SYSFUN are system schemas
provided by DB2. They are required because Process Commander 6.1
SP2 makes use of some functions made available in these schemas.
Note: Be sure to enter the schema name in all capital letters.
<connection-property name="fullyMaterializeLobData">true</connection-property>
<connection-property name="fullyMaterializeInputStreams">true</connection-
property>
<connection-property name="progressiveStreaming">2</connection-property>
<connection-property name="progressiveLocators">2</connection-property>
3. In the element <driver-class>, change the value to reference he fully
qualified Java class name of the appropriate JDBC driver::
– Oracle 9i/10g: oracle.jdbc.OracleDriver
– IBM DB/2 Type 4: com.ibm.db2.jcc.DB2Driver