Postgres Change Schema

[abbask]

By default Activiti creates tables in the Public schema (in postgres). how can i change this setting to use some other schema e.g. "my-activiti-schema"

[hari]

You can change the schema in activiti-app.properties which is present under tomcat>lib folder

[abbask]

HI Hari,
Can you please tell me which property to create/modify?

[hari]

I m sorry Abbas. I got your question wrong. Even I m unaware of that.
Lets wait for someone else's reply here.

[jbarrez]

You can provide the schema in the jdbc url in recent versions of the postgres driver afaik.

[abbask]

I have tried it using: http://<my_host>/<db_name>?currentpath=<schema_name>
but it does not work it creates tables in public schema only.

[jbarrez]

should be currentSchema instead:

jdbcostgresql://localhost:5432/mydatabase?currentSchema=myschema