Open topic with navigation

TIBCO ActiveMatrix® Service Grid - Container Edition 1.0.0

# 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.

Copyright © 2020-2021. TIBCO Software Inc. All Rights Reserved.