topic How do I change DB on activiti-webapp-explorer2? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245938#M199068 <HTML><HEAD></HEAD><BODY><SPAN>I'd like to debug the activiti-webapp-explorer2 (5.19.0) on WildFly 9.0.2.Final, using PostgreSQL.</SPAN><BR /><SPAN>I checked its "One minute" version demo (activiti-explorer.war) works fine on WildFly 9.0.2.Final and PostgreSQL.</SPAN><BR /><BR /><SPAN>Now I'd like to debug its source code.</SPAN><BR /><SPAN>After creating tables on PostgreSQL, </SPAN><BR /><SPAN>I updated db.properties on the project "activiti-webapp-explorer2" like this.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />db=postgresql<BR />jdbc.driver=org.postgresql.Driver<BR />jdbc.url=jdbc:postgresql://localhost:5432/activiti<BR />jdbc.username=username<BR />jdbc.password=password<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Also, I added the dependency in pom.xml.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;dependency&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;groupId&gt;org.postgresql&lt;/groupId&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;artifactId&gt;postgresql&lt;/artifactId&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;version&gt;9.4.1207.jre7&lt;/version&gt;<BR />&lt;/dependency&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>But when I debug the project,</SPAN><BR /><SPAN>"ActivitiEngineConfiguration.java"(line #49) throws "ClassNotFoundException", saying</SPAN><BR /><BR /><SPAN>java.lang.ClassNotFoundException: org.postgresql.Driver from [Module "deployment.activiti-webapp-explorer2.war:main" from Service Module Loader].</SPAN><BR /><BR /><SPAN>I exported its war file. </SPAN><BR /><SPAN>But it does not contain PostgreSQL jdbc jar in WEB-INF/lib directory,</SPAN><BR /><SPAN>The contents of "db.properties" are updated to use PostgreSQL. </SPAN><BR /><SPAN>So I directly added jdbc jar by adding build path.But it does not work.</SPAN><BR /><BR /><SPAN>I guess I missed some configurations to change database.</SPAN><BR /><BR /><SPAN>I'm pretty newbie. I'll appreciate any help.</SPAN><BR /><SPAN>Thanks in advance.</SPAN></BODY></HTML> Sat, 06 Feb 2016 08:30:00 GMT mkawakami 2016-02-06T08:30:00Z How do I change DB on activiti-webapp-explorer2? https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245938#M199068 I'd like to debug the activiti-webapp-explorer2 (5.19.0) on WildFly 9.0.2.Final, using PostgreSQL.I checked its "One minute" version demo (activiti-explorer.war) works fine on WildFly 9.0.2.Final and PostgreSQL.Now I'd like to debug its source code.After creating tables on PostgreSQL, I updated db.p Sat, 06 Feb 2016 08:30:00 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245938#M199068 mkawakami 2016-02-06T08:30:00Z Re: How do I change DB on activiti-webapp-explorer2? https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245939#M199069 <HTML><HEAD></HEAD><BODY><SPAN>Place the postgres jar file in tomcat lib and try again. It will work. </SPAN></BODY></HTML> Mon, 08 Feb 2016 05:55:20 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245939#M199069 hari 2016-02-08T05:55:20Z Re: How do I change DB on activiti-webapp-explorer2? https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245940#M199070 <HTML><HEAD></HEAD><BODY><SPAN>asriharikiran, thank you for your comment.</SPAN><BR /><BR /><SPAN>Although I checked it works on Tomcat, I mean I'd like to debug on WildFly, not tomcat.</SPAN><BR /><SPAN>Is it possible?</SPAN><BR /><BR /></BODY></HTML> Mon, 08 Feb 2016 11:33:09 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245940#M199070 mkawakami 2016-02-08T11:33:09Z Re: How do I change DB on activiti-webapp-explorer2? https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245941#M199071 <HTML><HEAD></HEAD><BODY><SPAN>Sure, same story. Make sure the jar is on the classpath.</SPAN></BODY></HTML> Tue, 09 Feb 2016 07:55:00 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245941#M199071 jbarrez 2016-02-09T07:55:00Z Re: How do I change DB on activiti-webapp-explorer2? https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245942#M199072 <HTML><HEAD></HEAD><BODY><SPAN>jbarrez, thank you for your comment. I'll try.</SPAN></BODY></HTML> Tue, 09 Feb 2016 20:52:22 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-i-change-db-on-activiti-webapp-explorer2/m-p/245942#M199072 mkawakami 2016-02-09T20:52:22Z