useJDBC4ColumnNameAndLabelSemantics is set to
com.ibm.db2.jcc.DB2BaseDataSource.YES.
com.ibm.db2.jcc.DB2BaseDataSource.NO (2)
The IBM Data Server Driver for JDBC and SQLJ uses the following
rules to determine the values that ResultSetMetaData.getColumnName,
ResultSetMetaData.getColumnLabel, and ResultSet.findColumn return:
If the data source does not support the LABEL ON statement, or the
source column is not defined with the LABEL ON statement:
v The value that is returned by ResultSetMetaData.getColumnName is
its name from the database, if no SQL AS clause is specified. If the
SQL AS clause is specified, the value that is returned is the column
label.
v The value that is returned by ResultSetMetaData.getColumnLabel is
the label that is specified with the SQL AS clause. If the SQL AS
clause is not specified, the value that is returned is the name of the
column.
v ResultSet.findColumn takes the column name as input.
If the source column is defined with the LABEL ON statement:
v The value that is returned by ResultSetMetaData.getColumnName is
the column name from the database, if no SQL AS clause is
specified. If the SQL AS clause is specified, the value that is returned
is the column label that is specified in the AS clause.
v The value that is returned by ResultSetMetaData.getColumnLabel is
the label that is specified in the LABEL ON statement.
v ResultSet.findColumn takes the column name as input.
These rules conform to the behavior of the IBM Data Server Driver for
JDBC and SQLJ before Version 3.50.
com.ibm.db2.jcc.DB2BaseDataSource.NOT_SET (0)
This is the default behavior.
For the IBM Data Server Driver for JDBC and SQLJ version 3.50 and
earlier, the default behavior for
useJDBC4ColumnNameAndLabelSemantics is the same as the behavior
for com.ibm.db2.jcc.DB2BaseDataSource.NO.
For the IBM Data Server Driver for JDBC and SQLJ version 4.0 and
later:
v The default behavior for useJDBC4ColumnNameAndLabelSemantics
is the same as the behavior for
com.ibm.db2.jcc.DB2BaseDataSource.YES, for connections to the
following database systems:
– DB2 for z/OS Version 8 or later
– DB2 Database for Linux, UNIX, and Windows Version 8.1 or later
– DB2 for i5/OS V5R3 or later
v For connections to earlier versions of these database systems, the
default behavior for useJDBC4ColumnNameAndLabelSemantics is
com.ibm.db2.jcc.DB2BaseDataSource.NO.
com.ibm.db2.jcc.DB2ConnectionPoolDataSource.maxStatements
Controls an internal statement cache that is associated with a
PooledConnection. The data type of this property is int. Possible values are:
Chapter 7. JDBC and SQLJ reference information 223
To Next Page
Loading...
Need help?
General