JDBC Connection String Formats

The JDBC connection string that you specify in the Create TIBCO ActiveMatrix BPM Server wizard or the Edit TIBCO ActiveMatrix BPM Instance wizard must have a specific format depending on the database type.

DB2

jdbc:db2://host:port/dbName

Microsoft SQL Server

jdbc:sqlserver://host:port;DatabaseName=dbName

You cannot use a literal IPV6 address for host.

Oracle 11g

jdbc:oracle:thin:@host:port:instance

Oracle 12c

You must use one of the following formats:

  • jdbc:oracle:thin:@host:port/serviceName
  • jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST="host")(PORT="port")))(CONNECT_DATA=(SERVICE_NAME="serviceName")(SERVER = DEDICATED)))

where serviceName is the service name of the pluggable database that ActiveMatrix BPM is using.