topic Re: activiti-rest wouldn't deploy, DB not found. jdbc.url false? in Alfresco Archive

activiti-rest wouldn't deploy, DB not found. jdbc.url false?

finns — Thu, 13 Dec 2012 13:48:14 GMT

Any Idea why on a Apache Tomcat 7.0.34 / JDK1.7.0 a freshly downloaded activiti-rest.war wouldn't deploy?It gives a sort of Connection is broken: "java.net.ConnectionException: connection refused: connect: localhost"in the activiti-rest db.properties you readdb=h2jdbc.driver=org.h2.Driverjdbc.url=jd

Re: activiti-rest wouldn't deploy, DB not found. jdbc.url false?

trademak — Thu, 13 Dec 2012 20:34:33 GMT

Hi Luca,

The Activiti Explorer uses an in-memory database so you can use it for demo purpose.
For the Activiti REST application that doesn't make a lot of sense, so you need to install a H2 database first for that.
So that's why you get a connection exception.
So no we won't need to upload a new 5.11 zip file.

Best regards,

Re: activiti-rest wouldn't deploy, DB not found. jdbc.url false?

finns — Fri, 14 Dec 2012 08:00:17 GMT

I see your point, Tijs, but it is also somewhat confusing, because for the activity-explorer.war only a deploying in Tomcat is needed.
And in thread http://forums.activiti.org/en/viewtopic.php?f=6&t=5733 you reckon

The Ant script is not used in version 5.11 anymore.

I only know a way to install a H2 database using the activiti/setup/ant h2.start , but since there's no more setup directory, could you point me to a neat method to invoke a H2 database which can be used by the Activiti examples?
(I'm trying to work myself through your Activiti in Action book http://www.manning.com/rademakers2/ by the way, which, with activiti-5.11 has gotten now something more - let's say - harder.)

Re: activiti-rest wouldn't deploy, DB not found. jdbc.url false?

trademak — Fri, 14 Dec 2012 08:11:13 GMT

Hi,

Installing the H2 database is really simple. You can read about it here if you have Windows http://www.h2database.com/html/quickstart.html
If you have Linux or Mac Osx, just download the package and startup with java -jar h2*.jar from the bin directory.
Why is it that it has become harder? The examples are still all valid for 5.11. And if you want to use the Ant script that's also still possible with 5.10.
To get acquainted with Activiti, using 5.10 would work just as good.

Best regards,

Re: activiti-rest wouldn't deploy, DB not found. jdbc.url false?

groopk — Mon, 11 Mar 2013 15:27:35 GMT

It may be simple, but it's not all that obvious 8-) I was trying to follow the start up guide and run the demo that you have listed here: http://www.activiti.org/userguide/index.html#demo.setup.one.minute.version, which doesn't work unless you have H2 running, but it's not mentioned anywhere. Following the advice you just gave made things work properly. It would probably be helpful for others if you add that information to the quick start guide.

Also, as a side suggestion, I would recommend defaulting the activity explorer to a file instead of an in-memory h2 database. A fellow coworker was disappointed when a restart made him lose the workflows he created while playing around with the explorer- I would suggest this violates the principle of least astonishment :ugeek:

Re: activiti-rest wouldn't deploy, DB not found. jdbc.url false?

frederikherema1 — Tue, 12 Mar 2013 08:46:06 GMT

That's a good suggestion. We'll keep that in mind…