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