Business process container install wizard settings

Use the install wizard to install and configure the business process container.

This page describes the install wizard fields, in the order that they appear in the install wizard.

Step 1 database configuration:

Step 2 JMS provider and security:

Step 3 JMS resources and Web client:

Note: You cannot change these fields after they have been applied. If you want to change any of these values after the container is configured, you must uninstall and reinstall the BPEContainer.ear enterprise application file. This action can result in the loss of data such as pending messages in queues, process templates, and process instances in the process choreographer database.

XA data source
You must create a new data source that will only be used by process choreographer.
Mandatory Yes
Data type Drop-down list
Choices Create a new XA data source:
  • Cloudscape 5.1 (Cloudscape JDBC Provider (XA))
  • DB2 UDB 8.1 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA))
  • DB2 UDB 8.1 (DB2 Universal JDBC Driver Provider (XA))
  • DB2 z/OS 7 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA))
  • DB2 zOS 7 (DB2 Universal JDBC Driver Provider (XA))
  • DB2 UDB for iSeries (Native XA V5R2 and later)
  • DB2 UDB for iSeries (Toolbox XA)
  • Informix 9.3 & 9.4 (Informix JDBC Driver (XA))
  • Oracle 8i OCI (Oracle JDBC Driver (XA))
  • Oracle 8i thin (Oracle JDBC Driver (XA))
  • Oracle 9i OCI (Oracle JDBC Driver (XA))
  • Oracle 9i thin (Oracle JDBC Driver (XA))
  • SQL Server 2000 (DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA))
  • SQL Server 2000 (WebSphere embedded ConnectJDBC driver for MS SQL Server (XA))
  • Sybase 12.0 (Sybase JDBC Driver (XA))
  • Sybase 12.5 (Sybase JDBC Driver (XA))
Implementation class name
The Java class name of the Java Database Connectivity (JDBC) driver implementation.
Mandatory Yes
Data type String
Default for Cloudscape 5.1 (Cloudscape JDBC Provider (XA)) com.ibm.db2j.jdbc.DB2jXADataSource
Default for DB2 UDB 8.1 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA)) and for DB2 z/OS 7 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA)) COM.ibm.db2.jdbc.DB2XADataSource
Default for DB2 UDB 8.1 (DB2 Universal JDBC Driver Provider (XA)) and for DB2 z/OS 7 (DB2 Universal JDBC Driver Provider (XA)) com.ibm.db2.jcc.DB2XADataSource
Default for DB2 UDB for iSeries (Native XA V5R2 and later) com.ibm.db2.jdbc.app.UDBXADataSource
Default for DB2 UDB for iSeries (Toolbox XA) com.ibm.as400.access.AS400JDBCXADataSource
Default for Informix 9.3 & 9.4 (Informix JDBC Driver (XA)) com.informix.jdbcx.IfxXADataSource
Default for Oracle 8i OCI, 8i thin, 9i OCI, and 9i thin (Oracle JDBC Drivers (XA)) oracle.jdbc.xa.client.OracleXADataSource
Default for SQL Server 2000 (DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA)) com.ddtek.jdbcx.sequelink.SequeLinkDataSource
Default for SQL Server 2000 (WebSphere embedded ConnectJDBC driver for MS SQL Server (XA)) com.ibm.websphere.jdbcx.sqlserver. SQLServerDataSource
Default for Sybase 12.0 (Sybase JDBC Driver (XA)) and for Sybase 12.5 (Sybase JDBC Driver (XA)) com.sybase.jdbc2.jdbc.SybXADataSource
Classpath (data source)
The path to the Java archive (jar) or zip file that contains the JDBC driver. The JDBC driver provides the data source implementation class. If the database is remote, this is the path where the JDBC driver is installed on the client machine.
Mandatory
For Cloudscape
No, the JDBC driver is already on the WebSphere classpath.
For DB2 UDB, DB2 z/OS, Informix, Oracle, SQL Server, and Sybase
Yes
Data type String
Default for Cloudscape 5.1
${CLOUDSCAPE_JDBC_DRIVER_PATH}/db2j.jar
The value for ${CLOUDSCAPE_JDBC_DRIVER_PATH} is predefined and does not need to be set.
Default for DB2 UDB 8.1 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA)) and for DB2 z/OS 7 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA))
${DB2_JDBC_DRIVER_PATH}/db2java.zip
The value for ${DB2_JDBC_DRIVER_PATH} depends on the DB2 Client installation directory and must be set explicitly in Environment > Manage WebSphere Variables. Typical values are:
On Windows:
c:\Program Files\SQLLIB\java
On AIX and HP-UX:
/home/db2inst1/sqllib/java
On Solaris:
/export/home/db2inst1/sqllib/java
Default for DB2 UDB 8.1 (DB2 Universal JDBC Driver Provider (XA)) and for DB2 z/OS 7 (DB2 Universal JDBC Driver Provider (XA))
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/
               db2jcc.jar    
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/
               db2jcc_license_cu.jar   
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/
               db2jcc_license_cisuz.jar
The value for ${DB2UNIVERSAL_JDBC_DRIVER_PATH} depends on the installation root directory of the corresponding DB2 Client or DB2 Connect, and must be set in Environment> Manage WebSphere Variables. Typical values for ${DB2UNIVERSAL_JDBC_DRIVER_PATH} are:
On Windows:
c:\Program Files\SQLLIB\java
On AIX and HP-UX:
/home/db2inst1/sqllib/java
On Solaris:
/export/home/db2inst1/sqllib/java
Default for Informix 9.3 and 9.4
${INFORMIX_JDBC_DRIVER_PATH}/ifxjdbc.jar
${INFORMIX_JDBC_DRIVER_PATH}/ifxjdbcx.jar
The value for ${INFORMIX_JDBC_DRIVER_PATH} depends on the JDBC driver installation directory and must be set in Environment> Manage WebSphere Variables.
Default for Oracle 8i and Oracle 9i
${ORACLE_JDBC_DRIVER_PATH}/ojdbc14.jar
The value for ${ORACLE_JDBC_DRIVER_PATH} depends on the Oracle client installation or JDBC driver installation directory and must be set in Environment> Manage WebSphere Variables.
Default for SQL Server 2000 (DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA))
${WAS_LIBS_DIR}/sljc.jar
${WAS_LIBS_DIR}/spy-sl53.jar
The value for ${WAS_LIBS_DIR} depends on the WebSphere installation directory and must be set in Environment> Manage WebSphere Variables. Typical values are:
On Windows:
C:\Program Files\WebSphere\AppServer\lib
On UNIX:
/opt/WebSphere/AppServer/lib
Default for SQL Server 2000 (WebSphere embedded ConnectJDBC driver for MS SQL Server (XA))
${WAS_LIBS_DIR}/sqlserver.jar
${WAS_LIBS_DIR}/base.jar
${WAS_LIBS_DIR}/util.jar
${WAS_LIBS_DIR}/spy.jar
The value for ${WAS_LIBS_DIR} depends on the WebSphere installation directory and must be set in Environment> Manage WebSphere Variables. Typical values are:
On Windows:
C:\Program Files\WebSphere\AppServer\lib
On UNIX:
/opt/WebSphere/AppServer/lib
Default for Sybase 12.0 and Sybase 12.5
${SYBASE_JDBC_DRIVER_PATH}/jconn2.jar
The value for ${SYBASE_JDBC_DRIVER_PATH} depends on the Sybase JDBC driver installation directory and must be set in Environment> Manage WebSphere Variables. Typical values are:
On Windows:
C:\Program Files\Sybase\jConnect-5_5\classes
On UNIX:
/opt/sybase/jConnect-5_5/classes
Data source user name
A user ID that has the authority to connect to the database and to manipulate the data. If you want to have an automatic update of the database schema the user ID must have the authority to create tables and indexes in the database.
Mandatory
For Cloudscape
No
For DB2 UDB, DB2 iSeries, DB2 z/OS, Informix, Oracle, SQL Server, and Sybase
Yes
Data type String
Default The user ID that is currently logged on to the administrative console.
Data source password
The password for the data source user ID.
Mandatory
For Cloudscape
No
For DB2 UDB, DB2 z/OS, Informix, Oracle, SQL Server, and Sybase
Yes
Data type String
Default None
Custom properties
Extra parameters that are required by the database system.
Mandatory Yes
Data type String
Data format Multiple lines of Property=Value
Properties for Cloudscape
databaseName=
install_root/ProcessChoreographer/BPEDB. Required string. Defines which database to access. The value must be a fully qualified path.
shutdownDatabase=
Optional string. If set to shutdown, the database shuts down when a java.sql.Connection object is obtained from the data source. For example, if the data source is an XADataSource, a getXAConnection().getConnection() is necessary to cause the database to shut down.
dataSourceName=
Optional string. Name for the ConnectionPooledDataSource or XADataSource. Not used by the data source object. Used for information purposes only.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Not used by the data source object. Used for information purposes only.
connectionAttribute=
Optional string. Connection attributes specific to Cloudscape. Refer to the Cloudscape documentation for a complete list of attributes.
createDatabase=
Optional string. If set to create, and the database specified in the databaseName parameter does not already exist, the database will be created. The database is created when a connection object is obtained from the data source.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. This SQL statement is used for pre-test connection function. If pre-test connection is enabled in j2c.properties, this SQL statement will be executed to the connection to make sure the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
remoteDataSourceProtocol=
Optional string. If the database is remote and the data source accesses the database using a client, set this property to specify which client and server protocol to use. Currently, the only protocol value supported is rmi.
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA))
databaseName=BPEDB
Required string. For DB2 UDB it defines which database to access. For DB2 z/OS it defines which subsystem contains the DB2 z/OS database.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Not used by the data source object. Used for information purposes only.
portNumber=
Optional integer. Specifies the TCP/IP port number where the JDBC provider resides.
connectionAttribute=cursorhold=0
Optional string. Connection attributes specific to DB2. Refer to the DB2 documentation for a complete list of connection attributes.
loginTimeout=0
Optional integer. If set to zero, no timeout takes place. Non-zero values specify the maximum number of seconds allowed to establish a connection to the database.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. If you enabled pre-test connection in the j2c.properties file, this pre-test string is used to make sure that the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will reduce performance because of the exception handling if table TABLE1 is not defined in the database. It is recommended to provide your own SQL statement to improve the performance.
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Universal JDBC Driver Provider (XA))
databaseName=BPEDB
Required string. For DB2 UDB it defines which database to access. For DB2 z/OS it defines which subsystem contains the DB2 z/OS database.
driverType=2
Required integer. The JDBC connectivity-type of a data source. The only permitted value is 2.
serverName=""
Optional string. The TCP/IP address or host name for the DRDA server.
portNumber=50000
Optional integer. The TCP/IP port number where the DRDA server resides.
enableSQLJ=false
Optional boolean. This value is used to indicate whether SQLJ operations may be performed with this data source. If enabled, this data source can be used for both JDBC and SQLJ calls. Otherwise, only JDBC usage is permitted.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Not used by the data source object. Used for information purposes only.
traceLevel=""
Optional integer. The DB2 trace level for logging to the logWriter or trace file. Possible trace levels are: TRACE_NONE = 0,TRACE_CONNECTION_CALLS = 1,TRACE_STATEMENT_CALLS = 2,TRACE_RESULT_SET_CALLS = 4,TRACE_DRIVER_CONFIGURATION = 16,TRACE_CONNECTS = 32,TRACE_DRDA_FLOWS = 64,TRACE_RESULT_SET_META_DATA = 128,TRACE_PARAMETER_META_DATA = 256,TRACE_DIAGNOSTICS = 512,TRACE_SQLJ = 1024,TRACE_ALL = -1, .
traceFile=""
Optional string. The trace file to store the trace output.
fullyMaterializeLobData=true
Optional boolean. This setting controls whether or not LOB locators are used to fetch LOB data. If enabled, LOB data is not streamed, but is fully materialized with locators when the user requests a stream on the LOB column. The default value is true.
resultSetHoldability=2
Optional integer. Determine whether ResultSets are closed or kept open when committing a transaction. The possible values are: 1 (HOLD_CURSORS_OVER_COMMIT), 2 (CLOSE_CURSORS_AT_COMMIT).
currentPackageSet=""
Optional string. This property is used in conjunction with the DB2Binder - collection option which is given when the JDBC/CLI packageset is bound during installation by the DBA.
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Universal JDBC Driver Provider (XA)) (continued)
readOnly=false
Optional boolean. This property creates a read only connection.
deferPrepares=false
Optional boolean. This property provides a performance directive that affects the internal semantics of the input data type conversion capability of the driver. If it is set to "true" the Universal driver defers 'internal prepare requests'. In this case, the driver works without the benefit of described parameter or result set metadata until execute time. So undescsribed input data is sent 'as is' to the server without any data type cross-conversation of the inputs.
currentSchema=""
Optional string. Identifies the default schema name used to qualify unqualified database object references where applicable in dynamically prepared SQL statements. Unless currentSchema is used, the default schema name is the authorization id of the current session user.
cliSchema=""
Optional string. Indicates the schema of the DB2 shadow catalog tables or views to search when you issue a database metadata catalog query.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
retrieveMessagesFromServerOnGetMessage=true
If set to true it directs all calls to the standard JDBC SQLException.getMessage() to invoke a server-side stored procedure which retrieves the readable message text for the error.
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Universal JDBC Driver Provider (XA)) (continued)
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. This SQL statement is used for pre-test connection function. If pre-test connection is enabled in j2c.properties, this SQL statement will be executed to the connection to make sure the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
enableSQLJ=false
Optional boolean. This SQL statement is used for pre-test connection function. If pre-test connection is enabled in j2c.properties, this SQL statement will be executed to the connection to make sure the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
Properties for Properties for Informix 9.3 & 9.4
databaseName=BPEDB
Required string. The name of the database.
serverName=""
Required string. The name of the Informix instance on the physical machine. There is no default for the string and therefore you need to set it explicitly.
portNumber=1526
Required integer. The TCP/IP port number of the Informix instance. The value "1526" is the default Informix port on Windows. On UNIX it is "61000".
ifxIFXHOST=hostname
Required string. The physical machine name of the server that hosts the informix database. "Localhost" does not work.
informixLockModeWait=2
Required integer. By default, Informix throws an exception when it cannot acquire a lock, rather than waiting for the current owner of the lock to release it. To modify this behavior, set this property to the number of seconds to wait for a lock. The default is 2 seconds. Any negative value means to wait forever.
informixAllowNewLine=false
Optional boolean. his property allows newLines to be added on a query String. Its disabled by default.
roleName=""
Optional string. The role name.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Not used by the data source object. Only used for information purposes.
loginTimeout=""
Optional integer. The maximum time to attempt to connect a database. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached.
dataSourceName=""
Optional string. The name of the data source. Only used for informational purposes.
ifxUSE_DTENV to ifxPSORT_DBTEMP
Optional string. The value for Informix specific variables. Please refer to the Informix documentation for possible values.
Properties for Properties for Informix 9.3 & 9.4 (continued)
enableMultithreadedAccessDetection=false
Optional boolean. Indicates whether or not to detect multithreaded access to a Connection and its corresponding Statements, ResultSets, and MetaDatas.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. This SQL statement is used for pre-test connection function. If pre-test connection is enabled in j2c.properties, this SQL statement will be executed to the connection to make sure the connection is good. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
Properties for Oracle 8i OCI & Oracle 9i OCI
driverType=oci8
Required string. Defines the type of the JDBC driver.
oraclelogPrintMask=62
Optional integer. The oraclelogPrintMask controls which information is printed with each trace message. Oracle9i requires the ojdbc14_g.jar file. The default is 62, which is ([OracleLog.FIELD_OBJECT for 9i / OracleLog.FIELD_CONN for 8i] 32 | OracleLog.FIELD_CATEGORY 16 | OracleLog.FIELD_SUBMOD 8 | OracleLog.FIELD_MODULE 4 | OracleLog.FIELD_TIME 2).

