Sorry, the column that is not in the database is JETSPEED_USER_PROFILE.PSML_ID
-----Original Message----- From: Chris Kimpton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 3:34 PM To: [EMAIL PROTECTED] Subject: Re: Oracle PSML Database Hi, --- "Burmeister, Mark" <[EMAIL PROTECTED]> wrote: > I removed the records that where in the database... The ones in the db are probably ok - its the psml files that probably have a problem. > Now I am getting the following exception in my jetspeed.log > > -- DEBUG -- SELECT JETSPEED_USER_PROFILE.PSML_ID, > JETSPEED_USER_PROFILE.USER_NAME, JETSPEED_USER_PROFILE.MEDIA_TYPE, > JETSPEED_USER_PROFILE.LANGUAGE, JETSPEED_USER_PROFILE.COUNTRY, > JETSPEED_USER_PROFILE.PAGE, JETSPEED_USER_PROFILE.PROFILE FROM > JETSPEED_USER_PROFILE WHERE > (JETSPEED_USER_PROFILE.USER_NAME='admin') > -- ERROR -- Error occurred in Database PSML Manager: > Exception: java.sql.SQLException: ORA-00904: invalid > column name > Stack Trace follows: > java.sql.SQLException: ORA-00904: invalid column name > > > This column does not exist in this table. Which column? > Any ideas or pointer? What version of Oracle, tomcat, jetspeed did > you get > this PSML to oracle working under. > Please any help would be much appreciate. We are using Oracle 815 and 816. Tomcat 3.3 and 4.0. Jetspeed - latest from CVS - for the last couple of months. HTH, Chris ===== Need somewhere to Live in London? - Then go to http://freeflats.com __________________________________________________ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
