...
Load the profile and navigate to FES > Esb > Sbw > SBWManager. The Properties of SBWManager dialog box on the right displays all the database properties along with their default values.
Note Property values are editable only for inactive profile nodes. To edit an active profile (a running server), stop the server so that the values become editable.
Tip Refer to the SBW Database Property descriptions for descriptions of the SBW database properties.
Select the required database from the Database Name property drop-down and modify values of other properties too accordingly.
- Click the Save button or press CTRL+S to save the profile changes.
...
SBW Database Property descriptions
| Database Name | JDBC Driver | JDBC Connection URL | JDBC Login Name | JDBC Password | JDBC Properties | ||
| H2 | org.h2.Driver | jdbc:h2:ESB_DEFAULT_DB_DIR/doctracking_db/sbw | h2_jdbc.cfg | ||||
| Oracle | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:<ip-address>:<port>:<databaseName> | oracle8_jdbc.cfg | ||||
| IBM DB2 | sun.jdbc.odbc.JdbcOdbcDriver | jdbc:odbc:sample | db2_jdbc.cfg | ||||
| MS Access | sun.jdbc.odbc.JdbcOdbcDriver | jdbc:odbc:Driver={Driver do Microsoft Access (*.mdb)};DBQ=D:\\tif\\bin\\sp\\sbw.mdb | msaccess_jdb.cfg | ||||
| HSQL | org.hsqldb.jdbcDriver | jdbc:hsqldb:ESB_DEFAULT_DB_DIR/doctracking_db/sbw | hsql_jdbc.cfg | ||||
| MS SQL 2000 | com.microsoft.jdbc.sqlserver.SQLServerDriver | jdbc:microsoft:sqlserver://<ip-address>:<port>;SelectMethod=Cursor | mssql_jdbc.cfg | ||||
MS SQL 2005 or later | com.microsoft.sqlserver.jdbc.SQLServerDriver | jdbc:sqlserver://<ip-address>:<port>;databaseName=<databaseName>;SelectMethod=Cursor | |||||
| MySQL |
|
| mysql_jdbc.cfg | ||||
| Sybase | com.sybase.jdbc2.jdbc.SybDriver | jdbc:sybase:Tds:<ip-address>:<port>/<databaseName> | sybase_jdbc.cfg | ||||
| Apache Derby | org.apache.derby.jdbc.EmbeddedDriver | jdbc:derby:ESB_DEFAULT_DB_DIR/doctracking_db/sbw;create=true
| derby_jdbc.cfg | ||||
| Postgre SQL | org.postgresql.Driver | jdbc:postgresql://<ip-address>:<port>/<databasename> | pgsql_jdbc.cfg |
Descriptions of common properties are listed below:
| Properties | Descriptions | Default Value | ||
| Scheme Name | By default, the schema name will be %, i.e., all schemas are searched.
| % | ||
| Catalog Name | By default, the catalog name will be %, all catalogs.
| % | ||
| Max Rows To Fetch | Maximum No Of Rows to Fetch. | 200 | ||
| Max Rows To Return | Maximum No Of Rows to Return. | 1000 | ||
| Auto Reconnect | Boolean to specify whether SP should try for reconnection with DB automatically. | Enable/Disable | ||
| Try Reconnect Interval | Interval (in secs) after which SP tries to reconnect with DB in case of a break in connection. | 5 | ||
| Insert Thread Count | Number of threads used for inserting SBW data into the database. | 1 | ||
| Support Master Table | Enable if backward compatibility with earlier SBW schema (1001) is required. | Enable/Disable | ||
| Representable Data Types | Enable to store MESSAGE in representable data format. | Enable/Disable | ||
| Socket Timeout | Read timeout while reading from the socket. |
| ||
| Num User IDs | User-defined doc IDs. | 1 |