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.

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
(3) When SQL Server JDBC Driver is used to connect to SQL Server
(4) When connecting to Oracle by using cluster connection pool (root resource adapter)
(5) When connecting to Oracle by using the cluster connection pool (member resource adapter)

(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 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-nameconfig-property-typeconfig-property-valueSpecifiable valueDefaultVersion
CallableStatementPoolSizejava.lang.IntegerSpecifies the pool size of CallableStatement for each connection allocated to the connection pool.Specify an integer value from 0 to 2147483647​.1007-00
CancelStatementjava.lang.BooleanSpecifies 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
true07-00
ConnectionIDUpdatejava.lang.BooleanSpecifies 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
false07-00
databaseNamejava.lang.StringSpecifies 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.There are no limitations for the input value.(Null character string)07-00
loginTimeoutjava.lang.IntegerSpecifies the timeout (unit: milliseconds) for attempting to connect to the database. If you specify 0, the timeout value becomes infinite and is blocked until a connection is established or an error occurs. The default value is 8000. The specified value is passed to the setLoginTimeout method of the DataSource node interface of Oracle JDBC Thin Driver. For Oracle JDBC Thin Driver 9.2.0.8 or later, 10.1.0.5 or later, and 10.2 or later, the value is rounded off to the seconds unit, and the value is passed to the setLoginTimeout method.There are no limitations for the input value.800007-00
logLeveljava.lang.StringSpecifies 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
ERROR07-00
portNumberjava.lang.IntegerSpecifies 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.There are no limitations for the input value.152107-00
PreparedStatementPoolSizejava.lang.IntegerSpecifies the pool size of PreparedStatement for each connection allocated to the connection pool.Specify an integer value from 0 to 2147483647​.1007-00
serverNamejava.lang.StringSpecifies 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.There are no limitations for the input value.(Null character string)07-00
urljava.lang.StringSpecifies 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
There are no limitations for the input value.(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-nameconfig-property-typeconfig-property-valueSpecifiable valueDefaultVersion
appendZerojava.lang.BooleanWhen 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
false09-50
forceFixedStringjava.lang.BooleanWhen 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
false09-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-nameconfig-property-typeconfig-property-value
linkedResourceAdapterNamejava.lang.StringSpecify 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-nameconfig-property-typeconfig-property-value
sessionTimeoutjava.lang.IntegerSpecifies 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) When connecting to Oracle by using cluster connection pool (root resource adapter)

(5) When connecting to Oracle by using the cluster connection pool (member resource adapter)