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:

the java.sql package
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:

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".
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