...
The configuration involves:
Table of Contents | ||
---|---|---|
|
Info | ||
---|---|---|
| ||
When using stored procedures in TIBCO BusinessWorks with the deprecated DataDirect driver, an additional system property may be needed if there are activities that are configured with both a Schema and a Catalog/Package name. See Additional Properties When Using the TIBCO DataDirect JDBC Driver for details. |
...
Place ParasoftJDBCDriver.jar
under [TIBCO BW Install Dir]<TIBCO-BW-INSTALL-DIR>/tra/5.7/lib
. This location applies to both TIBCO Designer and TIBCO the TIBCO BW Engine.
...
Configuring Java System Properties
Open [TIBCO BW Install Dir]<TIBCO-BW-INSTALL-DIR>/designer/5.7/bin/designer.tra
and add the Parasoft JDBC Driver system properties prefixed with “java.
”, for example:
Code Block |
---|
# Parasoft JDBC Driver properties java.property.parasoft.virtualize.server.url http://virtualizeHostName:9080 java.property.parasoft.virtualize.group.id TIBCO_Designer_on_MyProcess java.property.parasoft.virtualize.driver.proxy.direct false java.property.parasoft.virtualize.driver.register.jdbcproxydriver.in.drivermanager true |
...
TIBCO BusinessWorks versions earlier than 5.7 included DataDirect JDBC drivers with the package tibcosoftwarein.jdbc.*.
These drivers have been deprecated by TIBCO in favor of using database vendor drivers: https://docs.tibco.com/pub/activematrix_businessworks/5.9.3_march_2012/TIB_BW_5.9.3_relnotes.pdf
.
If you are using stored procedures in TIBCO BusinessWorks with the DataDirect driver—and driver, and if there are activities that are configured with both a Schema and a Catalog/Package name—an name, an additional system property may be needed if there activities that are configured with both a Schema and a Catalog/Package name.
In some cases, the Parasoft JDBC Driver Driver will be passed calls like {call Schema.Package.Procedure(?)}
which will fail with a SQLException about the stored procedure not being found. This a result of a difference in how TIBCO treats the Parasoft JDBC Driver versus the DataDirect driver.
The remedy is to remove either Schema or Package, or Package—or both. The specifics vary based on environment. To indicate which to remove, use the parasoft.virtualize.driver.procedure.prefix
system property. Available settings are:
Value | Action |
---|---|
0 | Does nothing to the original query. This is the default value. |
1 | Removes Schema {call Package.Procedure(?)} |
2 | Removes the Catalog/Package {call Schema.Procedure(?)} |
3 | Removes both {call Procedure(?)} |
Here is an example property setting in designer.tra:Java. parasoft.virtualize.driver.procedure.prefix 2
...
You can either create a new JDBC connection, which uses the Parasoft JDBC Driver, or alter an existing one (already referenced by existing processes) to use the Parasoft JDBC Driver. The first option would require that processes you want to virtualize are adjusted to use the new JDBC connection.
In either case, it is recommended that you provide the JDBC Driver and Database URL values as global variables so the values can be adjusted in TIBCO Administrator without rebuilding the process archive every time a change is made to these fields.
If you click the Test Connection button in the JDBC Connection form, you should see a dialog with database information; this confirms that everything was configured successfully. For example:
Configuring the Process
If a new shared JDBC connection was created, then processes that use it need to be changed to use that new connection.
Testing the Process
Processes configured with the Parasoft JDBC Driver can be tested directly in TIBCO Designer before they are deployed. Use TIBCO Designer Tester to launch the process on a test engine:
At this point, when you invoke the process, the related JDBC Controller should appear in the Virtualize Server view. You can control the Parasoft JDBC Driver mode from the Virtualize Server view while that process is running in Tester.
...
This step needs to be performed at least once so that the Parasoft JDBC Driver properties get applied in the process. The initial building steps ensure that the properties are available to configure in Administrator. The property values can be changed later without rebuilding the archive using TIBCO Administrator.
Configuring TIBCO Administrator
To configure TIBCO Administrator:
- Deploy the process.
- Specify the desired values for the properties under the application Configuration/Advanced section.
- Start the process.
Once the process is invoked and the JDBC connection is established, the related JDBC Controller should show in the Virtualize Server view. From this point forward, you can control it from the Virtualize Server view (or from Environment Manager).