JDBC

The JDBC resource template represents a JDBC connection that is used by component implementations to access databases.

General
Field Editable? Accept SVars? Description

Connection Type

(Required)

 N N

The type of the JDBC connection:

  • Direct: The connection to the database is through a vendor-specific driver. When selected, the Database Driver and Database URL fields are displayed.

  • XA: The connection to the database is through a vendor-specific data source. When selected, the Data Source field is displayed. A component implementation that uses a JDBC connection of connection type XA typically executes within a global transaction and consequently may not explicitly commit transactions. To ensure that such implementations always behave correctly, the TIBCO ActiveMatrix platform detects when such a resource is used outside of a global transaction and enables the JDBC autocommit feature, so that all database access by the component is committed.

    Default Login Timeout: 60000 ms (60s)

Default: Direct
Direct
Field Editable? Accepts SVars? Description

Database Driver

(Required)

 Y Y

The name of the JDBC driver class.

Select from a drop-down list of supported drivers or type the name of a custom driver:

  • org.hsqldb.jdbcDriver
  • com.microsoft.sqlserver.jdbc.SQLServerDriver
  • com.mysql.jdbc.Driver
  • oracle.jdbc.OracleDriver
  • com.ibm.db2.jcc.DB2Driver
  • org.postgresql.Driver

Additional drivers available when using TIBCO Business Studio:

  • com.ibm.as400.access.AS400JDBCDriver
  • com.informix.jdbc.lfxDriver
  • ca.edbc.jdbc.EdbcDriver

When you select a driver, the Database URL field is populated with a template for the URL of the driver.

Default:org.hsqldb.jdbcDriver

Database URL

(Required)

 Y Y

The URL to connect to the database.

Format of the URL is supplied for the driver defined in the Database Driver field or you can type the name of a URL:

  • jdbc:hsqldb:hsql://localhost:<port>/<db_instancename>
  • jdbc:sqlserver://<server Name>:<port>;databaseName=<dbname>;
  • jdbc:mysql://<localhost>:<port>/<DBName>
  • jdbc:oracle:thin:@<machine_name>:<port>:<instance_name>
  • jdbc:db2://<host>:<port default is 50000>/<database name>
  • jdbc:postgresql://<servername>:<port>/<dbname>

Available when using TIBCO Business Studio:

  • jdbc:as400://server<server_ip>;libraries=<lib>
  • jdbc:informix-sqli://<host>:<port >/<database>:informixserver=<server>
  • jdbc:edbc://<host>:<port>/<database>

Default: jdbc:hsqldb:hsql://localhost:<port>/<db_instance name>
XA
Field Editable? Accept SVars? Description

Data Source

(Required)

 

 Y Y

The fully qualified name of the javax.sql.XADataSourceimplementation class.

The supported classes are:

  • com.ibm.db2.jcc.DB2XADataSource
  • com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
  • oracle.jdbc.xa.client.OracleXADataSource
  • com.microsoft.sqlserver.jdbc.SQLServerXADataSource
  • org.postgresql.xa.PGXADataSource

Default:oracle.jdbc.xa.client.OracleXADataSource
Field Editable? Accepts SVars? Description

Maximum Connections

(Optional)

 Y Y The maximum number of database connections to allocate. The minimum value that can be specified is 0.

Default: 10

Login Timeout

(in ms)

(Optional)

 Y Y

Time to wait for a successful database connection.

If the JDBC driver does not support connection timeouts, the value of this field is ignored. Only JDBC drivers that support connection timeouts use this configuration field. Most JDBC drivers support connection timeouts.

Default: 60000 (60 seconds)

Supports Transactions

(Optional)

 Y Y

Indicates whether the application demarcates transaction boundaries.

  • If not selected, the application does not demarcate transaction boundaries and all SQL statements are autocommitted.

  • If selected, the application demarcates transaction boundaries.

Default: Unchecked
Login Credentials
Field Editable? Accepts SVars? Description

Login Credentials

(Required)

 Y N

Indicates how the credentials required to authenticate to a server are provided:

  • Identity Provider: Provide user name and password credentials encapsulated in an identity provider resource. When selected, the Identity Provider field is activated.
  • User name + Password: Provide inline user name and password credentials. When selected, the Username and Password fields are activated.

Default: Identity Provider

Identity Provider

(Optional)

 Y Y Name of the Identity Provider resource used to authenticate the user.

Username

(Required)

 Y N User name used to authenticate connections to the server.

Password

(Required)

 Y N

User's password used to authenticate connections to the server.

Note: If you try to update the existing encrypted password then the existing password will be removed. You can add a new password.
SSL
GUI Editable? Accepts SVars? Description

Enable SSL

(Optional)

 N N Enables SSL connections. When selected, the SSL properties are displayed.

Default: Unchecked

SSL Client Provider

(Required)

 N Y The name of an SSL Client Provider resource.
Advanced
GUI Editable? Accepts SVars? Description

Host Type Properties

(Optional)

 Y N Properties to configure the connection between the JDBC resource and a specific type of host.

Commit Before Auto Commit

(Optional)

 Y N Indicates whether the driver requires a commit to be performed before enabling auto-commit on a connection. This must be (and is, by default) set to false for compliant drivers to avoid extraneous commits to the database.

Default: false

Exception Sorter Class

(Optional)

 Y N

The class used by the resource adapter to judge if an exception is fatal to the connection. That is, whether the connection pool should discard the connection from the pool, since it is no longer reusable.

As the name implies, the default SQLState08ExceptionsAreFatalSorter treats SQL State 8 exceptions as fatal (connection errors). All other exceptions do not result in any connection pool action (but are passed up to the application for it to react). The class must implement org.tranql.connector.ExceptionSorter.

Default:com.tibco.amf.sharedresource.
runtime.tibcohost.jdbc.
SQLState08ExceptionsAreFatalSorter

POOL_MIN_SIZE

(Optional)

 Y N Minimum number of connections in the pool.

Default: 5

POOL_BLOCKING_TIMEOUT (in ms)

(Optional)

 Y N Time for which a requestor waits for a connection when the pool is at maximum.

Default: 60000 ms

POOL_IDLE_TIMEOUT (in min)

(Optional)

 Y N Time after which idle connections are closed.

Default: 5 min

Prepared Statement Cache Size

(Optional)

 Y N The size of the cache containing prepared statements. The size must correspond to the number of JDBC statements you expect your application to reuse.

Default: 0 (that is, the cache is disabled)
Direct
Field Editable? Accepts SVars? Description

Connection Properties

(Optional)

 Y N Properties to configure connections to a database driver. The properties are vendor specific.
XA
Field Editable? Accept SVars? Description

Connection Properties

(Optional)

 Y N Properties to configure connections to a data source. The properties are vendor specific.