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 RaimaDB 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 RaimaDB driver is a JDBC 4 Type V driver.

The RaimaDB database management system uses the driver in one of the two following modes:

  1. Type 4 (pure Java) implementation with database connectivity to rdm-tfs. To use the RaimaDB JDBC driver in this mode:
    • Add the driver (rdmjdbc-16.jar) to the classpath
    • Specify the host name (and optionally the rdm-tfs name) in the connection string: "jdbc:raima;rdm://hostname[:rdmtfsname]". For example, to connect to rdm-tfs running on localhost using port 21553, specify "jdbc:raima:rdm://localhost:21553".
  2. Type 2 (Native API driver) with embedded (local) rdm-tfs. Commonly referred to as RaimaDB Direct Link configuration. To use the RaimaDB JDBC driver in this mode:
    • Add the driver (rdmjdbc-16.jar) to the classpath
    • Make sure the RaimaDB client libraries are in the path
    • Specify "local" as the host name in the connection string. You may not specify an rdm-tfs name. For example, "jdbc:raima:rdm://local".

For more information on the connection string for RaimaDB JDBC, see 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