Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  1. 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.


    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.

    Image Modified


    Refer to the SBW Database Property descriptions for descriptions of the SBW database properties.

  2. Select the required database from the Database Name property drop-down and modify values of other properties too accordingly.

  3. Click the Save button or press CTRL+S to save the profile changes.


SBW Database Property descriptions

Database NameJDBC DriverJDBC Connection URLJDBC Login NameJDBC PasswordJDBC Properties
H2org.h2.Driverjdbc:h2:ESB_DEFAULT_DB_DIR/doctracking_db/sbw  h2_jdbc.cfg
Oracleoracle.jdbc.driver.OracleDriverjdbc:oracle:thin:<ip-address>:<port>:<databaseName>  oracle8_jdbc.cfg
IBM DB2sun.jdbc.odbc.JdbcOdbcDriverjdbc:odbc:sample  db2_jdbc.cfg
MS Accesssun.jdbc.odbc.JdbcOdbcDriverjdbc:odbc:Driver={Driver do Microsoft Access (*.mdb)};DBQ=D:\\tif\\bin\\sp\\sbw.mdb  msaccess_jdb.cfg
HSQLorg.hsqldb.jdbcDriverjdbc:hsqldb:ESB_DEFAULT_DB_DIR/doctracking_db/sbw  hsql_jdbc.cfg
MS SQL<ip-address>:<port>;SelectMethod=Cursor  mssql_jdbc.cfg

MS SQL 2005

or later<ip-address>:<port>;databaseName=<databaseName>;SelectMethod=Cursor   
  1. sun.jdbc.odbc.JdbcOdbcDriver
  2. com.mysql.jdbc.Driver
  1. jdbc:odbc:sample
  2. jdbc:mysql://<ip-address>:<port>/<databasename>
Sybasecom.sybase.jdbc2.jdbc.SybDriverjdbc:sybase:Tds:<ip-address>:<port>/<databaseName>  sybase_jdbc.cfg
Apache Derbyorg.apache.derby.jdbc.EmbeddedDriver




  • DerbyDB will be created within the user directory (set in fiorano_vars)
  • ESB_DEFAULT_DB_DIR will be resolved to ESB_USER_DIR/EnterpriseServers/<profilename>


Postgre SQLorg.postgresql.Driverjdbc:postgresql://<ip-address>:<port>/<databasename>  pgsql_jdbc.cfg

Descriptions of common properties are listed below:

PropertiesDescriptionsDefault Value
Scheme Name

By default, the schema name will be %, i.e., all schemas are searched.


Schema name is case sensitive

Catalog Name

By default, the catalog name will be %, all catalogs.


Catalog Name for MS SQL should be configured as database name.

Max Rows To FetchMaximum No Of Rows to Fetch.200
Max Rows To ReturnMaximum No Of Rows to Return.1000
Auto ReconnectBoolean to specify whether SP should try for reconnection with DB automatically.Enable/Disable
Try Reconnect IntervalInterval (in secs) after which SP tries to reconnect with DB in case of a break in connection.5
Insert Thread CountNumber of threads used for inserting SBW data into the database.1
Support Master TableEnable if backward compatibility with earlier SBW schema (1001) is required.Enable/Disable
Representable Data TypesEnable to store MESSAGE in representable data format.Enable/Disable
Socket TimeoutRead timeout while reading from the socket.
  • Oracle - 60000
  • MySQL - 60000
Num User IDsUser-defined doc IDs.1
Adaptavist ThemeBuilder EngineAtlassian Confluence