Introduction

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:

  1. the java.sql package
  2. the javax.sql package, 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:

  1. Type 4 (pure Java) implementation with database connectivity to rdm-tfs in 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: "jdbc:raima;rdm://<hostname_or_ip>"
  2. 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: "jdbc:raima:rdm://local"

More information on the connection URL and properties can be found at RDMDriver.connect().

Package java.sql

Supported Interfaces

Interface Summary    
Raima Class Implements Description
RDMBlob Blob The representation (mapping) in the Java™ programming language of an SQL BLOB value.
RDMCallableStatement CallableStatement The interface used to execute SQL stored procedures.
RDMClob Clob The mapping in the Java™ programming language for the SQL CLOB type.
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 NCLOB type.
RDMParameterMetaData ParameterMetaData An object that can be used to get information about the types and properties of the parameters in a PreparedStatement object.
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 ResultSet object.
RDMSavepoint Savepoint The representation of a savepoint, which is a point within the current transaction that can be referenced from the Connection.rollback method.
RDMStatement Statement The object used for executing a static SQL statement and returning the results it produces.

Unsupported Interfaces

  • Array
  • Ref
  • RowId
  • SQLData
  • SQLOutput
  • SQLXML
  • Struct

Package javax.sql

Supported Interfaces

Interface Summary    
Raima Class Implements Description
RDMConnectionPoolDataSource ConnectionPoolDataSource A factory for PooledConnection objects.
RDMDataSource DataSource A factory for connections to the physical data source that this DataSource object represents.
RDMPooledConnection PooledConnection An object that provides hooks for connection pool management.

Unsupported Interfaces

  • ConnectionEventListener
  • RowSet
  • RowSetInternal
  • RowSetListener
  • RowSetMetaData
  • RowSetReader
  • RowSetWriter
  • StatementEventListener
  • XAConnection
  • XADataSource