Possible values: OracleLog.FIELD_TIME 2, OracleLog.FIELD_MODULE 4, OracleLog.FIELD_SUBMOD 8, OracleLog.FIELD_CATEGORY 16, OracleLog.FIELD_OBJECT 32, OracleLog.FIELD_THREAD 64.

oraclelogModuleMask=1
Optional integer. The oraclelogModuleMask controls which modules write debug output. Oracle9i requires the ojdbc14_g.jar file. The default is 1, which is ( OracleLog.MODULE_DRIVER 1).

Possible values: OracleLog.MODULE_DRIVER 1, OracleLog.MODULE_DBACCESS 2.

oraclelogCategoryMask=47
Optional integer. The oraclelogCategoryMask controls which category to be output. Oracle9i requires the ojdbc14_g.jar file. The default is 47, which is ( OracleLog.USER_OPER 1 | OracleLog.PROG_ERROR 2 | OracleLog.ERROR 4 | OracleLog.WARNING 8 | OracleLog.DEBUG1 32).

Possible values: OracleLog.USER_OPER 1, OracleLog.PROG_ERROR 2, OracleLog.ERROR 4, OracleLog.WARNING 8, OracleLog.FUNCTION 16, OracleLog.DEBUG1 32, OracleLog.SQL_STR 128.

TNSEntryName=BPEDB
Required string. The entry name that is used in tnsnames.ora to identify the database.
networkProtocol=
Optional string. Specifies which protocol is used, for example, TCP/IP or IPC.
databaseName=BPEDB
Optional string. Defines which database to access.
serverName=
Optional string. The name of the server where the Oracle database resides.
portNumber=1521
Optional integer. The TCP/IP port number where the JDBC driver resides.
Properties for Oracle 8i OCI & Oracle 9i OCI (continued)
dataSourceName=
Optional string. The name of the datasource. Only used for informational purposes.
URL=jdbc:oracle:oci8:@BPEDB
Optional string. The URL specifies the database from which the data source obtains connections.
loginTimeout=""
Optional integer. The maximum time to attempt to connect the database. If set to zero, there will be no timeout. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Used for information purposes only.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
transactionBranchesLooselyCoupled=false
Optional boolean. This property is introduced as a result of Oraclebug 2511780. Oracle Patch for 2511780 must be installed before setting this property to true. Failure to install this patch causes a program error. Check the WebSphere readme file for more information.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. If you have enabled a pre-test connection in the j2c.properties file, this pre-test string is used to make sure that the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
Properties for Oracle 8i thin & Oracle 9i thin
driverType=thin
Required string. Defines the type of the JDBC driver.
oraclelogPrintMask=62
Optional integer. The oraclelogPrintMask controls which information is printed with each trace message. Oracle9i requires the use of ojdbc14_g.jar. Default is 62 which is ([OracleLog.FIELD_OBJECT for 9i / OracleLog.FIELD_CONN for 8i] 32 | OracleLog.FIELD_CATEGORY 16 | OracleLog.FIELD_SUBMOD 8 | OracleLog.FIELD_MODULE 4 | OracleLog.FIELD_TIME 2). Possible values: OracleLog.FIELD_TIME 2, OracleLog.FIELD_MODULE 4, OracleLog.FIELD_SUBMOD 8, OracleLog.FIELD_CATEGORY 16, OracleLog.FIELD_OBJECT 32, OracleLog.FIELD_THREAD 64.
oraclelogModuleMask=1
Optional integer. The oraclelogModuleMask controls which modules write debug output. Oracle9i requires the use of ojdbc14_g.jar. Default is 1 which is ( OracleLog.MODULE_DRIVER 1). Possible values (OracleLog.MODULE_DRIVER 1, OracleLog.MODULE_DBACCESS 2)"
oraclelogCategoryMask=47
Optional integer. The oraclelogCategoryMask controls which category to be output. Oracle9i requires the use of ojdbc14_g.jar. Default is 47 which is ( OracleLog.USER_OPER 1 | OracleLog.PROG_ERROR 2 | OracleLog.ERROR 4 | OracleLog.WARNING 8 | OracleLog.DEBUG1 32). Possible values (OracleLog.USER_OPER 1, OracleLog.PROG_ERROR 2, OracleLog.ERROR 4, OracleLog.WARNING 8, OracleLog.FUNCTION 16, OracleLog.DEBUG1 32, OracleLog.SQL_STR 128)"
TNSEntryName=""
Optional string. Not used for the thin JDBC driver.
networkProtocol=""
Optional string. Specifies which protocol is used, for example, TCP/IP or IPC.
databaseName=BPEDB
Required string. Defines which database to access.
serverName=hostname
Required string. The name of the server where the Oracle database resides
portNumber=1521
Required integer. The TCP/IP port number where the JDBC driver resides.
Properties for Oracle 8i thin & Oracle 9i thin (continued)
dataSourceName=""
Optional string. The name of the data source. Only used for informational purposes.
URL=jdbc:oracle:thin:@hostname:1521:BPEDB
Required string. The URL specifies the database and the database host from which the data source will obtain connections.
loginTimeout=""
Optional integer. The maximum time to attempt to connect the database. If set to zero, there will be no timeout. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached.
description=DataSource for Process Choreographer
Optional string. Description of the datasource. Only used for information purposes.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it will automatically detect multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
transactionBranchesLooselyCoupled=false
Optional boolean. This property is introduced as a result of Oraclebug 2511780, Oracle Patch for 2511780 must be installed before setting this property to true, failure to do that would cause a program error. Please check the WebSphere readme file for more info.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. If you have enabled pre-test connection in j2c.properties, this pre-test string is used to make sure that the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
Properties for SQL Server 2000 (DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA))
databaseName=BPEDB
Required string. The database name.
serverName=hostname
Required string. The TCP/IP address of the SequeLink server in dotted format or host name format.
portNumber=19996
Required integer. The TCP/IP port number where the jdbc driver resides.
spyAttributes=""
Optional string. The SPY attributes. See the ConnectJDBC documentation for a list of attributes.
loginTimeout=""
Optional integer. The maximum time to attempt to connect a database. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached.
description=DataSource for Process Choreographer
Optional string. The description of this datasource.
cipherSuites=""
Optional string. The Secure Socket Layer(SSL) cipher suites with which the SequeLink Java Client can use to connect. This property is required when networkProtocol=ssl.
blockFetchForUpdatee=1
Optional integer. When the isolation level is ReadCommitted and a SELECT FOR UPDATE statement is issued against some data stores, the SequeLink Java Client does not lock the expected row. Default is 1 which does not lock the expected row.
SLKStaticCursorLongColBuffLen=4
Optional integer. The amount of data (in KB) that is buffered for SQL_LONGVARCHAR and SQL_LONGVARBINARY columns which an insensitive result set.
certificateChecker=com.merant.sequelink.cert. CertificateCheckerInterface
Optional string. The fully qualified class name of a user-defined server certificate checker class.
serverDataSource=""
Optional string. A property that specifies a string to identify the server data source to be used for the connection. If unspecified, the configuration of the default server data source will be used for the connection.
enable2Phase=true
Optional boolean. When true, two phase connections are used. Do not change this value because this value is set for with this provider and is required by Process Choreographer.
applicationName=""
Optional string. Identifies the application that is establishing the Connections. When the application does not provide a value, the default value is SequeLink JDBC Application.
Properties for SQL Server 2000 (DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA)) (continued)
MSSMapLongToDecimal=""
Optional boolean. Enable client-side workarounds. Refer to the SequeLink Administrator's Guide.
ORANumber0IsNumeric=""
Optional boolean. Enable client-side work-arounds. Refer to the SequeLink Administrator's Guide.
enableMultithreadedAccessDetection=false
Optional boolean. Indicates whether or not to detect multithreaded access to a Connection and its corresponding Statements, ResultSets, and MetaDatas.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. This SQL statement is used for pre-test connection function. If pre-test connection is enabled in j2c.properties, this SQL statement will be executed to the connection to make sure the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
allowPrefetch=0
Optional integer. Enables the prefetch feature. When enabled, the JDBC driver requests a next set of rows from the server while the client is processing the previous set of rows. 0 = disable; 1 = enable.
insensitiveResultSetBufferSize=2058
Optional integer. The memory caching scheme for scroll-insensitive cursors. When set to 0, the driver uses a memory caching mechanism that does not use disk overflow. When set to a value greater than 0, data overflows to disk when the size of cached data exceeds the specified amount, specified in kilobytes. When set to a value less than 0, the data provider providers better performance. However, memory use may be affected.
Properties for SQL Server 2000 (WebSphere embedded ConnectJDBC driver for MS SQL Server (XA))
databaseName=BPEDB
Required string. Defines which database to access.
serverName
Required string. The TCP/IP address of the SequeLink server in dotted format or host name format.
portNumber=1433
Required integer. The TCP/IP port number where the Microsoft SQL Server resides.
selectMethod=
Optional string. Determine whether or not Microsoft SQL Server 'server cursors' are used for SQL queries. Values are 'cursor' or 'direct'. See the ConnectJDBC documentation for more information.
dataSourceName=
Optional string. Name for the data source. Only used for information purposes.
spyAttributes=
Optional string. The SPY attributes. See the ConnectJDBC documentation for a list of attributes.
loginTimeout=
Optional integer. The maximum time to attempt to connect a database. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached. Zero implies no time limit.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Not used by the data source object. Used for information purposes only.
enable2Phase=true
Required boolean. When true, two phase connections are used. Do not change this value because this value is set for with this provider and process choreographer requires two-phase connections.
maxPooledStatements=
Optional integer. The maximum number of pooled PreparedStatements for this connection.
sendStringParametersAsUnicode=""
Optional boolean. Determines whether string parameters are sent to the SQL Server database as Unicode or in the default character encoding of the database. For more information, refer to the ConnectJDBC documentation.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
Properties for SQL Server 2000 (WebSphere embedded ConnectJDBC driver for MS SQL Server (XA)) (continued)
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. If you enabled pre-test connection in the j2c.properties file, this pre-test string is used to make sure that the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
codePageOverride=""
Optional string. Specifies the code page the driver uses when converting character data. See the ConnectJDBC documentation for more information.
insensitiveResultSetBufferSize=2048
Optional integer. Determines the amount of memory used by the driver to cache insensitive result set data. See the ConnectJDBC documentation for more information.
Properties for Sybase 12.0 & Sybase 12.5
databaseName=BPEDB
Required string. Defines which database to access.
serverName=hostname
Required string. The name of the server where the Sybase database resides.
portNumber=4100
Required integer. The TCP/IP port number where the JDBC driver resides.
networkProtocol=
Optional string. Specifies which protocol is used, for example, socket or SSL. When set to socket, Secure Sockets Layer (SSL) encryption is not used.
dataSourceName=
Optional string. Name for the data source. Used for information purposes only.
version=
Optional integer. The version number of the driver.
resourceManagerName=
Optional string. The name of the resource manager.
loginTimeout=
Optional integer. The maximum time to attempt to connect a database. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached. If set to zero, there will be no timeout.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Used for information purposes only.
connectionProperties=SELECT_OPEN_CURSORS=true
Required string. Refer to the Sybase documentation for more information about SELECT_OPEN_CURSORS and other properties.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. If you enabled pre-test connection in the j2c.properties file, this pre-test string is used to make sure that the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
JMS provider
Specifies which messaging service the business process container uses.
Mandatory Yes
Data type Drop-down list
Choices
For external WebSphere MQ
WebSphere MQ JMS Provider
For the messaging embedded in WebSphere
WebSphere JMS Provider
Queue manager
The name of the queue manager that is used by the business process container.
Mandatory If you selected WebSphere MQ JMS Provider; otherwise, this field is disabled.
Data type String
Value Your queue manager name, for example, WAS_nodeName_serverName.
Classpath (JMS provider)
The path to the MQ Java lib directory.
Mandatory If you have not defined the WebSphere environment variable ${MQ_INSTALL_ROOT} to point to the WebSphere MQ installation root directory.
Enabled If you selected WebSphere MQ JMS Provider; otherwise, this field is disabled.
Data type String
Default The default value for the class path depends on the local WebSphere MQ installation:
For AIX
/usr/mqm/java/lib
For Solaris and HP-UX
/opt/mqm/java/lib
For Windows
c:\Program Files\ibm\WebSphere MQ\Java\lib
JMS user ID
Used to authenticate the connection to the JMS provider. This user ID must have administration rights for the messaging service.
Mandatory If you selected WebSphere JMS Provider; otherwise, this field is disabled.
Data type String
Restrictions If you are using embedded messaging, the JMS user ID must be less than or equal to 12 characters. For example, the default Windows NT user ID, Administrator, is not valid for use with WebSphere embedded messaging because the ID contains 13 characters.
Default The user ID you used to log into the administrative console.
For UNIX Use root. The user ID must be a member of the group mqm.
For Windows Use the default user ID. This user ID must be the same one used to start WebSphere Application Server.
JMS password
The password for the JMS user ID.
Mandatory If you selected WebSphere JMS Provider; otherwise, this field is disabled.
Data type String
Default None
Scheduler calendar
JNDI name of the UserCalendar scheduler for the business process container to use.
Mandatory No
Data type String
Default com/ibm/Websphere/scheduler/calendar/ DefaultUserCalendar
Security role mapping
The group from the domain user registry that is mapped onto the role of Business Process Administrator.
Mandatory   Yes
Data type String
Default
For UNIX and Linux
Depends on the local settings. AIX example: Administrator
For Windows
Administrators
Restrictions The user registry can be the local operating system, Lightweight Directory Access Protocol (LDAP), or custom registry. The user or group specified must already exist in the user registry being used.
JMS API user ID
The user ID that the process choreographer message-driven bean uses when processing asynchronous API calls.
Mandatory If WebSphere security is enabled (even if you do not use the Java Message Service API).
Data type String
Description If WebSphere security is enabled and you do not use the JMS API, you must specify a valid user ID. This ID does not need any special authorizations.

If WebSphere security is enabled and you plan to use the JMS API, this user ID must either be one that is given the appropriate authorities when the process is modeled, or more commonly, it must be a member of a group that was granted the necessary authorities during modeling. The possible staff authorities associated with processes are: Administrator, Reader, and Starter. For activities, a user ID can only perform the sendEvent action if it is a potential owner of the associated receiveEvent.

If you want to support all the actions on processes through the JMS API, you can specify a user ID that is a member of the J2EE BPESystemAdministrator role. However, in a production system, the more fine-grained security approach is recommended.

JMS API password
The password for the JMS API User ID.
Mandatory If WebSphere security is enabled (even if you do not use the JMS API)
Data type String
JMS resources (new or existing)
You must either create new JMS resources or select existing JMS resources.
Mandatory Yes
Data type Radio buttons
Choices
  • Create new JMS resources using default values.
  • Use existing JMS resources.
Default values for JMS resources:
Connection factory:
BPECF
Internal queue
BPEIntQueue
External request processing queue
BPEApiQueue
Hold queue
BPEHldQueue
Retention queue
BPERetQueue
Connection factory
The queue connection factory for the business process container to use.
Mandatory Only if you chose Select existing JMS resources
Data type Drop-down list
Default BPECF
Internal queue
The JNDI name of the queue for internal business process container messages.
Mandatory Only if you chose Select existing JMS resources
Data type Drop-down list
Default BPEIntQueue
External request processing queue
The JNDI name of the queue for external (JMS API) requests to the business process container.
Mandatory Only if you chose Select existing JMS resources
Data type Drop-down list
Default BPEApiQueue
Hold queue
The JNDI name of the queue that holds any messages that have failed processing more times than the retry limit.
Mandatory Only if you chose Select existing JMS resources
Data type Drop-down list
Default BPEHldQueue
Retention queue
The JNDI name of the queue that contains messages that temporarily cannot be processed, and that will be retried.
Mandatory Only if you chose Select existing JMS resources
Data type Drop-down list
Default BPERetQueue
Web client
If this check-box is selected, the process choreographer Web client is also installed.
Data type check-box
Default selected
URL http://hostname/bpe/webclient

Step 1 database configuration

