Jetspeed and Oracle integration : strange exception ;-(

[Werner Ramaekers <we...@shiftat.com>]

Hello,

i'm using jetspeed 1.4b4-dev, CVS version from 10 days ago with my own 
custom Authentication,
RedHat7.3, JDK1.4.0_01 and Ant-1.5 and Tomcat-4.0.4
The security-schema.xml and security-schem.sql have been attached and 
this is the exception i get :

"Column not found: PER_PER_ID ... " although in the select statement i 
see : TURBINE_USER.PER_PER_ID ...
can anybody shed some light on this please ?


Horrible Exception: 
org.apache.jetspeed.services.security.LoginException: Failed to get 
anonymous user: org.apache.jetspeed.services.security.UserException: 
Failed to retrieve user 'anon': Column not found: PER_PER_ID in 
statement [SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME, 
TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME, 
TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE, 
TURBINE_USER.MODIFIED, TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN, 
TURBINE_USER.DISABLED, TURBINE_USER.LANGUAGE, TURBINE_USER.MATRICULE, 
TURBINE_USER.TYPFOOT, TURBINE_USER.OBJECTDATA, 
TURBINE_USER.PASSWORD_CHANGED, TURBINE_USER.PER_PER_ID, 
TURBINE_USER.SEC_SEC_ID, TURBINE_USER.ORGANIZATION, 
TURBINE_USER.VASCOTOKEN_SERIAL FROM TURBINE_USER WHERE 
TURBINE_USER.LOGIN_NAME='anon'] at 
com.shiftat.jetspeed.modules.security.vasco.VacmanAuthentication.getAnonymousUser(VacmanAuthentication.java:225) 
at 
org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(JetspeedAuthentication.java:107) 
at 
org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecurity.java:159) 
at 
org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(TemplateSessionValidator.java:97) 
at 
org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(JetspeedSessionValidator.java:103) 
at org.apache.turbine.modules.Action.perform(Action.java:87) at 
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at 
org.apache.turbine.Turbine.doGet(Turbine.java:521) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:683) 
at 

-- 
----------------------------------------------------------------------
ir. Werner Ramaekers
Enterprise Java Solutions Architect - Shift@
Sun Certified Java Programmer - BeJUG steering commitee member

"May the source be with you."

Read my Blog at http://www.werner.be
----------------------------------------------------------------------