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:
Default: Direct |
Direct
Property | Required? | Editable? | Accept SVars? | Description |
---|---|---|---|---|
Database Driver | Y | Y | Y | The name of the JDBC driver class. You can select
from a dropdown list of supported drivers or type
the name of a custom driver:
Additional drivers available when using TIBCO Business Studio - BPM Edition :
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:
Available when using TIBCO Business Studio - BPM Edition
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:
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 clear, the application does not demarcate transaction boundaries and all SQL statements are auto committed.
If selected, the application demarcates transaction boundaries. Default: clear. |
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:
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 nonsuperusers, 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. |
SSL
GUI | Editable? | Required? | Accepts SVars? | Description |
---|---|---|---|---|
Enable SSL | N | N | N | Enable SSL connections. When selected, the SSL properties display.
Default: Unchecked. |
SSL Client Provider | N | Y | Y | The name of an SSL Client Provider resource instance. |
Configure SSL | N | N | N | (Administrator only) Invokes a wizard to import certificates from an SSL-enabled server, optionally create an SSL Client Provider resource instance, and configure the trust store of the newly created or an existing SSL Client Provider with the imported certificates. When you complete the wizard, the SSL Client Provider field is filled in. |
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 waits 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? | Accept 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 database driver. The properties are vendor specific. |