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 "Burmeister, Mark" <ma...@xelus.com> on 2002/02/27 20:59:06 UTC

Oracle to PSML

I am getting the following exception my jetspeed.log file when the PSML
Importer runs


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

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1330)
        at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:614)


This column name does not exist in this table, I beleive it should be . 
SELECT JETSPEED_USER_PROFILE.USER_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')

Thanks for you help...