JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Table 4 DataSource Object Properties (continued)
DescriptionValueTypeProperty Name
Specifies the LOB table for using BLOB columns.See “LOB Table
Name Properties”
(page 26).
StringblobTableName
Specifies the LOB table for using CLOB columns.See “LOB Table
Name Properties”
(page 26).
StringclobTableName
Sets the transaction mode, which provides control over
how and when transactions are performed. See
“transactionMode Property” (page 29).
See
“transactionMode
Property”
(page 29).
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 31).
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 22)) and the DataSource Object Properties (Table 4 (page 23)).
• “Default Catalog and Schema” (page 26)
• “LOB Table Name Properties” (page 26)
• “ISO88591 Property” (page 27)
JdbcRowSet Implementation 25