topic H2 specific errors while connecting to Postgres DB in Alfresco Archive

H2 specific errors while connecting to Postgres DB

mohit — Tue, 23 Feb 2016 03:44:40 GMT

I am trying to configure activiti to use postgres DB.My db.properties file is:db=postgresjdbc.driver=org.postgresql.Driverjdbc.url=jdbcostgresql://localhost:5432/activitijdbc.username=activitijdbc.password=activiti=======================================My activiti.cfg.xml is something like : pr

Re: H2 specific errors while connecting to Postgres DB

martin_grofcik — Tue, 23 Feb 2016 07:45:26 GMT

Hi,

your configuration still uses H2 DB. Check config files for H2 configuration and change it to postgres.

Regards
Martin

Re: H2 specific errors while connecting to Postgres DB

mohit — Tue, 23 Feb 2016 15:02:49 GMT

I am sorry, I don't understand.
Is there any other file except db.properties and activiti.cfg.xml?
As shown in my original question above, I have already updated these files for Postgres.

Also, I would like to point out again from above that:
"when I start tomcat, I see my activiti database (the one I created in postgres, gets populated with 25 tables), but when I run the test case shown above I get the below error:
org.h2.jdbc.JdbcSQLException: Connection is broken: "java.net.ConnectException: Connection refused: localhost" [90067-191]
"

Re: H2 specific errors while connecting to Postgres DB

mohit — Tue, 23 Feb 2016 15:29:46 GMT

Whoa, something odd happened:

I updated my test case to have process-engine bootstrapped like:
ProcessEngine processEngine = ProcessEngineConfiguration.createStandaloneInMemProcessEngineConfiguration()
       .setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_FALSE)
       .setJdbcUrl("jdbcostgresql://localhost:5432/activiti")
       .setJdbcUsername("activiti")
       .setJdbcPassword("activiti")
       .buildProcessEngine();

instead of
ProcessEngine processEngine = ProcessEngineConfiguration
.createStandaloneProcessEngineConfiguration()
.buildProcessEngine();

Can someone please explain what happened and why the values were not picked from activiti.cfg.xml?

Thanks

Re: H2 specific errors while connecting to Postgres DB

jbarrez — Wed, 24 Feb 2016 10:04:23 GMT

Because now you're instantiating the engine programmatically - no cfg.xml file is involved.

Use the createProcessEngineConfigurationFromResource() method if you want to create a process engine based on an external file.

Re: H2 specific errors while connecting to Postgres DB

mohit — Wed, 24 Feb 2016 16:25:18 GMT

Hi jbarrez,
Thanks to the reply.

So you are suggesting that if I do:

ProcessEngine processEngine = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration().buildProcessEngine();

It simply defaults to the default values i.e. H2 db etc.

So, either I instantiate the processEngine programmatically or use createProcessEngineConfigurationFromResource() if I want to read from cfg.xml

Thanks,
Mohit

Re: H2 specific errors while connecting to Postgres DB

jbarrez — Tue, 01 Mar 2016 20:20:52 GMT

No, after createStandaloneProcessEngineConfiguration you can call many (many) setters, like setJdbcUrl and all ….