topic ActivitiExplorer pointing to wrong database? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activitiexplorer-pointing-to-wrong-database/m-p/153926#M108454 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>I have ActivitiExplorer 5.12, running in Eclipse/WTP/tomcat, the db is oracle.</SPAN><BR /><BR /><SPAN>First i point it to dev db, all data are correct, i can see 6 users on user-page.</SPAN><BR /><BR /><SPAN>Then I changed db.properties and point it to qa db, there is only 1 user, kermit in qa db. When I try to login, it's connecting to the correct qa db, so I'm able to use kermit to login. But when I open user-page, it's showing 6 users. If I change 1 user's name in dev db, I can see the change in the gui. </SPAN><BR /><BR /><SPAN>So seems login is using the correct qa db, but all other services, like task, historyService are still using the wrong dev db.</SPAN><BR /><BR /><SPAN>Is it cached? Or is there any other db config?</SPAN><BR /><BR /><SPAN>From logs, I can see they are using different api to get db connection:</SPAN><BR /><BR /><SPAN>When login:</SPAN><BR /><SPAN>[2013-12-12 14:34:30,999] http-bio-8080-exec-5 org.springframework.jdbc.datasource.DataSourceTransactionManager DEBUG - Acquired Connection [jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@cmpwdev-scan.sdc.com:1521/qa2_svc, UserName=WFLOW, Oracle JDBC driver] for JDBC transaction</SPAN><BR /><SPAN>[2013-12-12 14:34:30,999] http-bio-8080-exec-5 org.apache.ibatis.transaction.managed.ManagedTransaction DEBUG - Openning JDBC Connection</SPAN><BR /><BR /><SPAN>When open user page:</SPAN><BR /><SPAN>[2013-12-12 14:34:31,669] http-bio-8080-exec-5 org.apache.ibatis.transaction.jdbc.JdbcTransaction DEBUG - Openning JDBC Connection</SPAN><BR /><SPAN>[2013-12-12 14:34:31,679] http-bio-8080-exec-5 org.apache.ibatis.datasource.pooled.PooledDataSource DEBUG - Checked out connection 1947326607 from pool.</SPAN><BR /><BR /><BR /><SPAN>Thanks for help,</SPAN><BR /><BR /><BR /></BODY></HTML> Thu, 12 Dec 2013 22:33:39 GMT mingway 2013-12-12T22:33:39Z ActivitiExplorer pointing to wrong database? https://connect.hyland.com/t5/alfresco-archive/activitiexplorer-pointing-to-wrong-database/m-p/153926#M108454 Hi,I have ActivitiExplorer 5.12, running in Eclipse/WTP/tomcat, the db is oracle.First i point it to dev db, all data are correct, i can see 6 users on user-page.Then I changed db.properties and point it to qa db, there is only 1 user, kermit in qa db. When I try to login, it's connecting to the cor Thu, 12 Dec 2013 22:33:39 GMT https://connect.hyland.com/t5/alfresco-archive/activitiexplorer-pointing-to-wrong-database/m-p/153926#M108454 mingway 2013-12-12T22:33:39Z Re: ActivitiExplorer pointing to wrong database? https://connect.hyland.com/t5/alfresco-archive/activitiexplorer-pointing-to-wrong-database/m-p/153927#M108455 <HTML><HEAD></HEAD><BODY><SPAN>Resolving of the DB-properties is done using a org.springframework.beans.factory.config.PropertyPlaceholderConfigurer. Make sure there is only ONE db.properties on the classpath and make sure that contains the values you need.</SPAN><BR /><BR /><SPAN>Explorer caches users when it boots, so modifying the database while explorer runs, will not update the cache. Rather, modify all user-related stuff from within the "manage" tab of explorer, this passed though the cache and updates accordingly.</SPAN><BR /><BR /><SPAN>Alternatively, you can edit the activiti-standalone-context.xml and replace the {jdbc.username} placeholders by the actual values or use another way to define a datasource (eg. JNDI, …).</SPAN></BODY></HTML> Fri, 13 Dec 2013 07:52:45 GMT https://connect.hyland.com/t5/alfresco-archive/activitiexplorer-pointing-to-wrong-database/m-p/153927#M108455 frederikherema1 2013-12-13T07:52:45Z