uCosminexus Application Server, Application and Resource Definition Reference Guide

[Contents][Index][Back][Next]

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-name config-property-type config-property-value Specifiable value Default Version
CallableStatementPoolSize java.lang.Integer Specifies the pool size of CallableStatement for each connection allocated to the connection pool. 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. There are no limitations for the input value. (Null character string) 07-00
loginTimeout java.lang.Integer Specifies 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. 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. There are no limitations for the input value. 1521 07-00
PreparedStatementPoolSize java.lang.Integer Specifies the pool size of PreparedStatement for each connection allocated to the connection pool. 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. There are no limitations for the input value. (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
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-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) 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)