topic Re: activiti & osgi, book examples in Alfresco Archive

activiti & osgi, book examples

christoph_retti — Thu, 29 Dec 2011 15:38:33 GMT

Hi, I tried to run activit 5.8 & osgi installation steps as described in "Activiti in Action MEAP v8" (page 230) and after installing the book-osgi example I get an exeptionsayingkaraf@root> D:\dev\svc\apache-karaf-2.2.5\bin>karaf.bat __ __ ____ / //_/____ __

Re: activiti & osgi, book examples

bidek — Thu, 29 Dec 2011 15:54:58 GMT

Exception "says": cant connect to database, connection refused

It may by firewall issue, or misconfigured database.
Check for example, whether the database is running or database socket accepting connections

Re: activiti & osgi, book examples

christoph_retti — Thu, 29 Dec 2011 15:58:01 GMT

hmm … its using the embedded h2 database, so I guess it should be auto-started with the engine?

Re: activiti & osgi, book examples

christoph_retti — Thu, 29 Dec 2011 17:41:44 GMT

Hi together, I found the source of the problem: in the blueprint of the book-osgi-engine
the H2 datasource is specified as


  <bean id="dataSource" class="org.h2.jdbcx.JdbcDataSource">
    <property name="URL" value="jdbc:h2:tcp://localhost/activiti" />
    <property name="user" value="sa" />
    <property name="password" value="" />
  </bean>

but should at least be


  <bean id="dataSource" class="org.h2.jdbcx.JdbcDataSource">
    <property name="URL" value="jdbc:h2:tcp://localhost/~/activiti" />
    <property name="user" value="sa" />
    <property name="password" value="" />
  </bean>

Note the ~ in jdbc:h2:tcp://localhost/~/activiti as this will then make H2 create the database in the users folder where it has
enough rights under Windows 7.

Nevertheless this approach (at least I think so) is not the ideal one as it requires H2 to be started in server mode and therefore needs
a process to run outside of Karaf.

Maybe the best solution (at least for the demo) would be to use

  
  <bean id="dataSource" class="org.h2.jdbcx.JdbcDataSource">
    <property name="URL" value="jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000" />
    <property name="user" value="sa" />
    <property name="password" value="" />
  </bean>

so, starting H2 in memory mode. This way there are no dependencies outside of OSGI and the demo runs nicely.

I hope the book authors read this post, so they can correct this in the sources.

regards, Chris

Re: activiti & osgi, book examples

trademak — Fri, 30 Dec 2011 15:50:15 GMT

Hi,

We decided to use a standalone H2 database instance just like for example the Activiti Explorer.
I don't see why this would be wrong approach. And then the current database URL is also fine.
If you want to run it embedded, that's just fine and you can use the configuration as you described.

Best regards,