Programming Assignment #8
Storing XML in a Relational Database

Due on Thursday April 16 before midnight.


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.


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 You first need to download the mySQL JDBC driver on your Omega directory. Then edit the file on Omega so that it uses your own username/password and run it using:

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