Looks like a bug to me. This would require the Identity and UM tables to be on a single schema, which would be wrong.
Thanks, NuwanD. On Mon, Nov 23, 2015 at 4:28 PM, Lakmali Baminiwatta <lakm...@wso2.com> wrote: > Hi all, > > In APIM 1.10.0, when we try to rename an Application, below error is > thrown. When I checked the code, there are queries to UM_PERMISSION table > against the Identity DB [1]. Shouldn't we use existing UM APIs or run these > against the UM DB? > > Caused by: org.h2.jdbc.JdbcSQLException: Table "UM_PERMISSION" not found; > SQL statement: > SELECT UM_ID, UM_RESOURCE_ID FROM UM_PERMISSION WHERE UM_RESOURCE_ID LIKE > ? [42102-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at org.h2.command.Parser.readTableOrView(Parser.java:4498) > at org.h2.command.Parser.readTableFilter(Parser.java:1011) > at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1577) > at org.h2.command.Parser.parseSelectSimple(Parser.java:1682) > at org.h2.command.Parser.parseSelectSub(Parser.java:1571) > at org.h2.command.Parser.parseSelectUnion(Parser.java:1416) > at org.h2.command.Parser.parseSelect(Parser.java:1404) > at org.h2.command.Parser.parsePrepared(Parser.java:392) > at org.h2.command.Parser.parse(Parser.java:275) > at org.h2.command.Parser.parse(Parser.java:247) > at org.h2.command.Parser.prepare(Parser.java:201) > at org.h2.command.Parser.prepareCommand(Parser.java:214) > at org.h2.engine.Session.prepareLocal(Session.java:434) > at org.h2.engine.Session.prepareCommand(Session.java:384) > at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1071) > at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71) > at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:234) > at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.wso2.carbon.ndatasource.rdbms.ConnectionRollbackOnReturnInterceptor.invoke(ConnectionRollbackOnReturnInterceptor.java:51) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:153) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) > at com.sun.proxy.$Proxy13.prepareStatement(Unknown Source) > at > org.wso2.carbon.identity.application.mgt.dao.impl.ApplicationDAOImpl.readApplicationPermissions(ApplicationDAOImpl.java:2752) > at > org.wso2.carbon.identity.application.mgt.dao.impl.ApplicationDAOImpl.updateBasicApplicationData(ApplicationDAOImpl.java:442) > at > org.wso2.carbon.identity.application.mgt.dao.impl.ApplicationDAOImpl.updateApplication(ApplicationDAOImpl.java:337) > > [1] > https://github.com/wso2/carbon-identity/blob/master/components/application-mgt/org.wso2.carbon.identity.application.mgt/src/main/java/org/wso2/carbon/identity/application/mgt/dao/impl/ApplicationDAOImpl.java > > Thanks, > Lakmali > > -- > Lakmali Baminiwatta > Senior Software Engineer > WSO2, Inc.: http://wso2.com > lean.enterprise.middleware > mobile: +94 71 2335936 > blog : lakmali.com > > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Nuwan Dias Technical Lead - WSO2, Inc. http://wso2.com email : nuw...@wso2.com Phone : +94 777 775 729
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev