Hitachi

uCosminexus Application Server Application and Resource Definition Reference Guide


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

(2) When connecting to Oracle using Oracle JDBC Thin Driver

For the values that you can specify in the properties, see the Oracle Database documentation.

Table 4‒4: Properties that you can specify when using DBConnector_Oracle_CP.rar, DBConnector_Oracle_CP_Cosminexus_RM.rar, DBConnector_Oracle_XA.rar, or DBConnector_Oracle_XA_Cosminexus_RM.rar

config-property-name

config-property-type

config-property-value

Specifiable value

Default

Version

CallableStatementPoolSize

3.14.4 in the Application Server Common Container Functionality Guide

java.lang.Integer

Specifies the pool size of CallableStatement for each connection allocated to the connection pool.

If 0 is specified, no statements are pooled.

Specify an integer value from 0 to 2147483647.

10

07-00

CancelStatement

java.lang.Boolean

Specifies whether to cancel the SQL statement being executed in the Statement class, CallableStatement class, and PreparedStatement class, if the transaction times out or if the business application is terminated forcibly.

If you specify true

The SQL statement being executed is cancelled.

If you specify false

The SQL statement being executed is not cancelled.

Specify false when connecting to an exclusive server.

You can specify the following strings:

  • true

  • false

true

07-00

ConnectionIDUpdate

java.lang.Boolean

Specifies whether to update the connection ID for each DataSource#getConnection method.

If you specify true

The connection ID is generated for each DataSource#getConnection method.

If you specify false

The connection ID is generated for the DataSource#getConnection method, when a new physical connection is established, and the connection ID is not updated thereafter.

You can specify the following strings:

  • true

  • false

false

07-00

databaseName

java.lang.String

Specifies a specific database name (SID) on the Oracle server. The set value is passed to the setDatabaseName method of the DataSource node interface of Oracle JDBC Thin Driver.

See the Oracle Database documentation.

(Null character string)

07-00

loginTimeout

java.lang.Integer

Specifies the timeout (unit: milliseconds) for attempting to connect to the database. The specified value is rounded up in seconds and then passed to the setLoginTimeout method of a DataSource interface for Oracle JDBC Thin Driver.

See the Oracle Database documentation. Note that a value that is rounded up in seconds is passed to the setLoginTimeout method.

8000

07-00

logLevel

java.lang.String

Specifies the log trace level that the DB Connector outputs.

You can specify the following values:

  • 0 or ERROR

  • 10 or WARNING

  • 20 or INFORMATION

Specify any one of the following:

  • 0 or ERROR

  • 10 or WARNING

  • 20 or INFORMATION

ERROR

07-00

portNumber

java.lang.Integer

Specifies the port number by which the Oracle server listens to the request. The set value is passed to the setPortNumber method of the DataSource node interface of Oracle JDBC Thin Driver.

See the Oracle Database documentation.

1521

07-00

PreparedStatementPoolSize

3.14.4 in the Application Server Common Container Functionality Guide

java.lang.Integer

Specifies the pool size of PreparedStatement for each connection allocated to the connection pool.

If 0 is specified, no statements are pooled.

Specify an integer value from 0 to 2147483647.

10

07-00

serverName

java.lang.String

Specifies the host name or the IP address of the Oracle server. The set value is passed to the setServerName method of the DataSource node interface of Oracle JDBC Thin Driver.

See the Oracle Database documentation.

(Null character string)

07-00

url

java.lang.String

Specifies the JDBC URL required by the Oracle JDBC Thin Driver to connect to the database.

The values you specify are passed to the setURL method of the DataSource system interface of Oracle JDBC Thin Driver.

When a value is set in this property, the value specified in databaseName, portNumber, and serverName is ignored. Specifies a thin driver in JDBC URL, when the user specifies a url.

(Example)

jdbc:oracle:thin:@ServerA:1521:service1

See the Oracle Database documentation.

(Null character string)

07-00

Table 4‒5: Properties that you can specify when using DBConnector_Oracle_CP.rar or DBConnector_Oracle_XA.rar

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.

When specifying true:

The integer part is filled with 0.

When specifying false:

The integer part is not filled with 0.

You can specify the following character strings:

  • true

  • false

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 true

The blank characters of fixed length character string are added.

When specifying false

The blank characters of fixed length character string are not added.

You can specify the following character strings:

  • true

  • false

false

09-50

Table 4‒6: Properties that you can specify when using DBConnector_Oracle_CP_Cosminexus_RM.rar or DBConnector_Oracle_XA_Cosminexus_RM.rar

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.

Table 4‒7: Properties that you can specify when using DBConnector_Oracle_XA.rar or DBConnector_Oracle_XA_Cosminexus_RM.rar

config-property-name

config-property-type

config-property-value

sessionTimeout

java.lang.Integer

Specifies the session timeout (maximum time period in which the transaction branch is not active) in Oracle server in seconds. You must specify a time period longer than the transaction timeout in the J2EE server. The default value is 300 seconds. The set value is passed to the XAResource.setTransactionTimeout method of Oracle JDBC Thin Driver.

(3) When SQL Server JDBC Driver is used to connect to SQL Server

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

Table 4‒9: 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.

  • If you specify true

    The TCP_NODELAY option will be used.

  • If you specify false

    The TCP_NODELAY option will not be used.

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.

  • If you specify true

    The connection will be closed after the message is sent to OpenTP1.

  • If you specify false

    The connection will not be closed 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.