Neoview JDBC Type 4 Driver Programmer's Reference (R2.2, R2.3, R2.4, R2.5)

public String getServiceName() throws SQLException
Conformance of DatabaseMetaData Methods' Handling of Null Parameters
This topic describes how the Type 4 driver determines the value of null parameters passed as a
parameter value on DatabaseMetaData methods. Since other vendors might implement the
JDBC specification differently, this information explains the Type 4 driver results on the affected
queries.
This implementation applies to methods that take parameters that can represent a pattern. The
names of these parameters have the format:
attributePattern
The many methods of the java.sql.DatabaseMetaData class are affected; for example, the
getColumns() method.
For another example, schema is the attribute in the parameter schemaPattern, which is a
parameter to the java.sql.ResultSet.getAttributes method.
public ResultSet getAttributes(String catalog,
String schemaPattern,
String typeNamePattern,
String attributeNamePattern)
throws SQLException
If the application passes a null value, the null is treated as follows:
• If a parameter name contains the suffix Pattern, the null is interpreted as a % wild card.
• If the parameter name does not contain the suffix Pattern, nulls are interpreted as the
default value for that parameter.
Using this example, null parameters are interpreted as follows:
catalog the default catalog name
schemaPattern
a % wild card retrieves data for all schemas of the specified catalog
Type 4 Driver Conformance to SQL Data Types
JDBC Data Types
The following table shows the JDBC data types that are supported by Type 4 driver and their
corresponding Neoview SQL data types:
Neoview SQL Data
Type
Support by JDBC Driver for Neoview SQLJDBC Data Type
N. A.No
Types.Array
LARGEINTYes
Types.BIGINT
CHAR(n)¹Data type is mapped by Neoview SQL. Data type
varies from that used for table creation.
Types.BINARY
CHAR(1)Data type is mapped by Neoview SQL. Data type
varies from that used for table creation.
Types.BIT
LARGEINTYes
Types.BLOB
CHAR(n)Yes
Types.CHAR
LARGEINTYes
Types.CLOB
DATEYes
Types.DATE
DECIMAL(p,s)Yes
Types.DECIMAL
N. A.No
Types.DISTINCT
Conformance of DatabaseMetaData Methods' Handling of Null Parameters 69