XA data source
You must create a new data source that will only be used by process choreographer.
Mandatory Yes
Data type Drop-down list
Choices Create a new XA data source:
  • Cloudscape 5.1 (Cloudscape JDBC Provider (XA))
  • DB2 UDB 8.1 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA))
  • DB2 UDB 8.1 (DB2 Universal JDBC Driver Provider (XA))
  • DB2 z/OS 7 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA))
  • DB2 zOS 7 (DB2 Universal JDBC Driver Provider (XA))
  • DB2 UDB for iSeries (Native XA V5R2 and later)
  • DB2 UDB for iSeries (Toolbox XA)
  • Informix 9.3 & 9.4 (Informix JDBC Driver (XA))
  • Oracle 8i OCI (Oracle JDBC Driver (XA))
  • Oracle 8i thin (Oracle JDBC Driver (XA))
  • Oracle 9i OCI (Oracle JDBC Driver (XA))
  • Oracle 9i thin (Oracle JDBC Driver (XA))
  • SQL Server 2000 (DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA))
  • SQL Server 2000 (WebSphere embedded ConnectJDBC driver for MS SQL Server (XA))
  • Sybase 12.0 (Sybase JDBC Driver (XA))
  • Sybase 12.5 (Sybase JDBC Driver (XA))
Implementation class name
The Java class name of the Java Database Connectivity (JDBC) driver implementation.
Mandatory Yes
Data type String
Default for Cloudscape 5.1 (Cloudscape JDBC Provider (XA)) com.ibm.db2j.jdbc.DB2jXADataSource
Default for DB2 UDB 8.1 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA)) and for DB2 z/OS 7 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA)) COM.ibm.db2.jdbc.DB2XADataSource
Default for DB2 UDB 8.1 (DB2 Universal JDBC Driver Provider (XA)) and for DB2 z/OS 7 (DB2 Universal JDBC Driver Provider (XA)) com.ibm.db2.jcc.DB2XADataSource
Default for DB2 UDB for iSeries (Native XA V5R2 and later) com.ibm.db2.jdbc.app.UDBXADataSource
Default for DB2 UDB for iSeries (Toolbox XA) com.ibm.as400.access.AS400JDBCXADataSource
Default for Informix 9.3 & 9.4 (Informix JDBC Driver (XA)) com.informix.jdbcx.IfxXADataSource
Default for Oracle 8i OCI, 8i thin, 9i OCI, and 9i thin (Oracle JDBC Drivers (XA)) oracle.jdbc.xa.client.OracleXADataSource
Default for SQL Server 2000 (DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA)) com.ddtek.jdbcx.sequelink.SequeLinkDataSource
Default for SQL Server 2000 (WebSphere embedded ConnectJDBC driver for MS SQL Server (XA)) com.ibm.websphere.jdbcx.sqlserver. SQLServerDataSource
Default for Sybase 12.0 (Sybase JDBC Driver (XA)) and for Sybase 12.5 (Sybase JDBC Driver (XA)) com.sybase.jdbc2.jdbc.SybXADataSource
Classpath (data source)
The path to the Java archive (jar) or zip file that contains the JDBC driver. The JDBC driver provides the data source implementation class. If the database is remote, this is the path where the JDBC driver is installed on the client machine.
Mandatory
For Cloudscape
No, the JDBC driver is already on the WebSphere classpath.
For DB2 UDB, DB2 z/OS, Informix, Oracle, SQL Server, and Sybase
Yes
Data type String
Default for Cloudscape 5.1
${CLOUDSCAPE_JDBC_DRIVER_PATH}/db2j.jar
The value for ${CLOUDSCAPE_JDBC_DRIVER_PATH} is predefined and does not need to be set.
Default for DB2 UDB 8.1 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA)) and for DB2 z/OS 7 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA))
${DB2_JDBC_DRIVER_PATH}/db2java.zip
The value for ${DB2_JDBC_DRIVER_PATH} depends on the DB2 Client installation directory and must be set explicitly in Environment > Manage WebSphere Variables. Typical values are:
On Windows:
c:\Program Files\SQLLIB\java
On AIX and HP-UX:
/home/db2inst1/sqllib/java
On Solaris:
/export/home/db2inst1/sqllib/java
Default for DB2 UDB 8.1 (DB2 Universal JDBC Driver Provider (XA)) and for DB2 z/OS 7 (DB2 Universal JDBC Driver Provider (XA))
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/
               db2jcc.jar    
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/
               db2jcc_license_cu.jar   
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/
               db2jcc_license_cisuz.jar
