topic Can't add h2 database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/can-t-add-h2-database/m-p/231975#M185105 <HTML><HEAD></HEAD><BODY><SPAN>I know it may sound silly, but I can't for the life of me get activiti to connect to an h2 databse, running on my local machine.</SPAN><BR /><BR /><SPAN>I downloaded h2 from </SPAN><A href="http://www.h2database.com/html/main.html" rel="nofollow noopener noreferrer">http://www.h2database.com/html/main.html</A><SPAN> and ran it with default settings. I could connect to the default server database (jdbc:h2:tcp://localhost/~/test) just fine.</SPAN><BR /><BR /><SPAN>But when I try to modify the db.properties file of activiti (that's running on tomcat port 8090) and then try to open localhost:8090/activiti-explorer, I either get a 404 error or just make Tomcat8.exe go into an infinite loop, forcing me to kill the process.</SPAN><BR /><BR /><SPAN>I tried all kinds of different ways of specifying the h2 database link in db.properties, like:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>jdbc.url=jdbc:h2:tcp://localhost/~/test<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><PRE class="language-none line-numbers"><CODE>jdbc.url=jdbc:h2:tcp://localhost:8082/~/test<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><PRE class="language-none line-numbers"><CODE>jdbc.url=jdbc:h2:tcp://localhost/test<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><PRE class="language-none line-numbers"><CODE>jdbc.url=jdbc:h2:tcp://localhost:8082/test<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Anyone have an idea on what I'm doing wrong?</SPAN></BODY></HTML> Mon, 23 May 2016 14:20:08 GMT waltermeier 2016-05-23T14:20:08Z Can't add h2 database https://connect.hyland.com/t5/alfresco-archive/can-t-add-h2-database/m-p/231975#M185105 I know it may sound silly, but I can't for the life of me get activiti to connect to an h2 databse, running on my local machine.I downloaded h2 from http://www.h2database.com/html/main.html and ran it with default settings. I could connect to the default server database (jdbc:h2:tcp://localhost/~/te Mon, 23 May 2016 14:20:08 GMT https://connect.hyland.com/t5/alfresco-archive/can-t-add-h2-database/m-p/231975#M185105 waltermeier 2016-05-23T14:20:08Z Re: Can't add h2 database https://connect.hyland.com/t5/alfresco-archive/can-t-add-h2-database/m-p/231976#M185106 <HTML><HEAD></HEAD><BODY><SPAN>Nevermind. Turns out the answer was super simple. Activiti isn't friends with the Beta version of h2database. Downloaded 1.3.176 and got rid of the ~ in the JDBC link. Everything worked just as expected right away. Wish this was clearer from the get go, but whatever.</SPAN><BR /><BR /><SPAN>Mods can feel free to close this thread.</SPAN></BODY></HTML> Tue, 24 May 2016 05:35:42 GMT https://connect.hyland.com/t5/alfresco-archive/can-t-add-h2-database/m-p/231976#M185106 waltermeier 2016-05-24T05:35:42Z Re: Can't add h2 database https://connect.hyland.com/t5/alfresco-archive/can-t-add-h2-database/m-p/231977#M185107 <HTML><HEAD></HEAD><BODY><SPAN>Indeed, the new version has changed the url. When H2 is out of beta, we'll upgrade all libs</SPAN></BODY></HTML> Tue, 31 May 2016 10:04:01 GMT https://connect.hyland.com/t5/alfresco-archive/can-t-add-h2-database/m-p/231977#M185107 jbarrez 2016-05-31T10:04:01Z