C:\java\j2sdkee1.3\jps1.1.1\database.sql>populate C:\java\j2sdkee1.3\jps1.1.1\database.sql>set J2EE_HOME=C:\java\j2sdkee1.2.1 C:\java\j2sdkee1.3\jps1.1.1\database.sql>java -Dcloudscape.system.home=C:\java\j 2sdkee1.2.1\cloudscape -classpath .;populate.jar;C:\java\j2sdkee1.2.1\lib\clouds cape\client.jar;C:\java\j2sdkee1.2.1\lib\cloudscape\tools.jar;C:\java\j2sdkee1.2 .1\lib\cloudscape\cloudscape.jar;C:\java\j2sdkee1.2.1\lib\cloudscape\RmiJdbc.jar ;C:\java\j2sdkee1.2.1\lib\cloudscape\license.jar;C:\java\j2sdkee1.2.1\lib\j2ee.j ar PopulateTables cloudscape.sql ASCII localhost PopulateTables v1.0 Loading cloudscape.sql Connecting to localhost Connection is RmiJdbc.RJConnection@5f073d Querry=drop table lineitem 0 row(s) updated/inserted/deleted Querry=drop table orderstatus 0 row(s) updated/inserted/deleted Querry=drop table orders 0 row(s) updated/inserted/deleted Querry=drop table account 0 row(s) updated/inserted/deleted Querry=drop table profile 0 row(s) updated/inserted/deleted Querry=drop table bannerdata 0 row(s) updated/inserted/deleted Querry=drop table inventory 0 row(s) updated/inserted/deleted Querry=drop table item 0 row(s) updated/inserted/deleted Querry=drop table product 0 row(s) updated/inserted/deleted Querry=drop table category 0 row(s) updated/inserted/deleted Querry=drop table supplier Caught : SQL Exception: Operation 'DROP CONSTRAINT' cannot be performed on objec t 'PK_SUPPLIER' because CONSTRAINT 'FK_ITEM_2_JA' is dependent on that object. Querry=drop table sequence 0 row(s) updated/inserted/deleted Querry=create table supplier ( suppid int not null, name varchar(80) null, status char(2) not null, addr1 varchar(80) null, addr2 varchar(80) null, city varchar(80) null, state varchar(80) null, zip char(5) null, phone varchar(80) null, constraint pk_supplier primary key (suppid) ) Caught : SQL Exception: Table or view 'SUPPLIER' already exists in schema 'APP'. Querry=create table account ( userid varchar(80) not null, email varchar(80) not null, firstname varchar(80) not null, lastname varchar(80) not null, status char(2) null, addr1 varchar(80) not null, addr2 varchar(40) null, city varchar(80) not null, state varchar(80) not null, zip varchar(20) not null, country varchar(20) not null, phone varchar(80) not null, constraint pk_account primary key (userid) ) 0 row(s) updated/inserted/deleted Querry=create table profile ( userid varchar(80) not null, langpref varchar(80) not null, favcategory varchar(30), mylistopt int, banneropt int, constraint pk_profile primary key (userid) ) 0 row(s) updated/inserted/deleted Querry=create table bannerdata ( favcategory varchar(80) not null, bannername varchar(255) null, constraint pk_bannerdata primary key (favcategory) ) 0 row(s) updated/inserted/deleted Querry=create table orders ( orderid int not null, userid varchar(80) not null, orderdate date not null, shipaddr1 varchar(80) not null, shipaddr2 varchar(80) null, shipcity varchar(80) not null, shipstate varchar(80) not null, shipzip varchar(20) not null, shipcountry varchar(20) not null, billaddr1 varchar(80) not null, billaddr2 varchar(80) null, billcity varchar(80) not null, billstate varchar(80) not null, billzip varchar(20) not null, billcountry varchar(20) not null, courier varchar(80) not null, totalprice decimal(10, 2) not null, billtofirstname varchar(80) not null, billtolastname varchar(80) not null, shiptofirstname varchar(80) not null, shiptolastname varchar(80) not null, creditcard varchar(80) not null, exprdate char(7) not null, cardtype varchar(80) not null, constraint pk_orders primary key (orderid), constraint fk_orders_1 foreign key (userid) references account (userid) ) 0 row(s) updated/inserted/deleted Querry=create table orderstatus ( orderid int not null, linenum int not null, updatedate date not null, status char(2) not null, constraint pk_orderstatus primary key (orderid, linenum), constraint fk_orderstatus_1 foreign key (orderid) references orders (orderid) ) 0 row(s) updated/inserted/deleted Querry=create table category ( catid char(10) not null, name varchar(80) null, descn varchar(255) null, constraint pk_category primary key (catid) ) 0 row(s) updated/inserted/deleted Querry=create table product ( productid char(10) not null, category char(10) not null, name varchar(80) null, descn varchar(255) null, constraint pk_product primary key (productid), constraint fk_product_1 foreign key (category) references category (catid) ) 0 row(s) updated/inserted/deleted Querry=create table item ( itemid char(10) not null, productid char(10) not null, listprice decimal(10,2) null, unitcost decimal(10,2) null, supplier int null, status char(2) null, attr1 varchar(80) null, attr2 varchar(80) null, attr3 varchar(80) null, attr4 varchar(80) null, attr5 varchar(80) null, constraint pk_item primary key (itemid), constraint fk_item_1 foreign key (productid) references product (productid), constraint fk_item_2 foreign key (supplier) references supplier (suppid) ) 0 row(s) updated/inserted/deleted Querry=create table inventory ( itemid char(10) not null, qty int not null ) 0 row(s) updated/inserted/deleted Querry=create table lineitem ( orderid int not null, linenum int not null, itemid char(10) not null, quantity int not null, unitprice decimal(10,2) not null, constraint pk_lineitem primary key (orderid, linenum), constraint fk_lineitem_1 foreign key (orderid) references orders (orderid) ) 0 row(s) updated/inserted/deleted Querry=create table sequence ( seqnum int not null ) 0 row(s) updated/inserted/deleted Querry=INSERT INTO sequence values (1) Processed Querry=INSERT INTO sequence values (1) 1 row(s) updated/inserted/deleted Querry=INSERT INTO account VALUES('j2ee','yourname@yourdomain.com','ABC', 'XYZ', 'OK', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', '555-555-5555') Processed Querry=INSERT INTO account VALUES(?,?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO profile VALUES('j2ee','English','dogs','1','1') Processed Querry=INSERT INTO profile VALUES(?,?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO bannerdata VALUES ('fish','') Processed Querry=INSERT INTO bannerdata VALUES (?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO bannerdata VALUES ('cats','') Processed Querry=INSERT INTO bannerdata VALUES (?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO bannerdata VALUES ('dogs','') Processed Querry=INSERT INTO bannerdata VALUES (?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO bannerdata VALUES ('reptiles','') Processed Querry=INSERT INTO bannerdata VALUES (?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO bannerdata VALUES ('birds','') Processed Querry=INSERT INTO bannerdata VALUES (?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO category VALUES ('FISH','Fish',' Fish') Processed Querry=INSERT INTO category VALUES (?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO category VALUES ('DOGS','Dogs',' Dogs') Processed Querry=INSERT INTO category VALUES (?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO category VALUES ('REPTILES','Reptiles',' Reptiles') Processed Querry=INSERT INTO category VALUES (?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO category VALUES ('CATS','Cats',' Cats') Processed Querry=INSERT INTO category VALUES (?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO category VALUES ('BIRDS','Birds',' Birds') Processed Querry=INSERT INTO category VALUES (?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('FI-SW-01','FISH','Angelfish','Salt Water fish from Australia') Processed Querry=INSERT INTO product VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('FI-SW-02','FISH','Tiger Shark','Salt Water fish from Australia') Processed Querry=INSERT INTO product VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('FI-FW-01','FISH', 'Koi','Fresh Water fish from Japan') Processed Querry=INSERT INTO product VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('FI-FW-02','FISH', 'Goldfish','Fresh Water fish from China') Processed Querry=INSERT INTO product VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('K9-BD-01','DOGS','Bulldog','Friendly dog from England') Processed Querry=INSERT INTO product VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('K9-PO-02','DOGS','Poodle','Cute dog from France') Processed Querry=INSERT INTO product VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('K9-DL-01','DOGS', 'Dalmation','Great dog for a Fire Station') Processed Querry=INSERT INTO product VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('K9-RT-01','DOGS', 'Golden Retriever','Great family dog') Processed Querry=INSERT INTO product VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('K9-RT-02','DOGS', 'Labrador Retriever','Great hunting dog') Processed Querry=INSERT INTO product VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('K9-CW-01','DOGS', 'Chihuahua','Great companion dog') Processed Querry=INSERT INTO product VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('RP-SN-01','REPTILES','Rattlesnake','Doubles as a watch dog') Processed Querry=INSERT INTO product VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('RP-LI-02','REPTILES','Iguana','Friendly green friend') Processed Querry=INSERT INTO product VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('FL-DSH-01','CATS','Manx','Great for reducing mouse populations') Processed Querry=INSERT INTO product VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('FL-DLH-02','CATS','Persian','Friendly house cat, doubles as a princess') Processed Querry=INSERT INTO product VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('AV-CB-01','BIRDS','Amazon Parrot','Great companion for up to 75 years') Processed Querry=INSERT INTO product VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product VALUES ('AV-SB-02','BIRDS','Finch','Great stress reliever') Processed Querry=INSERT INTO product VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO supplier VALUES (1,'XYZ Pets','AC','600 Avon Way','','Los Angeles','CA','94024','212-947-0797') Processed Querry=INSERT INTO supplier VALUES (1,?,?,?,?,?,?,?,?) Caught : SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint. Querry=INSERT INTO supplier VALUES (2,'ABC Pets','AC','700 Abalone Way','','San Francisco ','CA','94024','415-947-0797') Processed Querry=INSERT INTO supplier VALUES (2,?,?,?,?,?,?,?,?) Caught : SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint. Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-1','FI-SW-01',16.50,10.00,1,'P','Large') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,16.50,10.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-2','FI-SW-01',16.50,10.00,1,'P','Small') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,16.50,10.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-3','FI-SW-02',18.50,12.00,1,'P','Toothless') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-4','FI-FW-01',18.50,12.00,1,'P','Spotted') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-5','FI-FW-01',18.50,12.00,1,'P','Spotless') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-6','K9-BD-01',18.50,12.00,1,'P','Male Adult') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-7','K9-BD-01',18.50,12.00,1,'P','Female Puppy') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-8','K9-PO-02',18.50,12.00,1,'P','Male Puppy') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-9','K9-DL-01',18.50,12.00,1,'P','Spotless Male Puppy') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-10','K9-DL-01',18.50,12.00,1,'P','Spotted Adult Female') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-11','RP-SN-01',18.50,12.00,1,'P','Venomless') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-12','RP-SN-01',18.50,12.00,1,'P','Rattleless') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-13','RP-LI-02',18.50,12.00,1,'P','Green Adult') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,18.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-14','FL-DSH-01',58.50,12.00,1,'P','Tailless') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,58.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-15','FL-DSH-01',23.50,12.00,1,'P','With tail') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,23.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-16','FL-DLH-02',93.50,12.00,1,'P','Adult Female') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,93.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-17','FL-DLH-02',93.50,12.00,1,'P','Adult Male') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,93.50,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-18','AV-CB-01',193.50,92.00,1,'P','Adult Male') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,193.50,92.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-19','AV-SB-02',15.50, 2.00,1,'P','Adult Male') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,15.50, 2.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-20','FI-FW-02',5.50, 2.00,1,'P','Adult Male') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,5.50, 2.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-21','FI-FW-02',5.29, 1.00,1,'P','Adult Female') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,5.29, 1.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-22','K9-RT-02',135.50, 100.00,1,'P','Adult Male') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,135.50, 100.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-23','K9-RT-02',145.49, 100.00,1,'P','Adult Female') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,145.49, 100.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-24','K9-RT-02',255.50, 92.00,1,'P','Adult Male') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,255.50, 92.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-25','K9-RT-02',325.29, 90.00,1,'P','Adult Female') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,325.29, 90.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-26','K9-CW-01',125.50, 92.00,1,'P','Adult Male') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,125.50, 92.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-27','K9-CW-01',155.29, 90.00,1,'P','Adult Female') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,155.29, 90.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supplier, stat us, attr1) VALUES ('EST-28','K9-RT-01',155.29, 90.00,1,'P','Adult Female') Processed Querry=INSERT INTO item (itemid, productid, listprice, unitcost, supp lier, status, attr1) VALUES (?,?,155.29, 90.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-1',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-2',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-3',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-4',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-5',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-6',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-7',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-8',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-9',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-10',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-11',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-12',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-13',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-14',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-15',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-16',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-17',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-18',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-19',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-20',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-21',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-22',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-23',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-24',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-25',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-26',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-27',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted Querry=INSERT INTO inventory (itemid, qty ) VALUES ('EST-28',10) Processed Querry=INSERT INTO inventory (itemid, qty ) VALUES (?,10) 1 row(s) updated/inserted/deleted C:\java\j2sdkee1.3\jps1.1.1\database.sql>java -Dcloudscape.system.home=C:\java\j 2sdkee1.2.1\cloudscape -classpath .;populate.jar;C:\java\j2sdkee1.2.1\lib\clouds cape\client.jar;C:\java\j2sdkee1.2.1\lib\cloudscape\tools.jar;C:\java\j2sdkee1.2 .1\lib\cloudscape\cloudscape.jar;C:\java\j2sdkee1.2.1\lib\cloudscape\RmiJdbc.jar ;C:\java\j2sdkee1.2.1\lib\cloudscape\license.jar;C:\java\j2sdkee1.2.1\lib\j2ee.j ar PopulateTables cloudscape_tables.sql ASCII localhost PopulateTables v1.0 Loading cloudscape_tables.sql Connecting to localhost Connection is RmiJdbc.RJConnection@5f073d Querry=drop table item_ja 0 row(s) updated/inserted/deleted Querry=drop table product_ja 0 row(s) updated/inserted/deleted Querry=drop table category_ja 0 row(s) updated/inserted/deleted Querry=create table category_ja ( catid char(10) not null, name varchar(80) null, descn varchar(255) null, constraint pk_category_ja primary key (catid) ) 0 row(s) updated/inserted/deleted Querry=create table product_ja ( productid char(10) not null, category char(10) not null, name varchar(80) null, descn varchar(255) null, constraint pk_product_ja primary key (productid), constraint fk_product_1_ja foreign key (category) references category_ja (catid) ) 0 row(s) updated/inserted/deleted Querry=create table item_ja ( itemid char(10) not null, productid char(10) not null, listprice decimal(10,2) null, unitcost decimal(10,2) null, supplier int null, status char(2) null, attr1 varchar(80) null, attr2 varchar(80) null, attr3 varchar(80) null, attr4 varchar(80) null, attr5 varchar(80) null, constraint pk_item_ja primary key (itemid), constraint fk_item_1_ja foreign key (productid) references product_ja (productid), constraint fk_item_2_ja foreign key (supplier) references supplier (suppid) ) 0 row(s) updated/inserted/deleted C:\java\j2sdkee1.3\jps1.1.1\database.sql>java -Dcloudscape.system.home=C:\java\j 2sdkee1.2.1\cloudscape -classpath .;populate.jar;C:\java\j2sdkee1.2.1\lib\clouds cape\client.jar;C:\java\j2sdkee1.2.1\lib\cloudscape\tools.jar;C:\java\j2sdkee1.2 .1\lib\cloudscape\cloudscape.jar;C:\java\j2sdkee1.2.1\lib\cloudscape\RmiJdbc.jar ;C:\java\j2sdkee1.2.1\lib\cloudscape\license.jar;C:\java\j2sdkee1.2.1\lib\j2ee.j ar PopulateTables cloudscape_ja.sql SJIS localhost PopulateTables v1.0 Loading cloudscape_ja.sql Connecting to localhost Connection is RmiJdbc.RJConnection@546e25 Querry=DELETE FROM item_ja 0 row(s) updated/inserted/deleted Querry=DELETE FROM product_ja 0 row(s) updated/inserted/deleted Querry=DELETE FROM category_ja 0 row(s) updated/inserted/deleted Querry=INSERT INTO category_ja VALUES ('FISH','‹›',' ‹›') Processed Querry=INSERT INTO category_ja VALUES (?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO category_ja VALUES ('DOGS','Œ’',' Œ’') Processed Querry=INSERT INTO category_ja VALUES (?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO category_ja VALUES ('REPTILES','ΰ¦’Ž—ή','ΰ¦’Ž—ή') Processed Querry=INSERT INTO category_ja VALUES (?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO category_ja VALUES ('CATS','”L',' ”L') Processed Querry=INSERT INTO category_ja VALUES (?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO category_ja VALUES ('BIRDS','’Ή','’Ή') Processed Querry=INSERT INTO category_ja VALUES (?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('FI-SW-01','FISH','Angel‹›','Salt Water ‹› from Australia') Processed Querry=INSERT INTO product_ja VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('FI-SW-02','FISH','Tiger Shark','Salt Water ‹› from Australia') Processed Querry=INSERT INTO product_ja VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('FI-FW-01','FISH', 'Œο','Fresh Water ‹› from Japan') Processed Querry=INSERT INTO product_ja VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('FI-FW-02','FISH', '‹ΰ‹›','Fresh Water ‹› from China') Processed Querry=INSERT INTO product_ja VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('K9-BD-01','DOGS','Bulldog','Friendly dog from England') Processed Querry=INSERT INTO product_ja VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('K9-PO-02','DOGS','Poodle','Cute dog from France') Processed Querry=INSERT INTO product_ja VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('K9-DL-01','DOGS', 'Dalmation','Great dog for a Fire Station') Processed Querry=INSERT INTO product_ja VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('K9-RT-01','DOGS', 'Golden Retriever','Great family dog') Processed Querry=INSERT INTO product_ja VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('K9-RT-02','DOGS', 'Labrador Retriever','< image src="../images/dog5.gif">Great hunting dog') Processed Querry=INSERT INTO product_ja VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('K9-CW-01','DOGS', 'Chihuahua','Great companion dog') Processed Querry=INSERT INTO product_ja VALUES (?,?, ?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('RP-SN-01','REPTILES','ƒKƒ‰ƒKƒ‰ŽΦ','Doubles as a watch dog') Processed Querry=INSERT INTO product_ja VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('RP-LI-02','REPTILES','Iguana','Friendly green friend') Processed Querry=INSERT INTO product_ja VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('FL-DSH-01','CATS','Manx','Great for reducing mouse populations') Processed Querry=INSERT INTO product_ja VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('FL-DLH-02','CATS','Persian','Friendly house cat, doubles as a princess') Processed Querry=INSERT INTO product_ja VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('AV-CB-01','BIRDS','Amazon Parrot','Great companion for up to 75 years') Processed Querry=INSERT INTO product_ja VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO product_ja VALUES ('AV-SB-02','BIRDS','Finch','Great stress reliever') Processed Querry=INSERT INTO product_ja VALUES (?,?,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-1','FI-SW-01',11650,10.00,1,'P','Large') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,11650,10.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-2','FI-SW-01',11650,10.00,1,'P','Small') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,11650,10.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-3','FI-SW-02',18350,12.00,1,'P','Toothless') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,18350,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-4','FI-FW-01',18350,12.00,1,'P','Spotted') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,18350,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-5','FI-FW-01',14850,12.00,1,'P','Spotless') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,14850,12.00,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-6','K9-BD-01',14950,1200,1,'P','Male Adult') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,14950,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-7','K9-BD-01',18250,1200,1,'P','Female Puppy') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,18250,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-8','K9-PO-02',18150,1200,1,'P','Male Puppy') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,18150,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-9','K9-DL-01',10850,1200,1,'P','Spotless Male Puppy') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,10850,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-10','K9-DL-01',10850,1200,1,'P','Spotted Adult Female ') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,10850,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-11','RP-SN-01',2050,1200,1,'P','Venomless') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,2050,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-12','RP-SN-01',1850,1200,1,'P','Rattleless') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,1850,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-13','RP-LI-02',1950,1200,1,'P','Green Adult') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,1950,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-14','FL-DSH-01',5850,1200,1,'P','Tailless') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,5850,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-15','FL-DSH-01',2350,1200,1,'P','With tail') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,2350,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-16','FL-DLH-02',9350,1200,1,'P','Adult Female') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,9350,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-17','FL-DLH-02',9350,1200,1,'P','Adult Male') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,9350,1200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-18','AV-CB-01',19350,9200,1,'P','Adult Male') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,19350,9200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-19','AV-SB-02',14550, 200,1,'P','Adult Male') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,14550, 200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-20','FI-FW-02',550, 200,1,'P','Adult Male') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,550, 200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-21','FI-FW-02',529, 100,1,'P','Adult Female') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,529, 100,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-22','K9-RT-02',13550, 10000,1,'P','Adult Male') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,13550, 10000,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-23','K9-RT-02',14549, 10000,1,'P','Adult Female') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,14549, 10000,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-24','K9-RT-02',25550, 9200,1,'P','Adult Male') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,25550, 9200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-25','K9-RT-02',32529, 9000,1,'P','Adult Female') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,32529, 9000,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-26','K9-CW-01',12550, 9200,1,'P','Adult Male') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,12550, 9200,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-27','K9-CW-01',15529, 9000,1,'P','Adult Female') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,15529, 9000,1,?,?) 1 row(s) updated/inserted/deleted Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, supplier, s tatus, attr1) VALUES ('EST-28','K9-RT-01',15529, 9000,1,'P','Adult Female') Processed Querry=INSERT INTO item_ja (itemid, productid, listprice, unitcost, s upplier, status, attr1) VALUES (?,?,15529, 9000,1,?,?) 1 row(s) updated/inserted/deleted C:\java\j2sdkee1.3\jps1.1.1\database.sql>