You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Reid Thompson <Re...@ateb.com> on 2004/07/05 19:50:17 UTC

Tutorial 9 broken

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] 


thanks,
reid



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org

Re: Tutorial 9 broken

Posted by David Sean Taylor <da...@bluesunrise.com>.
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: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org