JDBC

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

General

Property Required? Editable? Accept SVars? Description
Connection Type Y 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 display.
  • XA The connection to the database is through a vendor-specific data source. When selected, the Data Source field displays. 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
Property Required? Editable? Accepts SVars? Description
Database Driver Y Y Y The name of the JDBC driver class. You can 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 Y Y Y The URL to use to connect to the database. A template of the URL is supplied for the driver you select 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>:<portNumber>;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>:<portnumber>/<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>

You must supply the portions of the URL shown between angle brackets and remove the angle brackets.

Default: jdbc:hsqldb:hsql://localhost:<port#>/<db_instance name>.

XA
Property Required? Editable? Accept SVars? Description
Data Source Y Y Y The fully-qualified name of the javax.sql.XADataSource implementation 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

Property Required? Editable? Accepts SVars? Description
Maximum Connections N Y Y The maximum number of database connections to allocate. The minimum value that can be specified is 0.

Default: 10.

Login Timeout (ms) N 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 N Y Y Indicate whether the application demarcates transaction boundaries. If unchecked, the application does not demarcate transaction boundaries and all SQL statements are autocommitted.

If checked, the application demarcates transaction boundaries.

Default: Unchecked.

Login Credentials

Property Required? Editable? Accepts SVars? Description
Login Credentials Y Y N Indicate how the credentials required to authenticate to a server are provided:
  • Identity Provider - Provide username and password credentials encapsulated in an identity provider resource. When selected, the Identity Provider field is activated.
  • Username + Password - Provide inline username and password credentials. When selected, the Username and Password fields are activated.

Default: Identity Provider

Identity Provider N Y N Name of the Identity Provider resource used to authenticate the user.
Username N Y N Username used to authenticate connections to the server.
Password N Y N User's password used to authenticate connections to the server.

(Administrator only) For superusers, passwords display encrypted. For non-superusers, the password doesn't display even if it was set when it was created. If you have permission to edit the password, you can specify a new value and save. If you edit other fields, the old value for the password field is retained. If you want to set an empty value as password, click the link Set Blank Password.

Advanced

GUI Editable? Required? Accepts SVars? Description
Host Type Properties Y N N Properties to configure the connection between the JDBC resource and a specific type of host.
commitBeforeAutocommit Y N N Indicates whether the driver requires a commit to be performed before enabling auto-commit on a connection. This should be (and is, by default) set to false for compliant drivers to avoid extraneous commits to the database.

Default: false.

exceptionSorterClass Y N 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 of course are passed up to the application for it to react as it wishes). The class must implement org.tranql.connector.ExceptionSorter.

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

POOL_MIN_SIZE Y N N Minimum number of connections in the pool.

Default: 5.

POOL_BLOCKING_TIMEOUT (ms) Y N N The length of time a requestor will wait for a connection when the pool is at maximum.

Default: 60000 ms.

POOL_IDLE_TIMEOUT (min) Y N N The length of time after which idle connections are closed.

Default: 5 min.

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

Default: 0; that is, the cache is disabled.

Direct
Property Required? Editable? Accepts SVars? Description
Connection Properties N Y N Properties to configure connections to a database driver. The properties are vendor specific.
XA
Property Required? Editable? Accept SVars? Description
Connection Properties N Y N Properties to configure connections to a data source. The properties are vendor specific.