SQL Exception in jetspeed 2

[Archana Turaga <Ar...@intervoice.com>]

I managed to compile and deploy Jetspeed 2 (thanks to the instructions
that Hema had posted
http://www.mail-archive.com/jetspeed-user%40jakarta.apache.org/msg14306.
html). Only thing I would add to that list is that Jetspeed.xml needs to
be copied from the webapps to the web-inf\conf\catalina\localhost
location. This will enable the tomcat to come up without any exceptions
while loading the Jetspeed application.
But when I type http://localhost:8080/jetspeed i get the following
exception.
 
org.springframework.jdbc.UncategorizedSQLException: (OJB operation):
encountered SQLException [Unexpected token: MEDIATYPE_TO_MIMETYPE in
statement [SELECT
A0.TITLE,A0.MEDIATYPE_ID,A0.CHARACTER_SET,A0.NAME,A0.DESCRIPTION FROM
MEDIA_TYPE A0 INNER JOIN (MEDIATYPE_TO_MIMETYPE A1 INNER JOIN MIMETYPE
A2 ON A1.MIMETYPE_ID=A2.MIMETYPE_ID) ON A0.MEDIATYPE_ID=A1.MEDIATYPE_ID
WHERE A2.NAME IN ('text/html')]]; nested exception is
java.sql.SQLException: Unexpected token: MEDIATYPE_TO_MIMETYPE in
statement [SELECT
A0.TITLE,A0.MEDIATYPE_ID,A0.CHARACTER_SET,A0.NAME,A0.DESCRIPTION FROM
MEDIA_TYPE A0 INNER JOIN (MEDIATYPE_TO_MIMETYPE A1 INNER JOIN MIMETYPE
A2 ON A1.MIMETYPE_ID=A2.MIMETYPE_ID) ON A0.MEDIATYPE_ID=A1.MEDIATYPE_ID
WHERE A2.NAME IN ('text/html')]
 
Please experts can somebody help to figure out what is going on here? It
almost seems as if one of the sql scripts is messed up. 
 
Thanks in advance for your time and patience. 
Regards,
Archana