[jboss-jira] [JBoss JIRA] Created: (JBPORTAL-2454) CMS identity queries with case sensitive DB fails

[Magesh Kumar B (JIRA)]

CMS identity queries with case sensitive DB fails
-------------------------------------------------

                 Key: JBPORTAL-2454
                 URL: https://jira.jboss.org/jira/browse/JBPORTAL-2454
             Project: JBoss Portal
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Portal CMS
    Affects Versions: 2.7.2 Final
         Environment: MS SQL Server 2005
            Reporter: Magesh Kumar B
            Assignee: Sohil Shah


Create a new user and login with the new user's id. We get the following exception

ERROR [org.hibernate.util.JDBCExceptionReporter] Invalid column name 'id'.
ERROR [org.jboss.portal.cms.security.AuthorizationProviderImpl] org.jboss.portal.cms.security.AuthorizationProviderImpl at 3c205c
org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.loader.Loader.doList(Loader.java:2223)
	at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2136)
	at org.hibernate.loader.Loader.list(Loader.java:2096)
	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
	at org.jboss.portal.cms.security.AuthorizationProviderImpl.findPermissionsByUser(AuthorizationProviderImpl.java:480)
	at org.jboss.portal.cms.security.AuthorizationProviderImpl.getSecurityBindings(AuthorizationProviderImpl.java:221)
	at org.jboss.portal.cms.impl.jcr.command.ACLEnforcer.getPermissions(ACLEnforcer.java:572)

This is due to the fact that  hibernate mappings instructs the DB to create the table jbp_cms_perm with column name 'ID', but AuthorizationProviderImpl.findPermissionsByUser has a hard coded SQL query with lower case.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira