I discovered one error. I was using the unix ':' from the command line
rather than the Windows ';', when I told java about the classpath for
the jar. Now, it runs as expected. The only question is how do I
straighten out Eclipse so that it does what I want it to?
C:\Documents and Settings\Scott
Spiegler\workspace\PizzaShop\build\classes>java
-classpath ../../lib/ojdbc14.jar;. pizza.SystemTest
FILE: c:\Documents and Settings\Scott
Spiegler\workspace\PizzaShop\business lay
r test.txt
admin initializes system
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
setupShop() starts here
Creating statement object
Dropping contains_a table...
Dropping has_a table...
Dropping orders table...
Dropping toppings table...
Dropping sizes table...
Dropping nextorder table...
Dropping day table...
orders table created...
toppings table created...
contains_a table created...
sizes table created...
has_a table created...
nextorder table created...
day table created...
Initializing next order table
Initializing day table
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
addToppings() starts here
Inserting into tables: insert into toppings (toppingid,topping) values
(1,'pepp
roni')
pepperoni topping was inserted.
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
addToppings() starts here
Inserting into tables: insert into toppings (toppingid,topping) values
(2,'onio
s')
onions topping was inserted.
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
addToppings() starts here
Inserting into tables: insert into toppings (toppingid,topping) values
(3,'mush
oom')
mushroom topping was inserted.
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
addToppings() starts here
Inserting into tables: insert into toppings (toppingid,topping) values
(4,'hot
eppers')
hot peppers topping was inserted.
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
addToppings() starts here
Inserting into tables: insert into toppings (toppingid,topping) values
(5,'extr
cheese')
extra cheese topping was inserted.
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
addSizes() starts here
Inserting into sizes tables: insert into sizes (sizeid,piesize) values
(1,'smal
')
small size was inserted.
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
addSizes() starts here
Inserting into sizes tables: insert into sizes (sizeid,piesize) values
(2,'medi
m')
medium size was inserted.
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
addSizes() starts here
Inserting into sizes tables: insert into sizes (sizeid,piesize) values
(3,'larg
')
large size was inserted.
student order from room 5
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
Execution Completed: select orderid from nextorder
Order #100 inserted...
Query string: insert into contains_a (orderid,toppingid) values (100,1)
Query string: insert into contains_a (orderid,toppingid) values (100,3)
Your insert into contains_a worked.
Query string: insert into has_a (orderid,sizeid) values (100,3)
Your insert into has_a worked.
Orders submitted:
Order ID Day Room Number Cooked Closed
100 1 5 0 0
student order from room 1
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
Execution Completed: select orderid from nextorder
Order #101 inserted...
Query string: insert into contains_a (orderid,toppingid) values (101,1)
Query string: insert into contains_a (orderid,toppingid) values (101,3)
Your insert into contains_a worked.
Query string: insert into has_a (orderid,sizeid) values (101,3)
Your insert into has_a worked.
Orders submitted:
Order ID Day Room Number Cooked Closed
100 1 5 0 0
101 1 1 0 0
status of orders from room n
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
Your order is not completed
baker reports pizza done
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
Cooking pizzas:
Order # 1for day 100 is cooked
status of orders from room n
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
Your order is not completed
admin status report for today
baker reports day is done
using connection string: jdbc
racle:thin
dbs2.cs.umb.edu:1521:dbs2
Connecting to the database...connected.
Ending day:
Executing: select MAX(today) from day
generate admin college report on completed days since last such report