The Java Database Connectivity (JDBC) API provides universal data access from the Java programming language. Application developers can use the JDBC 3.0 API driver for RDM to write database applications and execute SQL statements.
The JDBC 3.0 API is comprised of two packages:
javax.sqlpackage, which adds server-side capabilities
The RDM driver is a JDBC 4 Type V driver.
The RDM database management system uses the driver in one of two modes. As a:
- Type 4 (pure Java) implementation with database connectivity to
rdm-tfsin local and distributed transactions. Just add the RDM jdbc jar to the
classpath. When communicating directly with the database server in this mode utilize the connection URL as follows: "
- Type 2 (native-API driver) with local transactions. Commonly referred to as RDM Direct Link configuration [link to TFS server configurations] . In this configuration add the jar and client side library (
rdmjdbc-14.jar) to be operational. Connection via the Direct Link mode is as follows: "
More information on the connection URL and properties can be found at RDMDriver.connect().
|RDMBlob||Blob||The representation (mapping) in the Java™ programming language of an SQL
|RDMCallableStatement||CallableStatement||The interface used to execute SQL stored procedures.|
|RDMClob||Clob||The mapping in the Java™ programming language for the SQL
|RDMConnection||Connection||A connection (session) with a specific database.|
|RDMDatabaseMetaData||DatabaseMetaData||Comprehensive information about the database as a whole.|
|RDMDriver||Driver||The interface that every driver class must implement.|
|RDMNClob||NClob||The mapping in the Java™ programming language for the SQL
|RDMParameterMetaData||ParameterMetaData||An object that can be used to get information about the types and properties of the parameters in a
|RDMPreparedStatement||PreparedStatement||An object that represents a precompiled SQL statement.|
|RDMResultSet||ResultSet||A table of data representing a database result set, which is usually generated by executing a statement that queries the database.|
|RDMResultSetMetaData||ResultSetMetaData||An object that can be used to get information about the types and properties of the columns in a
|RDMSavepoint||Savepoint||The representation of a savepoint, which is a point within the current transaction that can be referenced from the
|RDMStatement||Statement||The object used for executing a static SQL statement and returning the results it produces.|
|RDMConnectionPoolDataSource||ConnectionPoolDataSource||A factory for
|RDMDataSource||DataSource||A factory for connections to the physical data source that this
|RDMPooledConnection||PooledConnection||An object that provides hooks for connection pool management.|