[jboss-jira] [JBoss JIRA] Created: (JBPORTAL-2431) SQLException on user login if hibernate schema name is specified

[Martin Putz (JIRA)]

SQLException on user login if hibernate schema name is specified
----------------------------------------------------------------

                 Key: JBPORTAL-2431
                 URL: https://jira.jboss.org/jira/browse/JBPORTAL-2431
             Project: JBoss Portal
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Portal CMS
    Affects Versions: 2.7.2 Final
         Environment: JBoss Portal set up with a dedicated schema name (eg. on Oracle), <property name="hibernate.default_schema">epp43</property> added to all hibernate config files:

deploy/jboss-portal.sar/portal-cms.sar/conf/hibernate/cms/hibernate.cfg.xml
deploy/jboss-portal.sar/conf/hibernate/portal/hibernate.cfg.xml
deploy/jboss-portal.sar/conf/hibernate/portlet/hibernate.cfg.xml
deploy/jboss-portal.sar/conf/hibernate/workflow/hibernate.cfg.xml
deploy/jboss-portal.sar/conf/hibernate/user/hibernate.cfg.xml
deploy/jboss-portal.sar/conf/hibernate/instance/hibernate.cfg.xml
deploy/jboss-portal.sar/portal-wsrp.sar/conf/hibernate/consumer/hibernate.cfg.xml

            Reporter: Martin Putz
            Assignee: Sohil Shah


2009-07-13 12:24:30,751 DEBUG [org.hibernate.SQL] SELECT p.* from jbp_cms_perm p,jbp_cms_perm_role r,jbp_role_membership m,jbp_roles roles,jbp_users users WHERE p.id=r.cms_perm_id AND r.role_id=roles.jbp_name AND m.jbp_rid=roles.jbp_rid AND m.jbp_uid=users.jbp_uid AND users.jbp_uname=?
2009-07-13 12:24:30,751 DEBUG [org.hibernate.type.StringType] binding 'ora2' to parameter: 1
2009-07-13 12:24:30,762 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
2009-07-13 12:24:30,763 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00942: table or view does not exist

2009-07-13 12:24:30,763 ERROR [org.jboss.portal.cms.security.AuthorizationProviderImpl] org.jboss.portal.cms.security.AuthorizationProviderImpl at 12f1015
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:454)
...
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist



-- 
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