Recitation #2 Slides

The slides for the second recitation (r2) are available through the link below:

http://www-student.cse.buffalo.edu/~dlessa/cse462-SP10/r2.pdf

The two sample source files can be downloaded from here:

http://www-student.cse.buffalo.edu/~dlessa/cse462-SP10/DBTest.java
http://www-student.cse.buffalo.edu/~dlessa/cse462-SP10/JDBCTest02.java

From nickelback (timberlake), you can compile and run these files as follows:

1. Configure the environment:

> source /util/oracle/coraenv.sh

2. Compile the files:

> javac DBTest.java
> javac JDBCTest02.java

3. Run the files:

> java DBTest
> java JDBCTest02

Regards,

Demian Lessa

Recitation #1 Slides

The slides for the first recitation (r1) are available through the link below:

http://www-student.cse.buffalo.edu/~dlessa/cse462-SP10/r1.pdf

A few slides were added with additional information about the various constraint types. If you have any questions, be sure to e-mail me or stop by my office hours.

Regards,

Demian Lessa

Connecting to Oracle

Instructions: Connecting to the Course's Oracle Database (courtesy of Demian Lessa)

In this course, you will use the SQL*Plus command line client to
interact with an Oracle 11g database. In order to connect to the
database, follow the instructions below.

1. Connect to nickelback (if you are on campus) or timberlake (if you
are off campus). For instance:

> ssh dlessa@timberlake.cse.buffalo.edu
password:

timberlake:~


2. Define the environment variables ORACLE_HOME and TWO_TASK:

timberlake:~ setenv ORACLE_HOME /util/oracle/product/current/

client_1
timberlake:~ setenv TWO_TASK aos.buffalo.edu


3. Start SQL*Plus. You will be prompted for credentials. Use your UBIT
user name (the same you used to log on in step 1) for user-name and for
your password, choose either cse462r1 or cse462r2, according to the
recitation which you registered for.

timberlake:~ sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Jan 18 12:58:18 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.

Enter user-name: dlessa
Enter password:

Connected to: Oracle Database 11g Enterprise Edition Release
11.1.0.7.0 - 64bit Production with the Partitioning, OLAP,
Data Mining and Real Application Testing options

SQL>


4. Because all passwords are standard, you should change your password
as soon as you login. Simply type 'password' on the command prompt and
provide the old and new passwords as requested:

SQL> password
Changing password for DLESSA
Old password:
New password:
Retype new password:
Password changed

SQL>


5. In order to close your SQL*Plus session, type 'quit' on the command
prompt:

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release
11.1.0.7.0 - 64bit Production with the Partitioning, OLAP, Data
Mining and Real Application Testing options

timberlake:~


For further information, refer to the CSE wiki Oracle page:

https://wiki.cse.buffalo.edu/services/content/oracle

If you still cannot get it to work, stop by my office hours.

Regards,

Demian Lessa

Welcome to CSE 462!

This is the official course blog of CSE 462 Database Concepts. It will be used for course announcements and discussions.