4.1.10 Properties that you can specify in the <config-property> tag set up for DB Connector
This subsection describes the values that you can specify in the <config-property> tag set up for DB Connector.
If you use Reliable Messaging, check the information required to use it. For details, see the manual uCosminexus Application Server Cosminexus Reliable Messaging.
- Organization of this subsection
(1) When HiRDB Type4 JDBC Driver is used for connecting to HiRDB
-
DBConnector_HiRDB_Type4_CP.rar, DBConnector_HiRDB_Type4_CP_Cosminexus_RM.rar, DBConnector_HiRDB_Type4_XA.rar, or DBConnector_HiRDB_Type4_XA_Cosminexus_RM.rar
Use the above when the transaction is not managed or when a local transaction is used. Furthermore, use DBConnector_HiRDB_Type4_CP_Cosminexus_RM.rar when integrating with Cosminexus RM.
For details on the properties that you can specify, see Table 4-1.
-
DBConnector_HiRDB_Type4_CP.rar or DBConnector_HiRDB_Type4_CP_Cosminexus_RM.rar
Use the above when using a global transaction. Furthermore, use DBConnector_HiRDB_Type4_XA_Cosminexus_RM.rar when integrating with Cosminexus RM.
For details on the properties that you can specify, see Table 4-2.
-
DBConnector_HiRDB_Type4_XA.rar or DBConnector_HiRDB_Type4_XA_Cosminexus_RM.rar
Use the above when using a global transaction. Furthermore, use DBConnector_HiRDB_Type4_XA_Cosminexus_RM.rar when integrating with Cosminexus RM.
For details on the properties that you can specify, see Table 4-3.
(2) When connecting to Oracle using Oracle JDBC Thin Driver
-
DBConnector_Oracle_CP.rar, DBConnector_Oracle_CP_Cosminexus_RM.rar, DBConnector_Oracle_XA.rar, or DBConnector_Oracle_XA_Cosminexus_RM.rar
Use the above when the transaction is not managed or when a local transaction is used. Also, use the DBConnector_Oracle_CP_Cosminexus_RM.rar file when integrating with Cosminexus RM.
For details on the properties that you can specify, see Table 4-4.
-
DBConnector_Oracle_CP.rar or DBConnector_Oracle_CP_Cosminexus_RM.rar
Use the above when the transaction is not managed or when a local transaction is used. Also, use the DBConnector_Oracle_CP_Cosminexus_RM.rar file when integrating with Cosminexus RM.
For details on the property of DBConnector_Oracle_CP.rar, see Table 4-5. For details on the property that can be specified with DBConnector_Oracle_CP_Cosminexus_RM.rar, see Table 4-6.
-
DBConnector_Oracle_XA.rar or DBConnector_Oracle_XA_Cosminexus_RM.rar
Use the above when using a global transaction. Also, use the DBConnector_Oracle_XA_Cosminexus_RM.rar file when integrating with Cosminexus RM.
For details on the property of DBConnector_Oracle_XA.rar, see Table 4-5 and Table 4-7. For details on the property that can be specified with DBConnector_Oracle_XA_Cosminexus_RM.rar, see Table 4-6 and Table 4-7.
For the values that you can specify in the properties, see the Oracle Database documentation.
config-property-name |
config-property-type |
config-property-value |
Specifiable value |
Default |
Version |
---|---|---|---|---|---|
appendZero |
java.lang.Boolean |
When you want to acquire the decimal point having an integer part as 0, from the NUMBER type or FLOAT type column, by using the getString method of the java.sql.ResultSet interface, specify whether to fill the integer part with 0.
|
You can specify the following character strings:
|
false |
09-50 |
forceFixedString |
java.lang.Boolean |
When you specify a value of the CHAR type (fixed length character string) column in the setString method or the setObject method of the java.sql.PreparedStatement interface and the specified value is smaller than the size of the column, specify whether to add blank characters to match the size to the size of the column.
When specifying false The blank characters of fixed length character string are not added. |
You can specify the following character strings:
|
false |
09-50 |
config-property-name |
config-property-type |
config-property-value |
---|---|---|
linkedResourceAdapterName |
java.lang.String |
Specify the display name for the Reliable Messaging resource adapter to be integrated. You can specify this value only when using DBConnector_Oracle_CP_Cosminexus_RM.rar. |
(3) When SQL Server JDBC Driver is used to connect to SQL Server
-
DBConnector_SQLServer2005_CP.rar
Use the above when the transaction is not managed or when a local transaction is used.
For details on the properties that you can specify, see the following table.
(4) Properties that you can specify in the <config-property> tag set up for TP1 inbound adapter
This subsection describes the properties that you can specify in the <config-property> tag set up for TP1 inbound adapter.
config-property-name |
config-property-type |
config-property-value |
---|---|---|
backlog_count |
java.lang.Integer |
Specifies an integer from 1 to 4096 for the length of the Listen queue of the port that awaits RPC requests. The default value is 50. The maximum value for the length of the queue that can be specified differs for each OS. For details, see the manuals describing listen() for each OS and the documentation describing the details of the TCP/IP implementation for each OS. |
connection_timeout |
java.lang.Integer |
Specifies an integer from 0 to 65535 for a timeout value (unit: seconds), when establishing a connection for sending replies of RPC requests. The default value is 8. When 0 is specified, a timeout will not occur. |
ipc_sockctl_watchtime |
java.lang.Integer |
Specifies an integer from 0 to 65535 as the waiting time for a temporary close response (unit: seconds). The default value is 180. When 0 is specified, no operation is performed. |
ipc_tcpnodelay |
java.lang.Boolean |
Specifies whether to use the TCP_NODELAY option for the socket used for establishing a connection with OpenTP1.
The default value is false. |
max_connections |
java.lang.Integer |
Specifies an integer from 1 to 2032 for the maximum number of concurrent connections with the port that awaits RPC requests. The default value is 64. |
node_id |
java.lang.String |
Specifies the node identifier using 4 characters. Specify an alphabetic character (A to Z, a to z) as the first character and for the second and subsequent characters, use alphanumeric characters (A to Z, a to z, 0 to 9) or underscore (_). Specify a unique string for each TP1 inbound adapter. The default value is Cos_. |
receive_buffer_size |
java.lang.Integer |
Specifies an integer from 8192 to 10485761, for the received buffer size. The default value is 8192. |
rpc_close_after_send |
java.lang.Boolean |
Specifies whether to close the connection after the message is sent to OpenTP1.
The default value is false. For results similar to 08-50, specify true. |
rpc_max_thread_count |
java.lang.Integer |
Specifies an integer from 1 to 1024 as the maximum number of threads for receiving concurrent RPC requests. The default value is 10. |
rpc_receive_timeout |
java.lang.Integer |
Specifies an integer from 0 to 65535 for a timeout (unit: seconds) when receiving RPC requests. The default value is 180. When 0 is specified, a timeout will not occur. |
rpc_receive_timeout_interval |
java.lang.Integer |
Specifies an integer from 1 to 65535 for the timeout monitoring interval, when receiving RPC requests. The default value is 5. |
rpc_sockctl_highwater |
java.lang.Integer |
Specifies an integer from 0 to 100 as the threshold value (unit: percent (%)) to start the temporary close processing for RPC receiving connections. The default value is 100. |
rpc_sockctl_lowwater |
java.lang.Integer |
Specifies an integer from 0 to 100 as the percentage of number of connections (unit: percent (%)) where the temporary close processing for RPC receiving connections is an exception. The default value is 0. |
scd_port |
java.lang.Integer |
Specifies an integer from 5001 to 65535, for the port number of the port that awaits RPC requests. The default value is 23700. |
send_buffer_size |
java.lang.Integer |
Specifies an integer from 8192 to 10485761 for the sent buffer size for a reply. The default value is 8192. |
send_retry_count |
java.lang.Integer |
Specifies an integer from 0 to 65535 for the retry count, when an error occurs while establishing a TCP/IP connection for sending server responses. The default value is 1. When 0 is specified, the system does not try to re-establish a connection. |
send_retry_interval |
java.lang.Integer |
Specifies an integer from 0 to 300000 for the retry interval (unit: milliseconds), when an error occurs while establishing a TCP/IP connection for sending server responses. The default value is 0. When 0 is specified, the system tries to establish the TCP/IP connection without any interval. This property becomes valid, when 1 to 65535 is specified in send_retry_count. |
service_group |
java.lang.String |
Specifies 1 to 31 characters as the name of the service group for TP1 inbound adapter. Specify an alphabetic character (A to Z, a to z) as the first character and for the second and subsequent characters, use alphanumeric characters (A to Z, a to z, 0 to 9) or underscore (_). Specify a unique service group name among the J2EE servers. |
tcp_receive_timeout |
java.lang.Integer |
Specifies an integer from 0 to 65535 for a timeout (unit: seconds) starting from establishing a connection or from the time of receiving current data until the next data is received. The default value is 10. When 0 is specified, a timeout will not occur. |
tcp_send_timeout |
java.lang.Integer |
Specifies an integer from 0 to 65535 for a timeout (unit: seconds) when sending replies for RPC requests. The default value is 10. When 0 is specified, a timeout will not occur. |
tcp_send_timeout_interval |
java.lang.Integer |
Specifies an integer from 1 to 65535 for a timeout monitoring interval when sending replies for RPC requests. The default value is 5. Note that in 08-53 and later versions, the settings for this property are ignored. |
trn_max_connections |
java.lang.Integer |
Specifies an integer from 1 to 2032 as the maximum number of concurrent connections for sending RPC requests. The default value is 64. |
trn_max_thread_count |
java.lang.Integer |
Specifies an integer from 1 to 1024 as the maximum number of concurrent threads used for sending and receiving synchronous point messages. The default value is 1. |
trn_port |
java.lang.Integer |
Specifies an integer from 5001 to 65535 for the port number of the port that awaits synchronization. The default value is 23900. |
trn_sockctl_highwater |
java.lang.Integer |
Specifies an integer from 0 to 100 as the threshold value (unit: percent (%)) to start the temporary close processing for RPC sending connections. The default value is 100. |
trn_sockctl_lowwater |
java.lang.Integer |
Specifies an integer from 0 to 100 as the percentage of number of connections (unit: percent (%)) where the temporary close processing for RPC sending connections is an exception. The default value is 0. |