DB Connection Pool Dialog Box
By right-clicking on the DB Connection Pool Properties window from the pop-up menu that appears, click the [Add] menu, run "DB Connection Pool" dialog box.
Pool
set the DB connection pool name, Vendor type, Connection information.
Name |
DB connection pool name. |
DB Vendor |
DB vendor type. |
DB Server IP Address |
DB server IP address. |
DB Server Port Number |
DB server port number. |
DB Server Name |
DB server name. If Oracle the server distinguished name of SID is set to please. |
User Name |
Access to the DB server user name. |
Password |
Access to the DB server user password. |
Confirm |
Re-enters the password. |
Connection
Set the DB Connection number, Timeout, SessionQuery.
Max |
Maximum of DB connections OZ server can have. |
Init |
Number of OZ server’s initial DB connections. |
Connection Timeout |
Maximum time for the connection used to be returned when it exceeds the Maxconns.(unit: second) |
Query Timeout |
Maximum time for the query execution.(unit: second) |
SessionQuery |
Session query to set in the OZ server db.properties. |
Driver
Set the Use Driver Configuration, Driver information.
Use Driver Configuration |
Sets whether to use the Driver configuration. |
Driver |
Driver class name. |
URL |
Driver connection URL. |
Property |
Driver connection property. |
Option
Set the Test connection, Time, Encoding/Decoding Set, JDBC Fetch Row, Ignore query error.
Attempt test connection |
In case of OZ server losing connection pool, this adds queries to test and checks the connection to the DB when connecting to OZ server. If the connection is lost, this reconnects the connection pool. |
MinTime |
Minimum time to check the DB Connection.(unit: second) |
MaxTime |
Maximum time to check the DB Connection.(unit: second) |
Encoding char set |
Encoding character set. |
Decoding char set |
Decoding character set. |
JDBC FETCH ROW |
When return a result set setting the number of rows that can be imported at once. |
Ignore query errors |
Sets whether to send empty data when an query error occurs |