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

[finns]

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 read

db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc:h2:tcp://localhost/activiti
jdbc.username=sa
jdbc.password=

in the activiti-explorer db.properties you read

db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000
jdbc.username=sa
jdbc.password=

Is the solution to correct the activiti-rest jdbc.url to jdbc:h2:mem:activiti;DB_CLOSE_DELAY=100 ?

Best regards
(and please in case do upload a corrected activiti-5.11.zip. thx.)

Luca

[trademak]

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,

[finns]

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.)

[trademak]

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,

[groopk]

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:

[frederikherema1]

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