Mandatory |
Yes |
Data type |
String |
Data format |
Multiple lines of Property=Value |
Properties for Cloudscape |
- databaseName=
- install_root/ProcessChoreographer/BPEDB. Required string.
Defines which database to access. The value must be a fully qualified path.
- shutdownDatabase=
- Optional string. If set to shutdown, the database shuts
down when a java.sql.Connection object is obtained from the data source. For
example, if the data source is an XADataSource, a getXAConnection().getConnection() is
necessary to cause the database to shut down.
- dataSourceName=
- Optional string. Name for the ConnectionPooledDataSource or XADataSource.
Not used by the data source object. Used for information purposes only.
- description=DataSource for Process Choreographer
- Optional string. Description of the data source. Not used by the data
source object. Used for information purposes only.
- connectionAttribute=
- Optional string. Connection attributes specific to Cloudscape. Refer to
the Cloudscape documentation for a complete list of attributes.
- createDatabase=
- Optional string. If set to create, and the database specified
in the databaseName parameter does not already exist, the database will be
created. The database is created when a connection object is obtained from
the data source.
- enableMultithreadedAccessDetection=false
- Optional boolean. If set to true, it automatically detects
multithreaded access to a connection and its corresponding Statements, ResultSets,
and MetaDatas.
- preTestSQLString=SELECT 1 FROM TABLE1
- Optional string. This SQL statement is used for pre-test connection function.
If pre-test connection is enabled in j2c.properties, this SQL statement will
be executed to the connection to make sure the connection is good. If you
leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will
be used at runtime. This will slow down the execution because of the exception
handling if table TABLE1 is not defined in the database. Users are recommended
to provide their own SQL statement to improve the performance.
- remoteDataSourceProtocol=
- Optional string. If the database is remote and the data source accesses
the database using a client, set this property to specify which client and
server protocol to use. Currently, the only protocol value supported is rmi.
|
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Legacy CLI-based
Type 2 JDBC Driver (XA)) |
- databaseName=BPEDB
- Required string. For DB2 UDB it defines which database to access. For
DB2 z/OS it defines which subsystem contains the DB2 z/OS database.
- description=DataSource for Process Choreographer
- Optional string. Description of the data source. Not used by the data
source object. Used for information purposes only.
- portNumber=
- Optional integer. Specifies the TCP/IP port number where the JDBC provider
resides.
- connectionAttribute=cursorhold=0
- Optional string. Connection attributes specific to DB2. Refer to the DB2
documentation for a complete list of connection attributes.
- loginTimeout=0
- Optional integer. If set to zero, no timeout takes place. Non-zero values
specify the maximum number of seconds allowed to establish a connection to
the database.
- enableMultithreadedAccessDetection=false
- Optional boolean. If set to true, it automatically detects
multithreaded access to a connection and its corresponding Statements, ResultSets,
and MetaDatas.
- preTestSQLString=SELECT 1 FROM TABLE1
- Optional string. If you enabled pre-test connection in the j2c.properties file,
this pre-test string is used to make sure that the connection is good. If
you leave this field blank, the default SQL statement, SELECT 1 FROM
TABLE1, will be used at runtime. This will reduce performance because
of the exception handling if table TABLE1 is not defined in the database.
It is recommended to provide your own SQL statement to improve the performance.
|
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Universal JDBC Driver
Provider (XA)) |
- databaseName=BPEDB
- Required string. For DB2 UDB it defines which database to access. For
DB2 z/OS it defines which subsystem contains the DB2 z/OS database.
- driverType=2
- Required integer. The JDBC connectivity-type of a data source. The only
permitted value is 2.
- serverName=""
- Optional string. The TCP/IP address or host name for the DRDA server.
- portNumber=50000
- Optional integer. The TCP/IP port number where the DRDA server resides.
- enableSQLJ=false
- Optional boolean. This value is used to indicate whether SQLJ operations
may be performed with this data source. If enabled, this data source can be
used for both JDBC and SQLJ calls. Otherwise, only JDBC usage is permitted.
- description=DataSource for Process Choreographer
- Optional string. Description of the data source. Not used by the data
source object. Used for information purposes only.
- traceLevel=""
- Optional integer. The DB2 trace level for logging to the logWriter or
trace file. Possible trace levels are: TRACE_NONE = 0,TRACE_CONNECTION_CALLS
= 1,TRACE_STATEMENT_CALLS = 2,TRACE_RESULT_SET_CALLS = 4,TRACE_DRIVER_CONFIGURATION
= 16,TRACE_CONNECTS = 32,TRACE_DRDA_FLOWS = 64,TRACE_RESULT_SET_META_DATA
= 128,TRACE_PARAMETER_META_DATA = 256,TRACE_DIAGNOSTICS = 512,TRACE_SQLJ =
1024,TRACE_ALL = -1, .
- traceFile=""
- Optional string. The trace file to store the trace output.
- fullyMaterializeLobData=true
- Optional boolean. This setting controls whether or not LOB locators are
used to fetch LOB data. If enabled, LOB data is not streamed, but is fully
materialized with locators when the user requests a stream on the LOB column.
The default value is true.
- resultSetHoldability=2
- Optional integer. Determine whether ResultSets are closed or kept open
when committing a transaction. The possible values are: 1 (HOLD_CURSORS_OVER_COMMIT),
2 (CLOSE_CURSORS_AT_COMMIT).
- currentPackageSet=""
- Optional string. This property is used in conjunction with the DB2Binder
- collection option which is given when the JDBC/CLI packageset is bound during
installation by the DBA.
|
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Universal JDBC Driver
Provider (XA)) (continued) |
- readOnly=false
- Optional boolean. This property creates a read only connection.
- deferPrepares=false
- Optional boolean. This property provides a performance directive that
affects the internal semantics of the input data type conversion capability
of the driver. If it is set to "true" the Universal driver defers 'internal
prepare requests'. In this case, the driver works without the benefit of described
parameter or result set metadata until execute time. So undescsribed input
data is sent 'as is' to the server without any data type cross-conversation
of the inputs.
- currentSchema=""
- Optional string. Identifies the default schema name used to qualify unqualified
database object references where applicable in dynamically prepared SQL statements.
Unless currentSchema is used, the default schema name is the authorization
id of the current session user.
- cliSchema=""
- Optional string. Indicates the schema of the DB2 shadow catalog tables
or views to search when you issue a database metadata catalog query.
- enableMultithreadedAccessDetection=false
- Optional boolean. If set to true, it automatically detects
multithreaded access to a connection and its corresponding Statements, ResultSets,
and MetaDatas.
- retrieveMessagesFromServerOnGetMessage=true
- If set to true it directs all calls to the standard JDBC SQLException.getMessage()
to invoke a server-side stored procedure which retrieves the readable message
text for the error.
|
Properties for DB2 UDB 8.1 & DB2 z/OS 7 (DB2 Universal JDBC Driver
Provider (XA)) (continued) |
- preTestSQLString=SELECT 1 FROM TABLE1
- Optional string. This SQL statement is used for pre-test connection function.
If pre-test connection is enabled in j2c.properties, this SQL statement will
be executed to the connection to make sure the connection is good. If you
leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will
be used at runtime. This will slow down the execution because of the exception
handling if table TABLE1 is not defined in the database. Users are recommended
to provide their own SQL statement to improve the performance.
- enableSQLJ=false
- Optional boolean. This SQL statement is used for pre-test connection function.
If pre-test connection is enabled in j2c.properties, this SQL statement will
be executed to the connection to make sure the connection is good. If you
leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will
be used at runtime. This will slow down the execution because of the exception
handling if table TABLE1 is not defined in the database. Users are recommended
to provide their own SQL statement to improve the performance.
|
Properties for Properties for Informix 9.3 & 9.4 |
- databaseName=BPEDB
- Required string. The name of the database.
- serverName=""
- Required string. The name of the Informix instance on the physical machine.
There is no default for the string and therefore you need to set it explicitly.
- portNumber=1526
- Required integer. The TCP/IP port number of the Informix instance. The
value "1526" is the default Informix port on Windows. On UNIX it is "61000".
- ifxIFXHOST=hostname
- Required string. The physical machine name of the server that hosts the
informix database. "Localhost" does not work.
- informixLockModeWait=2
- Required integer. By default, Informix throws an exception when it cannot
acquire a lock, rather than waiting for the current owner of the lock to release
it. To modify this behavior, set this property to the number of seconds to
wait for a lock. The default is 2 seconds. Any negative value means to wait
forever.
- informixAllowNewLine=false
- Optional boolean. his property allows newLines to be added on a query
String. Its disabled by default.
- roleName=""
- Optional string. The role name.
- description=DataSource for Process Choreographer
- Optional string. Description of the data source. Not used by the data
source object. Only used for information purposes.
- loginTimeout=""
- Optional integer. The maximum time to attempt to connect a database. If
this value is non-zero, attempt to connect to the database will timeout when
this specified value is reached.
- dataSourceName=""
- Optional string. The name of the data source. Only used for informational
purposes.
- ifxUSE_DTENV to ifxPSORT_DBTEMP
- Optional string. The value for Informix specific variables. Please refer
to the Informix documentation for possible values.
|
Properties for Properties for Informix 9.3 & 9.4 (continued) |
- enableMultithreadedAccessDetection=false
- Optional boolean. Indicates whether or not to detect multithreaded access
to a Connection and its corresponding Statements, ResultSets, and MetaDatas.
- preTestSQLString=SELECT 1 FROM TABLE1
- Optional string. This SQL statement is used for pre-test connection function.
If pre-test connection is enabled in j2c.properties, this SQL statement will
be executed to the connection to make sure the connection is good. This will
slow down the execution because of the exception handling if table TABLE1
is not defined in the database. Users are recommended to provide their own
SQL statement to improve the performance.
|
Properties for Oracle 8i OCI & Oracle 9i OCI |
- driverType=oci8
- Required string. Defines the type of the JDBC driver.
- oraclelogPrintMask=62
- Optional integer. The oraclelogPrintMask controls which information is
printed with each trace message. Oracle9i requires the ojdbc14_g.jar file.
The default is 62, which is ([OracleLog.FIELD_OBJECT for 9i / OracleLog.FIELD_CONN
for 8i] 32 | OracleLog.FIELD_CATEGORY 16 | OracleLog.FIELD_SUBMOD 8 | OracleLog.FIELD_MODULE
4 | OracleLog.FIELD_TIME 2).
Possible values: OracleLog.FIELD_TIME
2, OracleLog.FIELD_MODULE 4, OracleLog.FIELD_SUBMOD 8, OracleLog.FIELD_CATEGORY
16, OracleLog.FIELD_OBJECT 32, OracleLog.FIELD_THREAD 64. - oraclelogModuleMask=1
- Optional integer. The oraclelogModuleMask controls which modules write
debug output. Oracle9i requires the ojdbc14_g.jar file. The
default is 1, which is ( OracleLog.MODULE_DRIVER 1).
Possible values:
OracleLog.MODULE_DRIVER 1, OracleLog.MODULE_DBACCESS 2. - oraclelogCategoryMask=47
- Optional integer. The oraclelogCategoryMask controls which category to
be output. Oracle9i requires the ojdbc14_g.jar file. The
default is 47, which is ( OracleLog.USER_OPER 1 | OracleLog.PROG_ERROR 2
| OracleLog.ERROR 4 | OracleLog.WARNING 8 | OracleLog.DEBUG1 32).
Possible
values: OracleLog.USER_OPER 1, OracleLog.PROG_ERROR 2, OracleLog.ERROR
4, OracleLog.WARNING 8, OracleLog.FUNCTION 16, OracleLog.DEBUG1 32, OracleLog.SQL_STR
128. - TNSEntryName=BPEDB
- Required string. The entry name that is used in tnsnames.ora to identify
the database.
- networkProtocol=
- Optional string. Specifies which protocol is used, for example, TCP/IP or
IPC.
- databaseName=BPEDB
- Optional string. Defines which database to access.
- serverName=
- Optional string. The name of the server where the Oracle database resides.
- portNumber=1521
- Optional integer. The TCP/IP port number where the JDBC driver resides.
|
Properties for Oracle 8i OCI & Oracle 9i OCI (continued) |
- dataSourceName=
- Optional string. The name of the datasource. Only used for informational
purposes.
- URL=jdbc:oracle:oci8:@BPEDB
- Optional string. The URL specifies the database from which the data source
obtains connections.
- loginTimeout=""
- Optional integer. The maximum time to attempt to connect the database.
If set to zero, there will be no timeout. If this value is non-zero, attempt
to connect to the database will timeout when this specified value is reached.
- description=DataSource for Process Choreographer
- Optional string. Description of the data source. Used for information
purposes only.
- enableMultithreadedAccessDetection=false
- Optional boolean. If set to true, it automatically detects
multithreaded access to a connection and its corresponding Statements, ResultSets,
and MetaDatas.
- transactionBranchesLooselyCoupled=false
- Optional boolean. This property is introduced as a result of Oraclebug
2511780. Oracle Patch for 2511780 must be installed before setting this property
to true. Failure to install this patch causes a program error.
Check the WebSphere readme file for more information.
- preTestSQLString=SELECT 1 FROM TABLE1
- Optional string. If you have enabled a pre-test connection in the j2c.properties file,
this pre-test string is used to make sure that the connection is good. If
you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1,
will be used at runtime. This will slow down the execution because of the
exception handling if table TABLE1 is not defined in the database. Users are
recommended to provide their own SQL statement to improve the performance.
|
Properties for Oracle 8i thin & Oracle 9i thin |
- driverType=thin
- Required string. Defines the type of the JDBC driver.
- oraclelogPrintMask=62
- Optional integer. The oraclelogPrintMask controls which information is
printed with each trace message. Oracle9i requires the use of ojdbc14_g.jar.
Default is 62 which is ([OracleLog.FIELD_OBJECT for 9i / OracleLog.FIELD_CONN
for 8i] 32 | OracleLog.FIELD_CATEGORY 16 | OracleLog.FIELD_SUBMOD 8 | OracleLog.FIELD_MODULE
4 | OracleLog.FIELD_TIME 2). Possible values: OracleLog.FIELD_TIME 2, OracleLog.FIELD_MODULE
4, OracleLog.FIELD_SUBMOD 8, OracleLog.FIELD_CATEGORY 16, OracleLog.FIELD_OBJECT
32, OracleLog.FIELD_THREAD 64.
- oraclelogModuleMask=1
- Optional integer. The oraclelogModuleMask controls which modules write
debug output. Oracle9i requires the use of ojdbc14_g.jar. Default is 1 which
is ( OracleLog.MODULE_DRIVER 1). Possible values (OracleLog.MODULE_DRIVER
1, OracleLog.MODULE_DBACCESS 2)"
- oraclelogCategoryMask=47
- Optional integer. The oraclelogCategoryMask controls which category to
be output. Oracle9i requires the use of ojdbc14_g.jar. Default is 47 which
is ( OracleLog.USER_OPER 1 | OracleLog.PROG_ERROR 2 | OracleLog.ERROR 4 |
OracleLog.WARNING 8 | OracleLog.DEBUG1 32). Possible values (OracleLog.USER_OPER
1, OracleLog.PROG_ERROR 2, OracleLog.ERROR 4, OracleLog.WARNING 8, OracleLog.FUNCTION
16, OracleLog.DEBUG1 32, OracleLog.SQL_STR 128)"
- TNSEntryName=""
- Optional string. Not used for the thin JDBC driver.
- networkProtocol=""
- Optional string. Specifies which protocol is used, for example, TCP/IP
or IPC.
- databaseName=BPEDB
- Required string. Defines which database to access.
- serverName=hostname
- Required string. The name of the server where the Oracle database resides
- portNumber=1521
- Required integer. The TCP/IP port number where the JDBC driver resides.
|
Properties for Oracle 8i thin & Oracle 9i thin (continued) |
- dataSourceName=""
- Optional string. The name of the data source. Only used for informational
purposes.
- URL=jdbc:oracle:thin:@hostname:1521:BPEDB
- Required string. The URL specifies the database and the database host
from which the data source will obtain connections.
- loginTimeout=""
- Optional integer. The maximum time to attempt to connect the database.
If set to zero, there will be no timeout. If this value is non-zero, attempt
to connect to the database will timeout when this specified value is reached.
- description=DataSource for Process Choreographer
- Optional string. Description of the datasource. Only used for information
purposes.
- enableMultithreadedAccessDetection=false
- Optional boolean. If set to true, it will automatically detect multithreaded
access to a connection and its corresponding Statements, ResultSets, and MetaDatas.
- transactionBranchesLooselyCoupled=false
- Optional boolean. This property is introduced as a result of Oraclebug
2511780, Oracle Patch for 2511780 must be installed before setting this property
to true, failure to do that would cause a program error. Please check the
WebSphere readme file for more info.
- preTestSQLString=SELECT 1 FROM TABLE1
- Optional string. If you have enabled pre-test connection in j2c.properties,
this pre-test string is used to make sure that the connection is good. If
you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1,
will be used at runtime. This will slow down the execution because of the
exception handling if table TABLE1 is not defined in the database. Users are
recommended to provide their own SQL statement to improve the performance.
|
Properties for SQL Server 2000 (DataDirect SequeLink type 3 JDBC
driver for MS SQL Server (XA)) |
- databaseName=BPEDB
- Required string. The database name.
- serverName=hostname
- Required string. The TCP/IP address of the SequeLink server in dotted
format or host name format.
- portNumber=19996
- Required integer. The TCP/IP port number where the jdbc driver resides.
- spyAttributes=""
- Optional string. The SPY attributes. See the ConnectJDBC documentation
for a list of attributes.
- loginTimeout=""
- Optional integer. The maximum time to attempt to connect a database. If
this value is non-zero, attempt to connect to the database will timeout when
this specified value is reached.
- description=DataSource for Process Choreographer
- Optional string. The description of this datasource.
- cipherSuites=""
- Optional string. The Secure Socket Layer(SSL) cipher suites with which
the SequeLink Java Client can use to connect. This property is required when
networkProtocol=ssl.
- blockFetchForUpdatee=1
- Optional integer. When the isolation level is ReadCommitted and a SELECT
FOR UPDATE statement is issued against some data stores, the SequeLink Java
Client does not lock the expected row. Default is 1 which does not lock the
expected row.
- SLKStaticCursorLongColBuffLen=4
- Optional integer. The amount of data (in KB) that is buffered for SQL_LONGVARCHAR
and SQL_LONGVARBINARY columns which an insensitive result set.
- certificateChecker=com.merant.sequelink.cert. CertificateCheckerInterface
- Optional string. The fully qualified class name of a user-defined server
certificate checker class.
- serverDataSource=""
- Optional string. A property that specifies a string to identify the server
data source to be used for the connection. If unspecified, the configuration
of the default server data source will be used for the connection.
- enable2Phase=true
- Optional boolean. When true, two phase connections are used. Do not change
this value because this value is set for with this provider and is required
by Process Choreographer.
- applicationName=""
- Optional string. Identifies the application that is establishing the Connections.
When the application does not provide a value, the default value is SequeLink
JDBC Application.
|
Properties for SQL Server 2000 (DataDirect SequeLink type 3 JDBC
driver for MS SQL Server (XA)) (continued) |
- MSSMapLongToDecimal=""
- Optional boolean. Enable client-side workarounds. Refer to the SequeLink
Administrator's Guide.
- ORANumber0IsNumeric=""
- Optional boolean. Enable client-side work-arounds. Refer to the SequeLink
Administrator's Guide.
- enableMultithreadedAccessDetection=false
- Optional boolean. Indicates whether or not to detect multithreaded access
to a Connection and its corresponding Statements, ResultSets, and MetaDatas.
- preTestSQLString=SELECT 1 FROM TABLE1
- Optional string. This SQL statement is used for pre-test connection function.
If pre-test connection is enabled in j2c.properties, this SQL statement will
be executed to the connection to make sure the connection is good. If you
leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1, will
be used at runtime. This will slow down the execution because of the exception
handling if table TABLE1 is not defined in the database. Users are recommended
to provide their own SQL statement to improve the performance.
- allowPrefetch=0
- Optional integer. Enables the prefetch feature. When enabled, the JDBC
driver requests a next set of rows from the server while the client is processing
the previous set of rows. 0 = disable; 1 = enable.
- insensitiveResultSetBufferSize=2058
- Optional integer. The memory caching scheme for scroll-insensitive cursors.
When set to 0, the driver uses a memory caching mechanism that does not use
disk overflow. When set to a value greater than 0, data overflows to disk
when the size of cached data exceeds the specified amount, specified in kilobytes.
When set to a value less than 0, the data provider providers better performance.
However, memory use may be affected.
|
Properties for SQL Server 2000 (WebSphere embedded ConnectJDBC driver
for MS SQL Server (XA)) |
- databaseName=BPEDB
- Required string. Defines which database to access.
- serverName
- Required string. The TCP/IP address of the SequeLink server in dotted
format or host name format.
- portNumber=1433
- Required integer. The TCP/IP port number where the Microsoft SQL Server
resides.
- selectMethod=
- Optional string. Determine whether or not Microsoft SQL Server 'server
cursors' are used for SQL queries. Values are 'cursor' or 'direct'. See the
ConnectJDBC documentation for more information.
- dataSourceName=
- Optional string. Name for the data source. Only used for information purposes.
- spyAttributes=
- Optional string. The SPY attributes. See the ConnectJDBC documentation
for a list of attributes.
- loginTimeout=
- Optional integer. The maximum time to attempt to connect a database. If
this value is non-zero, attempt to connect to the database will timeout when
this specified value is reached. Zero implies no time limit.
- description=DataSource for Process Choreographer
- Optional string. Description of the data source. Not used by the data
source object. Used for information purposes only.
- enable2Phase=true
- Required boolean. When true, two phase connections are used. Do not change
this value because this value is set for with this provider and process choreographer
requires two-phase connections.
- maxPooledStatements=
- Optional integer. The maximum number of pooled PreparedStatements for
this connection.
- sendStringParametersAsUnicode=""
- Optional boolean. Determines whether string parameters are sent to the
SQL Server database as Unicode or in the default character encoding of the
database. For more information, refer to the ConnectJDBC documentation.
- enableMultithreadedAccessDetection=false
- Optional boolean. If set to true, it automatically detects
multithreaded access to a connection and its corresponding Statements, ResultSets,
and MetaDatas.
|
Properties for SQL Server 2000 (WebSphere embedded ConnectJDBC driver
for MS SQL Server (XA)) (continued) |
- preTestSQLString=SELECT 1 FROM TABLE1
- Optional string. If you enabled pre-test connection in the j2c.properties file,
this pre-test string is used to make sure that the connection is good. If
you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1,
will be used at runtime. This will slow down the execution because of the
exception handling if table TABLE1 is not defined in the database. Users are
recommended to provide their own SQL statement to improve the performance.
- codePageOverride=""
- Optional string. Specifies the code page the driver uses when converting
character data. See the ConnectJDBC documentation for more information.
- insensitiveResultSetBufferSize=2048
- Optional integer. Determines the amount of memory used by the driver to
cache insensitive result set data. See the ConnectJDBC documentation for more
information.
|
Properties for Sybase 12.0 & Sybase 12.5 |
- databaseName=BPEDB
- Required string. Defines which database to access.
- serverName=hostname
- Required string. The name of the server where the Sybase database resides.
- portNumber=4100
- Required integer. The TCP/IP port number where the JDBC driver resides.
- networkProtocol=
- Optional string. Specifies which protocol is used, for example, socket or SSL.
When set to socket, Secure Sockets Layer (SSL) encryption is not
used.
- dataSourceName=
- Optional string. Name for the data source. Used for information purposes
only.
- version=
- Optional integer. The version number of the driver.
- resourceManagerName=
- Optional string. The name of the resource manager.
- loginTimeout=
- Optional integer. The maximum time to attempt to connect a database. If
this value is non-zero, attempt to connect to the database will timeout when
this specified value is reached. If set to zero, there will be no timeout.
- description=DataSource for Process Choreographer
- Optional string. Description of the data source. Used for information
purposes only.
- connectionProperties=SELECT_OPEN_CURSORS=true
- Required string. Refer to the Sybase documentation for more information
about SELECT_OPEN_CURSORS and other properties.
- enableMultithreadedAccessDetection=false
- Optional boolean. If set to true, it automatically detects
multithreaded access to a connection and its corresponding Statements, ResultSets,
and MetaDatas.
- preTestSQLString=SELECT 1 FROM TABLE1
- Optional string. If you enabled pre-test connection in the j2c.properties file,
this pre-test string is used to make sure that the connection is good. If
you leave this field blank, the default SQL statement, SELECT 1 FROM TABLE1,
will be used at runtime. This will slow down the execution because of the
exception handling if table TABLE1 is not defined in the database. Users are
recommended to provide their own SQL statement to improve the performance.
|