Programming Assignment #8
Storing XML in a Relational Database

Due on Thursday April 16 before midnight.


Description

This project must be done individually. No copying is permitted. The purpose of this project is to learn how to store XML data in a relational database.

Platform

You will do this project on Omega using JDBC on mySQL. You can find information about JDBC in the class slides (Web Programming with Servlets). See also the file mysql.java. You first need to download the mySQL JDBC driver on your Omega directory. Then edit the file mysql.java on Omega so that it uses your own username/password and run it using:

javac mysql.java
java -cp .:mysql-connector-java.jar SQL
(make sure that the directory /opt/jdk1.6.0_03/bin/ is in your PATH).

Project Requirements

You will use the XML file from Project #7 that describes auctions:

You need to parse this file and store it into a relational database. More specifically:

What to Submit

Use the form below to submit your java file and your relational schema:


Submit this file:


Last modified: 04/14/09 by Leonidas Fegaras