DBMS Documents

Some Useful SQL Tutorials on the Web

Postgesql Documents

For RIT CS custom stuff, refer to the following document:
    Your CS Postgresql Account
For Java/JDBC programs, you will need to download this file and keep it in your CLASSPATH:
    postgresql-9.1-902.jdbc4.jar

The following version of my standard CRUD program should work with the CS Department's installation of Postgresql. Of course, you will need to change the database name (if it is different), and you will need to use your own Postgresql account with your own password.

    Crud.java (Postgresql version)
The DDL script needed to set up the needed student table for the above program is available at init.sql (Postgresql version).

The following directory contains examples of sample trigger and stored procedure in Postgresql (also includes a create table to help test the samples).

    Sample Trigger and Stored Procedure (Postgresql version)

Oracle 10 Documents

For RIT CS custom stuff, refer to the following document, which was adapted from Kurt Mosiejczuk:
    Your CS Oracle Account
You need to have your Java CLASSPATH set appropriately too. Users of csh can do this using by source the following file:
    source /usr/local/bin/coraenv

The following version of my standard CRUD program should work with the CS Department's installation of Oracle. Of course, you will need to change the database name (if it is different), and you will need to use your own Oracle account with your own password.

    Crud.java (Oracle version)

The following directory contains examples of sample trigger and stored procedure in Oracle (also includes a create table to help test the samples).

    Sample Trigger and Stored Procedure (Oracle version)

The following directory contains a more involved example of a stored procedure (actually a function) that returns a rowset to be iterated over by a Java/JDBC program.

    Sample Stored Function (purely Oracle version) and Usage

MS Access under Windows XP

Assuming you have the standard Windows ODBC driver installed, as well as the latest version of Java (J2SE 1.4 or later), the following version of CRUD should work. Change the database name appropriately. See also the comments about this program below under Informix.
    Crud.java (MS_Access version)

DB2 Documents

Placeholder.

Informix Documents (Only of Historical Interest Now)

Browse and search through these files on-line. You'll find it convenient to read and search for keywords in a PDF document.
    DO NOT PRINT the documents: they are BIG!!!

Informix Usage

If you are planning to use Informix, you will need to get a new database set up for your project so email your instructor with names and CS Unix ids of every member of your team. Your Solaris accounts will work for Informix so you will not need any special accounts, but run the two scripts described below (it would be appropriate to include both scripts in your .cshrc file).

To use Informix, you will need to understand how to use dbaccess and how to connect to Informix from your Java programs.