Thanks much -- last nite I went the reverse route -- I copied/modified the schema and
Caf� java files/cfg/etc/etc to use the default Coffees table. I'll add this and
switch back to Caf�.
As info, in case anyone else is using postgresql, the Caf� db creation for
postgresql(PostgreSQL) 7.3.4) is slightly different(integer IDENTITY is replaced by
SERIAL and the inserts must be semi-colon terminated). This is using 'psql -f
createCafeTable.sql dbname' where createCafeTable.sql contains:
CREATE TABLE CAFE
(
CAFE_ID SERIAL,
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);
reid
David Sean Taylor wrote:
> 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