The value for ${DB2UNIVERSAL_JDBC_DRIVER_PATH} depends on the installation root directory of the corresponding DB2 Client or DB2 Connect, and must be set in Environment> Manage WebSphere Variables. Typical values for ${DB2UNIVERSAL_JDBC_DRIVER_PATH} are:
On Windows:
c:\Program Files\SQLLIB\java
On AIX and HP-UX:
/home/db2inst1/sqllib/java
On Solaris:
/export/home/db2inst1/sqllib/java
Default for Informix 9.3 and 9.4
${INFORMIX_JDBC_DRIVER_PATH}/ifxjdbc.jar
${INFORMIX_JDBC_DRIVER_PATH}/ifxjdbcx.jar
The value for ${INFORMIX_JDBC_DRIVER_PATH} depends on the JDBC driver installation directory and must be set in Environment> Manage WebSphere Variables.
Default for Oracle 8i and Oracle 9i
${ORACLE_JDBC_DRIVER_PATH}/ojdbc14.jar
The value for ${ORACLE_JDBC_DRIVER_PATH} depends on the Oracle client installation or JDBC driver installation directory and must be set in Environment> Manage WebSphere Variables.
Default for SQL Server 2000 (DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA))
${WAS_LIBS_DIR}/sljc.jar
${WAS_LIBS_DIR}/spy-sl53.jar
The value for ${WAS_LIBS_DIR} depends on the WebSphere installation directory and must be set in Environment> Manage WebSphere Variables. Typical values are:
On Windows:
C:\Program Files\WebSphere\AppServer\lib
On UNIX:
/opt/WebSphere/AppServer/lib
Default for SQL Server 2000 (WebSphere embedded ConnectJDBC driver for MS SQL Server (XA))
${WAS_LIBS_DIR}/sqlserver.jar
${WAS_LIBS_DIR}/base.jar
${WAS_LIBS_DIR}/util.jar
${WAS_LIBS_DIR}/spy.jar
The value for ${WAS_LIBS_DIR} depends on the WebSphere installation directory and must be set in Environment> Manage WebSphere Variables. Typical values are:
On Windows:
C:\Program Files\WebSphere\AppServer\lib
On UNIX:
/opt/WebSphere/AppServer/lib
Default for Sybase 12.0 and Sybase 12.5
${SYBASE_JDBC_DRIVER_PATH}/jconn2.jar
The value for ${SYBASE_JDBC_DRIVER_PATH} depends on the Sybase JDBC driver installation directory and must be set in Environment> Manage WebSphere Variables. Typical values are:
On Windows:
C:\Program Files\Sybase\jConnect-5_5\classes
On UNIX:
/opt/sybase/jConnect-5_5/classes
Data source user name
A user ID that has the authority to connect to the database and to manipulate the data. If you want to have an automatic update of the database schema the user ID must have the authority to create tables and indexes in the database.
Mandatory
For Cloudscape
No
For DB2 UDB, DB2 iSeries, DB2 z/OS, Informix, Oracle, SQL Server, and Sybase
Yes
Data type String
Default The user ID that is currently logged on to the administrative console.
Data source password
The password for the data source user ID.
Mandatory
For Cloudscape
No
For DB2 UDB, DB2 z/OS, Informix, Oracle, SQL Server, and Sybase
Yes
Data type String
Default None
Custom properties
Extra parameters that are required by the database system.
Mandatory Yes
Data type String
Data format Multiple lines of Property=Value
Properties for Cloudscape
databaseName=
install_root/ProcessChoreographer/BPEDB. Required string. Defines which database to access. The value must be a fully qualified path.
shutdownDatabase=
Optional string. If set to shutdown, the database shuts down when a java.sql.Connection object is obtained from the data source. For example, if the data source is an XADataSource, a getXAConnection().getConnection() is necessary to cause the database to shut down.
dataSourceName=
Optional string. Name for the ConnectionPooledDataSource or XADataSource. Not used by the data source object. Used for information purposes only.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Not used by the data source object. Used for information purposes only.
connectionAttribute=
Optional string. Connection attributes specific to Cloudscape. Refer to the Cloudscape documentation for a complete list of attributes.
createDatabase=
Optional string. If set to create, and the database specified in the databaseName parameter does not already exist, the database will be created. The database is created when a connection object is obtained from the data source.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. This SQL statement is used for pre-test connection function. If pre-test connection is enabled in j2c.properties, this SQL statement will be executed to the connection to make sure the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
remoteDataSourceProtocol=
Optional string. If the database is remote and the data source accesses the database using a client, set this property to specify which client and server protocol to use. Currently, the only protocol value supported is rmi.
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Legacy CLI-based Type 2 JDBC Driver (XA))
databaseName=BPEDB
Required string. For DB2 UDB it defines which database to access. For DB2 z/OS it defines which subsystem contains the DB2 z/OS database.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Not used by the data source object. Used for information purposes only.
portNumber=
Optional integer. Specifies the TCP/IP port number where the JDBC provider resides.
connectionAttribute=cursorhold=0
Optional string. Connection attributes specific to DB2. Refer to the DB2 documentation for a complete list of connection attributes.
loginTimeout=0
Optional integer. If set to zero, no timeout takes place. Non-zero values specify the maximum number of seconds allowed to establish a connection to the database.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. If you enabled pre-test connection in the j2c.properties file, this pre-test string is used to make sure that the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will reduce performance because of the exception handling if table TABLE1 is not defined in the database. It is recommended to provide your own SQL statement to improve the performance.
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Universal JDBC Driver Provider (XA))
databaseName=BPEDB
Required string. For DB2 UDB it defines which database to access. For DB2 z/OS it defines which subsystem contains the DB2 z/OS database.
driverType=2
Required integer. The JDBC connectivity-type of a data source. The only permitted value is 2.
serverName=""
Optional string. The TCP/IP address or host name for the DRDA server.
portNumber=50000
Optional integer. The TCP/IP port number where the DRDA server resides.
enableSQLJ=false
Optional boolean. This value is used to indicate whether SQLJ operations may be performed with this data source. If enabled, this data source can be used for both JDBC and SQLJ calls. Otherwise, only JDBC usage is permitted.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Not used by the data source object. Used for information purposes only.
traceLevel=""
Optional integer. The DB2 trace level for logging to the logWriter or trace file. Possible trace levels are: TRACE_NONE = 0,TRACE_CONNECTION_CALLS = 1,TRACE_STATEMENT_CALLS = 2,TRACE_RESULT_SET_CALLS = 4,TRACE_DRIVER_CONFIGURATION = 16,TRACE_CONNECTS = 32,TRACE_DRDA_FLOWS = 64,TRACE_RESULT_SET_META_DATA = 128,TRACE_PARAMETER_META_DATA = 256,TRACE_DIAGNOSTICS = 512,TRACE_SQLJ = 1024,TRACE_ALL = -1, .
traceFile=""
Optional string. The trace file to store the trace output.
fullyMaterializeLobData=true
Optional boolean. This setting controls whether or not LOB locators are used to fetch LOB data. If enabled, LOB data is not streamed, but is fully materialized with locators when the user requests a stream on the LOB column. The default value is true.
resultSetHoldability=2
Optional integer. Determine whether ResultSets are closed or kept open when committing a transaction. The possible values are: 1 (HOLD_CURSORS_OVER_COMMIT), 2 (CLOSE_CURSORS_AT_COMMIT).
currentPackageSet=""
Optional string. This property is used in conjunction with the DB2Binder - collection option which is given when the JDBC/CLI packageset is bound during installation by the DBA.
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Universal JDBC Driver Provider (XA)) (continued)
readOnly=false
Optional boolean. This property creates a read only connection.
deferPrepares=false
Optional boolean. This property provides a performance directive that affects the internal semantics of the input data type conversion capability of the driver. If it is set to "true" the Universal driver defers 'internal prepare requests'. In this case, the driver works without the benefit of described parameter or result set metadata until execute time. So undescsribed input data is sent 'as is' to the server without any data type cross-conversation of the inputs.
currentSchema=""
Optional string. Identifies the default schema name used to qualify unqualified database object references where applicable in dynamically prepared SQL statements. Unless currentSchema is used, the default schema name is the authorization id of the current session user.
cliSchema=""
Optional string. Indicates the schema of the DB2 shadow catalog tables or views to search when you issue a database metadata catalog query.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
retrieveMessagesFromServerOnGetMessage=true
If set to true it directs all calls to the standard JDBC SQLException.getMessage() to invoke a server-side stored procedure which retrieves the readable message text for the error.
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Universal JDBC Driver Provider (XA)) (continued)
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. This SQL statement is used for pre-test connection function. If pre-test connection is enabled in j2c.properties, this SQL statement will be executed to the connection to make sure the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
enableSQLJ=false
Optional boolean. This SQL statement is used for pre-test connection function. If pre-test connection is enabled in j2c.properties, this SQL statement will be executed to the connection to make sure the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
Properties for Properties for Informix 9.3 & 9.4
databaseName=BPEDB
Required string. The name of the database.
serverName=""
Required string. The name of the Informix instance on the physical machine. There is no default for the string and therefore you need to set it explicitly.
portNumber=1526
Required integer. The TCP/IP port number of the Informix instance. The value "1526" is the default Informix port on Windows. On UNIX it is "61000".
ifxIFXHOST=hostname
Required string. The physical machine name of the server that hosts the informix database. "Localhost" does not work.
informixLockModeWait=2
Required integer. By default, Informix throws an exception when it cannot acquire a lock, rather than waiting for the current owner of the lock to release it. To modify this behavior, set this property to the number of seconds to wait for a lock. The default is 2 seconds. Any negative value means to wait forever.
informixAllowNewLine=false
Optional boolean. his property allows newLines to be added on a query String. Its disabled by default.
roleName=""
Optional string. The role name.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Not used by the data source object. Only used for information purposes.
loginTimeout=""
Optional integer. The maximum time to attempt to connect a database. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached.
dataSourceName=""
Optional string. The name of the data source. Only used for informational purposes.
ifxUSE_DTENV to ifxPSORT_DBTEMP
Optional string. The value for Informix specific variables. Please refer to the Informix documentation for possible values.
Properties for Properties for Informix 9.3 & 9.4 (continued)
enableMultithreadedAccessDetection=false
Optional boolean. Indicates whether or not to detect multithreaded access to a Connection and its corresponding Statements, ResultSets, and MetaDatas.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. This SQL statement is used for pre-test connection function. If pre-test connection is enabled in j2c.properties, this SQL statement will be executed to the connection to make sure the connection is good. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
Properties for Oracle 8i OCI & Oracle 9i OCI
driverType=oci8
Required string. Defines the type of the JDBC driver.
oraclelogPrintMask=62
Optional integer. The oraclelogPrintMask controls which information is printed with each trace message. Oracle9i requires the ojdbc14_g.jar file. The default is 62, which is ([OracleLog.FIELD_OBJECT for 9i / OracleLog.FIELD_CONN for 8i] 32 | OracleLog.FIELD_CATEGORY 16 | OracleLog.FIELD_SUBMOD 8 | OracleLog.FIELD_MODULE 4 | OracleLog.FIELD_TIME 2).

Possible values: OracleLog.FIELD_TIME 2, OracleLog.FIELD_MODULE 4, OracleLog.FIELD_SUBMOD 8, OracleLog.FIELD_CATEGORY 16, OracleLog.FIELD_OBJECT 32, OracleLog.FIELD_THREAD 64.

oraclelogModuleMask=1
Optional integer. The oraclelogModuleMask controls which modules write debug output. Oracle9i requires the ojdbc14_g.jar file. The default is 1, which is ( OracleLog.MODULE_DRIVER 1).

Possible values: OracleLog.MODULE_DRIVER 1, OracleLog.MODULE_DBACCESS 2.

