![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
To add and configure a new database connection, expand BusinessConnect > System Settings > Audit, Non-Repudiation and Runtime Database Configuration, and enter information as explained in Table 6.
Click Add to show the New Database Connection dialog. Note: After making any configuration changes to the database used for the configuration stores, redeploy the TIBCO BusinessConnect application. You can request that TIBCO BusinessConnect not only log information about the transaction state but also include the actual message in the log. To include the message, select the Include Message in Log check box under BusinessConnect > System Settings > Audit, Non-Repudiation and Runtime Database Configuration. The message is included in all entries where that is possible now.Note: If you change the value of the Include Message in Log check box, you must restart the TIBCO BusinessConnect server to pick up the change. Select from the list to manage any of the following: bc-db (the initial database connection), None, or any other configured database connection. First select from the Target Table Type list, and then either export the database table schemas, or drop and recreate them. Select from the Target Table Type list: Click Export to perform the following operations:
• Export Audit Schema Select Audit Log in the Target Table Type list, and then click Export to export the Audit Schema, such as audit.sql.
• Export NR Schema Select Non-Repudiation Log in the Target Table Type list, and then click Export to export the non-repudiation schema, such as nr.sql.
• Export Runtime Schema Select Runtime Data Store in the Target Table Type list, and then click Export to export the Runtime schema, such as runtime.sql. Click Create to perform the following operations:
• Create Audit Tables Select Audit Log in the Target Table Type list, and then click Create to drop all Audit tables and recreate them. During this process all existing Audit data is lost.
• Create NR Tables Select Non-Repudiation Log in the Target Table Type list, and then click Create to drop all Non-repudiation tables and recreate them. During this process all existing Non-repudiation data is lost.
• Create Runtime Tables Select Runtime Data Store in the Target Table Type list, and then click Create to drop all Runtime tables and recreate them. During this process all existing Runtime data is lost.
Table 7 Editing Database Connection
• Note: To learn about Oracle client library path, see Oracle Client Library Path Usage. The URL for the database. TIBCO BusinessConnect console pre-fills this field with a URL template formatted correctly for the driver you selected. You have to replace the variables with actual values. Edit the value in the JDBC URL field, providing the correct URL for the database. Note: For better performance, database pool size for audit logging should be at least the same as the number of the TIBCO ActiveMatrix BusinessWorks engine threads configured for deployment. Click Test Connection.If the test was successful, a message is displayed: Connected Successfully.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |