Hi Nuwan/Lakmali, >From Identity side, the requirement was to change the roles/permissions when renaming applications (SPs), which will access the UM_PERMISSION table and change each permission path and it uses the same connection to update the UM_PERMISSION table and Identity DB related tables. That must be the cause of this.
On Mon, Nov 23, 2015 at 4:35 PM, Nuwan Dias <nuw...@wso2.com> wrote: > 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 > > -- Lasitha Wattaladeniya Software Engineer WSO2, Inc. | http://wso2.com lean. enterprise. middleware Mobile : +94719397528 Blog : techreadme.blogspot.com
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev