On Jul 5, 2004, at 10:50 AM, Reid Thompson wrote:
Tutorial 9 is broken in JETSPEED-RELEASE-1-5-FINAL. Is there a
functional version of Tutorial 9 available for download?
On the advanced tutorials, Coffees Browser populates fine but clicking
on the EDIT link produces:
org.apache.torque.TorqueException: Table not found: CAFE in statement
[SELECT CAFE.CAFE_ID, CAFE.CAFE_NAME, CAFE.SUPPLIER_ID, CAFE.PRICE,
CAFE.SALES, CAFE.TOTAL FROM CAFE WHERE CAFE.CAFE_ID=1]
Sorry, I seem to have missed the database population in the tutorial.
try adding this to your jetspeed.script:
drop table CAFE if exists;
CREATE TABLE CAFE
(
CAFE_ID integer IDENTITY,
CAFE_NAME VARCHAR (50),
SUPPLIER_ID integer,
PRICE FLOAT,
SALES integer,
TOTAL integer,
PRIMARY KEY(CAFE_ID)
);
INSERT INTO CAFE VALUES(1,'ColombianGrade',5,7.99E0,1,2)
INSERT INTO CAFE VALUES(2,'KonaGrade',6,7.99E0,1,2)
INSERT INTO CAFE VALUES(3,'FrenchRoastGrade',7,7.99E0,1,2)
INSERT INTO CAFE VALUES(4,'HazelNutGrade',8,7.99E0,1,2)
INSERT INTO CAFE VALUES(5,'VanillaGrade',9,7.99E0,1,2)
INSERT INTO CAFE VALUES(6,'JavaGrade',10,7.99E0,1,2)
INSERT INTO CAFE VALUES(7,'IndonesianGrade',11,7.99E0,1,2)
INSERT INTO CAFE VALUES(8,'OotyGrade',1,7.99E0,1,2)
INSERT INTO CAFE VALUES(9,'KenyanGrade',2,7.99E0,1,2)
INSERT INTO CAFE VALUES(10,'JoeGrade',3,7.99E0,1,2)
"script.txt" [dos] 24L, 903C
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
