JDBC Data Resource Accessor

Overview

The JDBC data resource accessor allows data service resources to expose a single JDBC-enabled relational database.

Resource Properties

The JDBC data resource accessor provides the following property for any data service resource which uses it:

{https://ogsadai.org.uk/namespaces/2005/10/properties}productInfo - information on the database, including name, vendor and version.

In addition the service deployer may provide application-specific metadata properties in the data resource accessor configuration files (see below).

Class

This data resource accessor is implemented by the following Java class:

uk.org.ogsadai.dataresource.JDBCDataResourceAccessor

Interfaces

This data resource accessor implements the following interfaces:

• uk.org.ogsadai.dataresource.JDBCConnectionProvider

Configuration

Any data service resource using a JDBC data resource accessor uses the following configuration files:

• A data resource configuration file which specifies information about the database managed by the data resource accessor. This includes the connection URL, the driver class name and database meta data.
• A role map file which maps client credentials to database usernames and passwords and provides a means of authorising database accesses.

These files are constructed automatically by the tools we provide to deploy data service resources. However, if you are interested, a detailed description of these files can be found on this page.