SQL Database Access Agent
Overview
The SQL Database Access Agent provides an OAA query service
for relational databases. The design of the agent was inspired
by the JDBC (Java Database Connectivity) API and provides
similar functionality for OAA users. It was developed to
support the BioSPICE Data Warehouse effort at SRI but it is
of generic utility and can be used to access data of any
kind.
Note: due to its project origins, this agent is referred to in many places
in this documentation and source code as the "BioSPICE DB Agent".
The current implementation has been
tested using Oracle 8.1.7, PostgreSQL 7.2.1, and
MySQL Ver 11.17 Distrib 3.23.49a. A properties file is
used to set the JDBC driver and connection URL at
runtime so the DBAgent should work with any database
for which there is an available JDBC driver.
Download
SQL Database Agent's API Documentation (Java Doc).
Build instructions.
Tutorial.
Jar distribution.
Source code distribution (zip file).
Source code distribution (.tar.gz file)