Enterprise web programming

Modules ENTWA (Level 6) and APSW (Level 7)

PDB database specification

This document defines the main characteristics of the PDB database used in the coursework.

Access details

Database driver class oracle.jdbc.driver.OracleDriver (download JAR 1.5MB or visit the Oracle website)
URL jdbc:oracle:thin:@www.herring.mech.port.ac.uk:1521:SALMON
Username PDBRO
Password Emailed to you

The database is read-only. You should only run SELECT queries on it. Do not try to execute an INSERT or UPDATE. All accesses are logged.

To make changes to the database, make your OWN copy and apply the changes to that.

SSH tunneling can be used to make connections through the firewall.

Database structure

Entities

Table

Contains

Notes

CONTACTS

Details about an organisation that has submitted a project idea

 
IDEAS2 Details about a project idea Column PROJORG is a foreign key to CONTACTS

SQL script to recreate the database.

 

Last updated by Prof Jim Briggs of the School of Computing at the University of Portsmouth

  
The enterprise web programming modules include some material that was formerly part of the WEB1P and WEB2P units.