JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

Additional JDBC/MX Properties.

Default Catalog and Schema

The default catalog and schema are used to access SQL objects referenced in SQL statements if the SQL

objects are not fully qualified. The three-part fully qualified name for SQL/MX objects is of the form:

[[catalog.]schema.]object-name

The catalog and schema names can be any arbitrary strings that conform to SQL identifiers. These names

conform to ANSI SQL:99 catalog and schema names.

For example, using the default catalog and schema properties for a table referenced as CAT.SCH.TABLE, the

options are:

-Djdbcmx.catalog=CAT -Djdbcmx.schema=SCH

For more information, see the

SQL/MX Reference Manual

LOB Table Name Properties

LOB tables store data for LOB columns. The properties you use to specify the LOB table for using BLOB

columns or CLOB columns are:

For the

BLOB columns

blobTableName

For the CLOB columns

clobTableName

The property value is of the form:

catalog_name.schema_name.lob_table_name

You can specify the name of the LOB table using properties in the following ways:

By using the –Djdbcmx.property_name=property_value option in the java command line. For example:

–Djdbcmx.clobTableName=mycat.myschema.myLobTable

By using the java.util.Properties parameter in the getConnection method of DriverManager class.

The properties passed through the Properties parameter have precedence over the command line

properties.

By setting either of these properties in the DataSource. See Connection Using the DataSource

Implementation.

ISO88591 Property

The ISO88591 character set mapping property corresponds to the SQL/MX ISO88591 character set, which is

a single-byte 8-bit character set for character data types. The ISO88591 character set supports English and

other Western European languages. Specify the

ISO88591 property as

String

The default value is DEFAULT which uses the default Java encoding when accessing and writing to ISO88591

columns. The value can be any valid Java Canonical Name as listed in the "Canonical Name for

java.io and

java.lang API" column of the Oracle documentation, Supported Encodings