JDBC Driver for SQL/MX Programmer's Reference

For information about using features provided by various JDBC/MX properties, see the topic, Using
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.
●