Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# ActiveSpaces Properties

The ActiveSpaces JDBC Driver invokes the ActiveSpaces Java API. The ActiveSpaces Java API provides several API methods where properties can be specified. This API enables you to connect to the data grid or affect its behavior. However, in the JDBC driver you can only specify properties when you first connect to the data grid. Therefore, any properties that must be applied to Statements should also be specified in the set of properties used to connect to the data grid. When the JDBC API offers a method to set a value that can also be set using a property, the JDBC API's setting takes precedence.

The following partial list describes the most frequently used connection properties that can be specified.

Property | Description | Default Value
--- | --- | ---
`com.tibco.tibdg.gridname` | Name of the data grid | `_default`
`com.tibco.tibdg.realmurl` | Realm Service URL. The Realm Service URLs use the pipe character (|) as a separator to provide a list of URLs. | `http://localhost:8080`
`com.tibco.tibdg.connectwaittime` | The amount of time to wait for a connection to be established. | `0.1 seconds`
`com.tibco.tibdg.timeout` | The amount of time to wait for responses from the data grid. | `5.0 seconds`

When specifying properties as part of the JDBC URL, the full property name or the property name without the `com.tibco.tibdg` prefix can be used. For example:

    jdbc:tibco:tibdg:_default;com.tibco.tibdg.realmurl=http://localhost:8080

The following tables explain the Connection, Session, and Statement properties that you can include when connecting to the data grid.

Connection Property | Description | Default Value
--- | --- | ---
`com.tibco.tibdg.clientlabel` | Use the specified name to allow easier monitoring and management of the client process. | A string containing the grid name, client instance ID, and ActiveSpaces version.
`com.tibco.tibdg.connectbindstrategy` | Specifies how a client must establish a proxy connection. 0=choose a proxy at random 1=choose a proxy from the proxies listed in the `com.tibco.tibdg.connectproxynames` property 2=choose the proxy with the lowest load from the proxy responses received. This is the balanced bind strategy. | 0
`com.tibco.tibdg.connectnumresponses` | Specifies the number of responses to receive from proxies before the client stops looking for proxy responses. Only used when `com.tibco.tibdg.connectbindstrategy` has been set to 0 (random) or 2 (balanced) | 2147483647
`com.tibco.tibdg.connectproxynames` | A pipe '|' delimited list of proxy names for `com.tibco.tibdg.connectbindstrategy` | None
`com.tibco.tibdg.realmconnectretries` | Specifies the number of times the underlying TIBCO FTL client library attempts to connect to the Realm. | 5
`com.tibco.tibdg.tporttype` | Specifies the type of FTL transport that the client uses to connect to proxies. 0=DTCP 1=AUTO | Connection type is determined by the grid configuration.
`com.tibco.tibdg.trust.file` | Specifies the given file must be used to verify the realm server's certificate when `com.tibco.tibdg.trust.type` is set to `trust_file` | None
`com.tibco.tibdg.trust.type` | Specifies the type of "trust" to use when connecting to the realm server. `trust_file`=Use the trust file specified in the `com.tibco.tibdg.trust.file` property to verify the realm server's certificate. `trust_everyone`=The application trusts any realm server without verifying the trust in the realm server's certificate. Use for development only. | None
`com.tibco.tibdg.username` | Specifies the username to use when connecting to a secure realm server. | None
`com.tibco.tibdg.userpassword` | Specifies the password to use when connecting to a secure realm server. | None

Session Property | Description | Default
--- | --- | ---
`com.tibco.tibdg.checkpointname` | Use the specified checkpoint as the data source for this session's read operations. | None
`com.tibco.tibdg.immutablerows` | Specifies whether rows returned in ResultSets are immutable. true=rows cannot be modified false=rows can be modified | false

Statement Property | Description | Default
--- | --- | ---
`com.tibco.tibdg.statement.consistency` | When running queries, determines whether to wait for any previous transactions to be committed. Possible string values: global_snapshot, snapshot | global_snapshot - waits for writes to be committed
`com.tibco.tibdg.statement.prefetch` | Specifies the maximum number of rows prefetched from the data grid when running a query. Calling `Statement.setFetchSize()` overrides this property setting for the statement. It defines the number of result rows to return to the client at a time for a query being run. | 256
`com.tibco.tibdg.statement.fetch.timeout` | Specifies how long (in seconds) the application waits for the next batch of query result rows before timing out. Calling `Statement.setQueryTimeout()` overrides this property and the `com.tibco.tibdg.statement.update.timeout` property for the statement. | If this property is not provided, the current timeout for the parent Connection is used.
`com.tibco.tibdg.statement.update.timeout` | Specifies how long (in seconds) the application waits for a reply to an ExecuteUpdate request, on a statement, before timing out. Calling `Statement.setQueryTimeout()` overrides this property and the `com.tibco.tibdg.statement.fetch.timeout` property for the statement. | If this property is not supplied, the current timeout for the parent Connection is used.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

Copyright © 2009-2025. Cloud Software Group, Inc. All Rights Reserved.