Hello,
I was successful in building Jetspeed 2 from the source checked out
from CVS today. My database for deployment is Sybase. After deploying
jetspeed when I try to login I get the SQLException due to invalid
column name. The error stack trace is provided below.
I am not why the code is looking for a Column name: creation_date,
when the column name is indeed CREATION_DATE. It appears that
getInternalUserPrincipal() method of SecurityAccessImpl is creating
the query using QueryFactory where this is failing. From what I
understand it is using SECURITY_PRINCIPAL table where CREATION_DATE
coulmn is defined. I am not sure failure of the query due to
case-sensitiveness is specific to Sybase. Can anyone let me know why
this is happening?
Stack trace follows:
org.springframework.jdbc.UncategorizedSQLException: (OJB operation):
encountered SQLException [Invalid column name 'creation_date'.
]; nested exception is com.sybase.jdbc2.jdbc.SybSQLException: Invalid
column name 'creation_date'.
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:94)
org.springframework.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107)
org.springframework.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89)
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:155)
org.springframework.orm.ojb.PersistenceBrokerTemplate.getObjectByQuery(PersistenceBrokerTemplate.java:178)
org.apache.jetspeed.security.spi.impl.SecurityAccessImpl..........
..................................)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152)
$Proxy2.getInternalUserPrincipal(Unknown Source)
org.apache.jetspeed.security.spi.impl.DefaultUserSecurityHandler.getUserPrincipal(DefaultUserSecurityHandler.java:61)
Thanks,
Hema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hema Menon
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
