db.properties

Set the database connection information options for OZ Server. OZ Server creates DB Connection Pool at the starting time and allows sharing it to improve performance.

---

alias.vendor

Set the database vendor name.

alias.driver

Set the JDBC/ADO.NET driver class name.

alias.url

Set the Connection URL of JDBC/ADO.NET driver.

alias.portNo

Set the database port number.

alias.serverAddress

Set the database server address.

alias.serverName

Set the database server name.

alias.user

Set the database user ID. If there is a leakage risk of db.properties file, encrypt the user ID first by using the ozencrypted.bat file and set this option.

alias.password

Set the database user password. If there is a leakage risk of db.properties file, encrypt the password first by using the ozencrypted.bat file and set this option.

alias.sid

Set the SID of the Oracle database.

alias.dsn

Set the ODBC database source name.

alias.fetchrow

Set the number of rows sent at once when returning result sets.

alias.timeout

Set the connection waiting timeout(sec).

alias.initconns

Set the initial connection count of the OZ Server.

alias.maxconns

Set the maximum connection count of the OZ Server.

alias.props

Set the connection property string of the JDBC/ADO.NET driver.

alias.dbName

Set the database name.

alias.encodecharset

Set the encoding character set. If this option is not set or equal to the value of alias.decodecharset, it is applied with the value set by the OZ Server. If the encoding character set is set in the ODI file, the value set in the ODI file is applied.

alias.decodecharset

Set the decoding character set. If this option is not set or equal to the value of alias.encodecharset, it is applied with the value set by the OZ Server. If the decoding character set is set in the ODI file, the value set in the ODI file is applied.

alias.doConnectionCheck

Set whether to run test queries every time when getting a connection from Connection Pool and set whether to create a new connection if the test query failed.

alias.doConnectionCheckMaxTime

Set the maximum time to check the connection status(sec).

alias.doConnectionCheckMinTime

Set the minimum time to check the connection status(sec).

alias.sessionQuery

Set the query to get the Session ID of the monitor log. For all DBMS with a query for session ID, you have to register session queries for each DBMS by alias.sessionQuery in db.properties. If a DBMS has no session query, it's session ID will be blank.

alias.testQueryString

Set the test query to run whenever getting a connection from the Connection Pool.

alias.querytimeout

Set the query execution timeout in seconds.

alias.ignoreQueryError

Set whether to ignore query errors. If an error occurs during query execution, it sends an empty data set.