JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

Table 4 DataSource Object Properties (continued)
DescriptionValueTypeProperty Name
Specifies the LOB table for using BLOB columns.See “LOB Table
Name Properties”
(page 25).
StringblobTableName
Specifies the LOB table for using CLOB columns.See “LOB Table
Name Properties”
(page 25).
StringclobTableName
Sets the transaction mode, which provides control over
how and when transactions are performed. See
“transactionMode Property” (page 28).
See
“transactionMode
Property”
(page 28).
StringtransactionMode
NOTE: Do not add the jdbcmx. prefix to the property name when the properties are given as a
parameter to the connection method or when using the data source. The prefix is not needed to
identify the property type because the property is being passed to a JDBC/MX driver object. Use
the jdbcmx prefix only in the command line, as described under “Setting Properties in the Command
Line” (page 30).
JdbcRowSet Implementation
An implementation of the JdbcRowSet interface, SQLMXJdbcRowSet, is provided within the
com.tandem.sqlmx package. A JdbcRowSet object maintains a connection to the database,
similar to a ResultSet object. However, a JdbcRowSet object maintains a set of properties
and listener notification mechanisms that make it a JavaBeans™ component.
The SQLMXJdbcRowSet object can be created using these SQLMXJdbcRowSet constructors:
• The default constructor that does not require any parameters.
NOTE: This constructor does not attempt to connect to the database until the execute
method is invoked.
• The constructor that takes a Connection object.
• The constructor that takes a ResultSet object.
• The constructor that takes a url, username, and password.
NOTE: Username and password attributes are currently not supported. This constructor has
been provided for future use after the username and password support has been provided by
both SQL/MX and JDBC/MX.
Refer to the JdbcRowSetSample.java demo program as an example of instantiating and
manipulating an SQLMXJdbcRowSet object. Also, refer to the Unsupported and Deviations sections
for specific implementation details of the SQLMXJdbcRowSet object.
For additional details, refer to the JdbcRowSet Interface specification at
http://docs.oracle.com/javase/1.5.0/docs/api/javax/sql/rowset/JdbcRowSet.html
JDBC/MX Properties
This section describes the JDBC/MX properties included in the DriverManager class
(Table 3 (page 21)) and the DataSource Object Properties (Table 4 (page 22)).
• “Default Catalog and Schema” (page 25)
• “LOB Table Name Properties” (page 25)
• “ISO88591 Property” (page 26)
24 Accessing SQL Databases with SQL/MX