topic Re: hello, i have a problem with activiti-rest, when i configure my database postgresql in db.proprietes, the creation of tables is done automatically in the public shemas, i want to change shema how i do to give it my own shema in Alfresco Forum

hello, i have a problem with activiti-rest, when i configure my database postgresql in db.proprietes, the creation of tables is done automatically in the public shemas, i want to change shema how i do to give it my own shema

mobarkiyasmine — Wed, 21 Feb 2018 08:03:31 GMT

hello, i have a problem with activiti-rest, when i configure my database postgresql in db.proprietes, the creation of tables is done automatically in the public shemas, i want to change shema how i do to give it my own shema

Re: hello, i have a problem with activiti-rest, when i configure my database postgresql in db.proprietes, the creation of tables is done automatically in the public shemas, i want to change shema how i do to give it my own shema

alxgomz — Wed, 21 Feb 2018 17:33:04 GMT

Hi Yasmine,

If you're using postgreSQL JDBC driver 9.4 or above, you can use the jdbc url param "currentSchema"

datasource.url=jdbc:smileytongue:ostgresql://localhost:5432/activitiapp?currentSchema=someotherschema

if using previous versions I have read that you can use the "search-path" param instead but it seems undocumented.

Re: hello, i have a problem with activiti-rest, when i configure my database postgresql in db.proprietes, the creation of tables is done automatically in the public shemas, i want to change shema how i do to give it my own shema

mobarkiyasmine — Thu, 22 Feb 2018 09:33:53 GMT

thank you i have this configuration how can i modifie it

db=postgres
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbcostgresql://localhost:5432/activiti
jdbc.username=postgres
jdbc.password=postgres

Re: hello, i have a problem with activiti-rest, when i configure my database postgresql in db.proprietes, the creation of tables is done automatically in the public shemas, i want to change shema how i do to give it my own shema

alxgomz — Thu, 22 Feb 2018 09:47:27 GMT

The normal activiti property for activiti should be datasource.url...not sure why you use someting different (I guess you're integrating activiti in another project...?)

Anyway... try to change:

jdbc.url=jdbc:smileytongue:ostgresql://localhost:5432/activiti

to:

jdbc.url=jdbc:smileytongue:ostgresql://localhost:5432/activiti?currentSchema=someotherschema

As stated before "currentSchema" works only for 9.4 postgres jdbc driver and above. MAke sure you have the right version.