Installing software needed for Homework 3
Summary
These notes will walk you through installing the programs you need
for Homework 3. We assume that you are on a Windows machine.
- Java
- PostgreSQL
- JDBC drivers for:
General notes
- You will need to access both a local PostgreSQL install and SQL
Server on IPROJSRV. Please see how to tunnel SQL
Server using SSH.
- Download the CSEP544
shell launcher script. Edit the paths in the script carefully to
make sure they match up with your system. Alternatively, you can set
your PATH and CLASSPATH variables directly without using this script.
Go to Control Panel -> System -> Advanced.
Click on the Environment Variables button, and edit these two to
reflect the location of your Java install and your JDBC jar files.
- You have to be running as admin to install these programs. In
Vista you may need to choose the "Run as Administrator" option
(right-click program executable, "Run as Adminstrator").
- If you're running a 64-bit version of Windows, you need to change
C:\Program Files
to C:\Program Files (x86)
in the "Installing PostgreSQL" section.
Installing Java
Download the Java SDK 6,
update 7 from Sun. If you already have an older version of Java on
your machine, you can just use that. However, if it is older than J2SE
5.0, it might be incompatible with the JDBC drivers and you might need
to upgrade.
Installing PostgreSQL and its JDBC driver
Follow these steps:
- Download PostgreSQL
8.3 for Windows.
- Install it with the default options. Remember the password
you entered for the "database superuser". You'll need it later.
- Now you need to install the JDBC driver. To do so, start by
running the Stack Builder program from
Start->Programs->PostgreSQL 8.3->Application Stack Builder.
- Select "PostgreSQL Database Server 8.3 on port 5432", then choose
Next.
- Open the "Database Drivers" category, check the box for "psqlJDBC
8.3.603", then choose Next.
- Choose the USA mirror, then choose Next.
- Choose Next at the confirmation window.
- Wait until you see "All the installation files have now been
successfully downloaded", then choose Next.
- This will launch the installer for the JDBC driver. Step through
it using the default options.
- Verify that the file
C:\Program
Files\psqlJDBC\postgresql-8.3-603.jdbc4.jar
exists.
Installing the JDBC driver for SQL Server
Follow these steps:
- Download the JDBC
driver from Microsoft.
You'll end up "downloading" the license agreement; scroll to the
bottom, then choose Accept to download the actual file.
(The two "Accept" links point to different archives storing the same
data; the "Windows version" is a self-extracting EXE, while the "UNIX
version" is a gzipped tarball (.tar.gz file).)
- Unpack the archive to
C:\Program Files\SQL
Server JDBC\
- Verify that the file
C:\Program Files\SQL Server
JDBC\sqljdbc_2.0\enu\sqljdbc4.jar
exists.