oraclelogCategoryMask=47
Optional integer. The oraclelogCategoryMask controls which category to be output. Oracle9i requires the ojdbc14_g.jar file. The default is 47, which is ( OracleLog.USER_OPER 1 | OracleLog.PROG_ERROR 2 | OracleLog.ERROR 4 | OracleLog.WARNING 8 | OracleLog.DEBUG1 32).

Possible values: OracleLog.USER_OPER 1, OracleLog.PROG_ERROR 2, OracleLog.ERROR 4, OracleLog.WARNING 8, OracleLog.FUNCTION 16, OracleLog.DEBUG1 32, OracleLog.SQL_STR 128.

TNSEntryName=BPEDB
Required string. The entry name that is used in tnsnames.ora to identify the database.
networkProtocol=
Optional string. Specifies which protocol is used, for example, TCP/IP or IPC.
databaseName=BPEDB
Optional string. Defines which database to access.
serverName=
Optional string. The name of the server where the Oracle database resides.
portNumber=1521
Optional integer. The TCP/IP port number where the JDBC driver resides.
Properties for Oracle 8i OCI & Oracle 9i OCI (continued)
dataSourceName=
Optional string. The name of the datasource. Only used for informational purposes.
URL=jdbc:oracle:oci8:@BPEDB
Optional string. The URL specifies the database from which the data source obtains connections.
loginTimeout=""
Optional integer. The maximum time to attempt to connect the database. If set to zero, there will be no timeout. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Used for information purposes only.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
transactionBranchesLooselyCoupled=false
Optional boolean. This property is introduced as a result of Oraclebug 2511780. Oracle Patch for 2511780 must be installed before setting this property to true. Failure to install this patch causes a program error. Check the WebSphere readme file for more information.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. If you have enabled a pre-test connection in the j2c.properties file, this pre-test string is used to make sure that the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
Properties for Oracle 8i thin & Oracle 9i thin
driverType=thin
Required string. Defines the type of the JDBC driver.
oraclelogPrintMask=62
Optional integer. The oraclelogPrintMask controls which information is printed with each trace message. Oracle9i requires the use of ojdbc14_g.jar. Default is 62 which is ([OracleLog.FIELD_OBJECT for 9i / OracleLog.FIELD_CONN for 8i] 32 | OracleLog.FIELD_CATEGORY 16 | OracleLog.FIELD_SUBMOD 8 | OracleLog.FIELD_MODULE 4 | OracleLog.FIELD_TIME 2). Possible values: OracleLog.FIELD_TIME 2, OracleLog.FIELD_MODULE 4, OracleLog.FIELD_SUBMOD 8, OracleLog.FIELD_CATEGORY 16, OracleLog.FIELD_OBJECT 32, OracleLog.FIELD_THREAD 64.
oraclelogModuleMask=1
Optional integer. The oraclelogModuleMask controls which modules write debug output. Oracle9i requires the use of ojdbc14_g.jar. Default is 1 which is ( OracleLog.MODULE_DRIVER 1). Possible values (OracleLog.MODULE_DRIVER 1, OracleLog.MODULE_DBACCESS 2)"
oraclelogCategoryMask=47
Optional integer. The oraclelogCategoryMask controls which category to be output. Oracle9i requires the use of ojdbc14_g.jar. Default is 47 which is ( OracleLog.USER_OPER 1 | OracleLog.PROG_ERROR 2 | OracleLog.ERROR 4 | OracleLog.WARNING 8 | OracleLog.DEBUG1 32). Possible values (OracleLog.USER_OPER 1, OracleLog.PROG_ERROR 2, OracleLog.ERROR 4, OracleLog.WARNING 8, OracleLog.FUNCTION 16, OracleLog.DEBUG1 32, OracleLog.SQL_STR 128)"
TNSEntryName=""
Optional string. Not used for the thin JDBC driver.
networkProtocol=""
Optional string. Specifies which protocol is used, for example, TCP/IP or IPC.
databaseName=BPEDB
Required string. Defines which database to access.
serverName=hostname
Required string. The name of the server where the Oracle database resides
portNumber=1521
Required integer. The TCP/IP port number where the JDBC driver resides.
Properties for Oracle 8i thin & Oracle 9i thin (continued)
dataSourceName=""
Optional string. The name of the data source. Only used for informational purposes.
URL=jdbc:oracle:thin:@hostname:1521:BPEDB
Required string. The URL specifies the database and the database host from which the data source will obtain connections.
loginTimeout=""
Optional integer. The maximum time to attempt to connect the database. If set to zero, there will be no timeout. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached.
description=DataSource for Process Choreographer
Optional string. Description of the datasource. Only used for information purposes.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it will automatically detect multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
transactionBranchesLooselyCoupled=false
Optional boolean. This property is introduced as a result of Oraclebug 2511780, Oracle Patch for 2511780 must be installed before setting this property to true, failure to do that would cause a program error. Please check the WebSphere readme file for more info.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. If you have enabled pre-test connection in j2c.properties, this pre-test string is used to make sure that the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
Properties for SQL Server 2000 (DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA))
databaseName=BPEDB
Required string. The database name.
serverName=hostname
Required string. The TCP/IP address of the SequeLink server in dotted format or host name format.
portNumber=19996
Required integer. The TCP/IP port number where the jdbc driver resides.
spyAttributes=""
Optional string. The SPY attributes. See the ConnectJDBC documentation for a list of attributes.
loginTimeout=""
Optional integer. The maximum time to attempt to connect a database. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached.
description=DataSource for Process Choreographer
Optional string. The description of this datasource.
cipherSuites=""
Optional string. The Secure Socket Layer(SSL) cipher suites with which the SequeLink Java Client can use to connect. This property is required when networkProtocol=ssl.
blockFetchForUpdatee=1
Optional integer. When the isolation level is ReadCommitted and a SELECT FOR UPDATE statement is issued against some data stores, the SequeLink Java Client does not lock the expected row. Default is 1 which does not lock the expected row.
SLKStaticCursorLongColBuffLen=4
Optional integer. The amount of data (in KB) that is buffered for SQL_LONGVARCHAR and SQL_LONGVARBINARY columns which an insensitive result set.
certificateChecker=com.merant.sequelink.cert. CertificateCheckerInterface
Optional string. The fully qualified class name of a user-defined server certificate checker class.
serverDataSource=""
Optional string. A property that specifies a string to identify the server data source to be used for the connection. If unspecified, the configuration of the default server data source will be used for the connection.
enable2Phase=true
Optional boolean. When true, two phase connections are used. Do not change this value because this value is set for with this provider and is required by Process Choreographer.
applicationName=""
Optional string. Identifies the application that is establishing the Connections. When the application does not provide a value, the default value is SequeLink JDBC Application.
Properties for SQL Server 2000 (DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA)) (continued)
MSSMapLongToDecimal=""
Optional boolean. Enable client-side workarounds. Refer to the SequeLink Administrator's Guide.
ORANumber0IsNumeric=""
Optional boolean. Enable client-side work-arounds. Refer to the SequeLink Administrator's Guide.
enableMultithreadedAccessDetection=false
Optional boolean. Indicates whether or not to detect multithreaded access to a Connection and its corresponding Statements, ResultSets, and MetaDatas.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. This SQL statement is used for pre-test connection function. If pre-test connection is enabled in j2c.properties, this SQL statement will be executed to the connection to make sure the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
allowPrefetch=0
Optional integer. Enables the prefetch feature. When enabled, the JDBC driver requests a next set of rows from the server while the client is processing the previous set of rows. 0 = disable; 1 = enable.
insensitiveResultSetBufferSize=2058
Optional integer. The memory caching scheme for scroll-insensitive cursors. When set to 0, the driver uses a memory caching mechanism that does not use disk overflow. When set to a value greater than 0, data overflows to disk when the size of cached data exceeds the specified amount, specified in kilobytes. When set to a value less than 0, the data provider providers better performance. However, memory use may be affected.
Properties for SQL Server 2000 (WebSphere embedded ConnectJDBC driver for MS SQL Server (XA))
databaseName=BPEDB
Required string. Defines which database to access.
serverName
Required string. The TCP/IP address of the SequeLink server in dotted format or host name format.
portNumber=1433
Required integer. The TCP/IP port number where the Microsoft SQL Server resides.
selectMethod=
Optional string. Determine whether or not Microsoft SQL Server 'server cursors' are used for SQL queries. Values are 'cursor' or 'direct'. See the ConnectJDBC documentation for more information.
dataSourceName=
Optional string. Name for the data source. Only used for information purposes.
spyAttributes=
Optional string. The SPY attributes. See the ConnectJDBC documentation for a list of attributes.
loginTimeout=
Optional integer. The maximum time to attempt to connect a database. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached. Zero implies no time limit.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Not used by the data source object. Used for information purposes only.
enable2Phase=true
Required boolean. When true, two phase connections are used. Do not change this value because this value is set for with this provider and process choreographer requires two-phase connections.
maxPooledStatements=
Optional integer. The maximum number of pooled PreparedStatements for this connection.
sendStringParametersAsUnicode=""
Optional boolean. Determines whether string parameters are sent to the SQL Server database as Unicode or in the default character encoding of the database. For more information, refer to the ConnectJDBC documentation.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
Properties for SQL Server 2000 (WebSphere embedded ConnectJDBC driver for MS SQL Server (XA)) (continued)
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. If you enabled pre-test connection in the j2c.properties file, this pre-test string is used to make sure that the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.
codePageOverride=""
Optional string. Specifies the code page the driver uses when converting character data. See the ConnectJDBC documentation for more information.
insensitiveResultSetBufferSize=2048
Optional integer. Determines the amount of memory used by the driver to cache insensitive result set data. See the ConnectJDBC documentation for more information.
Properties for Sybase 12.0 & Sybase 12.5
databaseName=BPEDB
Required string. Defines which database to access.
serverName=hostname
Required string. The name of the server where the Sybase database resides.
portNumber=4100
Required integer. The TCP/IP port number where the JDBC driver resides.
networkProtocol=
Optional string. Specifies which protocol is used, for example, socket or SSL. When set to socket, Secure Sockets Layer (SSL) encryption is not used.
dataSourceName=
Optional string. Name for the data source. Used for information purposes only.
version=
Optional integer. The version number of the driver.
resourceManagerName=
Optional string. The name of the resource manager.
loginTimeout=
Optional integer. The maximum time to attempt to connect a database. If this value is non-zero, attempt to connect to the database will timeout when this specified value is reached. If set to zero, there will be no timeout.
description=DataSource for Process Choreographer
Optional string. Description of the data source. Used for information purposes only.
connectionProperties=SELECT_OPEN_CURSORS=true
Required string. Refer to the Sybase documentation for more information about SELECT_OPEN_CURSORS and other properties.
enableMultithreadedAccessDetection=false
Optional boolean. If set to true, it automatically detects multithreaded access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
preTestSQLString=SELECT 1 FROM TABLE1
Optional string. If you enabled pre-test connection in the j2c.properties file, this pre-test string is used to make sure that the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will be used at runtime. This will slow down the execution because of the exception handling if table TABLE1 is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance.

Step 2 JMS provider and security

JMS provider
Specifies which messaging service the business process container uses.
Mandatory Yes
Data type Drop-down list
Choices
For external WebSphere MQ
WebSphere MQ JMS Provider
For the messaging embedded in WebSphere
WebSphere JMS Provider
Queue manager
The name of the queue manager that is used by the business process container.
Mandatory If you selected WebSphere MQ JMS Provider; otherwise, this field is disabled.
Data type String
Value Your queue manager name, for example, WAS_nodeName_serverName.
Classpath (JMS provider)
The path to the MQ Java lib directory.
Mandatory If you have not defined the WebSphere environment variable ${MQ_INSTALL_ROOT} to point to the WebSphere MQ installation root directory.
Enabled If you selected WebSphere MQ JMS Provider; otherwise, this field is disabled.
Data type String
Default The default value for the class path depends on the local WebSphere MQ installation:
For AIX
/usr/mqm/java/lib
For Solaris and HP-UX
/opt/mqm/java/lib
For Windows
c:\Program Files\ibm\WebSphere MQ\Java\lib
JMS user ID
Used to authenticate the connection to the JMS provider. This user ID must have administration rights for the messaging service.
Mandatory If you selected WebSphere JMS Provider; otherwise, this field is disabled.
Data type String
Restrictions If you are using embedded messaging, the JMS user ID must be less than or equal to 12 characters. For example, the default Windows NT user ID, Administrator, is not valid for use with WebSphere embedded messaging because the ID contains 13 characters.
Default The user ID you used to log into the administrative console.
For UNIX Use root. The user ID must be a member of the group mqm.
For Windows Use the default user ID. This user ID must be the same one used to start WebSphere Application Server.
JMS password
The password for the JMS user ID.
Mandatory If you selected WebSphere JMS Provider; otherwise, this field is disabled.
Data type String
Default None
Scheduler calendar
JNDI name of the UserCalendar scheduler for the business process container to use.
Mandatory No
Data type String
Default com/ibm/Websphere/scheduler/calendar/ DefaultUserCalendar
Security role mapping
The group from the domain user registry that is mapped onto the role of Business Process Administrator.
Mandatory   Yes
Data type String
Default
For UNIX and Linux
Depends on the local settings. AIX example: Administrator
For Windows
Administrators
Restrictions The user registry can be the local operating system, Lightweight Directory Access Protocol (LDAP), or custom registry. The user or group specified must already exist in the user registry being used.
JMS API user ID
The user ID that the process choreographer message-driven bean uses when processing asynchronous API calls.
Mandatory If WebSphere security is enabled (even if you do not use the Java Message Service API).
Data type String
Description If WebSphere security is enabled and you do not use the JMS API, you must specify a valid user ID. This ID does not need any special authorizations.

If WebSphere security is enabled and you plan to use the JMS API, this user ID must either be one that is given the appropriate authorities when the process is modeled, or more commonly, it must be a member of a group that was granted the necessary authorities during modeling. The possible staff authorities associated with processes are: Administrator, Reader, and Starter. For activities, a user ID can only perform the sendEvent action if it is a potential owner of the associated receiveEvent.

If you want to support all the actions on processes through the JMS API, you can specify a user ID that is a member of the J2EE BPESystemAdministrator role. However, in a production system, the more fine-grained security approach is recommended.

JMS API password
The password for the JMS API User ID.
Mandatory If WebSphere security is enabled (even if you do not use the JMS API)
Data type String

Step 3 JMS resources

JMS resources (new or existing)
You must either create new JMS resources or select existing JMS resources.
Mandatory Yes
Data type Radio buttons
Choices
  • Create new JMS resources using default values.
  • Use existing JMS resources.
Default values for JMS resources:
Connection factory:
BPECF
Internal queue
BPEIntQueue
External request processing queue
BPEApiQueue
Hold queue
BPEHldQueue
Retention queue
BPERetQueue
Connection factory
The queue connection factory for the business process container to use.
Mandatory Only if you chose Select existing JMS resources
Data type Drop-down list
Default BPECF
Internal queue
The JNDI name of the queue for internal business process container messages.
Mandatory Only if you chose Select existing JMS resources
Data type Drop-down list
Default BPEIntQueue
External request processing queue
The JNDI name of the queue for external (JMS API) requests to the business process container.
Mandatory Only if you chose Select existing JMS resources
Data type Drop-down list
Default BPEApiQueue
Hold queue
The JNDI name of the queue that holds any messages that have failed processing more times than the retry limit.
Mandatory Only if you chose Select existing JMS resources
Data type Drop-down list
Default BPEHldQueue
Retention queue
The JNDI name of the queue that contains messages that temporarily cannot be processed, and that will be retried.
Mandatory Only if you chose Select existing JMS resources
Data type Drop-down list
Default BPERetQueue
Web client
If this check-box is selected, the process choreographer Web client is also installed.
Data type check-box
Default selected
URL http://hostname/bpe/webclient

Related reference
Administrative console buttons



Searchable topic ID:   ueac_flowcontainerwizardsettings
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/webui_pme/ui/ueac_flowcontainerwizardsettings.html

Library | Support | Terms of Use | Feedback