JDBC Type 2 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

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
.
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://download.oracle.com/javase/1.5.0/docs/api/javax/sql/rowset/JdbcRowSet.html
.
JDBC/MX Properties
JDBC/MX properties included in both the DriverManager object properties table and DataSource object
properties table are described in topics as follows:
Default Catalog and Schema
LOB Table Name Properties
ISO88591 Property
mploc Property
maxStatements Property
minPoolSize Property
maxPoolSize Property
transactionMode Property
These properties and additional properties can be specified in a command line, as described under Setting
Properties in the Command Line.
For information about using features provided by various JDBC/MX properties, see the topic, Using