nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Rename tables in the database

aitor

Hello,

Is it possible to rename the tables in the database from ACT_XXXX to BPM_XXXX, for example, without overwriting the API?

In my application "ACT_" acronym is reserved for ACTION data tables.

Thanks.

Find more posts tagged with

Comments

frederikherema1

You can have table-prefixed for the tables, to overcome issues with clashing names. Renaming the whole table is not possible. So you could have an BPM_ACT_RU_EXECUTION table, but not a BPM_RU_EXECUTION table (at least, not without forking activiti

).

Prefix can be configured using property "databaseTablePrefix" on the processEngineConfiguration:

<br>/**<br>&nbsp;&nbsp; * Allows configuring a database table prefix which is used for all runtime operations of the process engine.<br>&nbsp;&nbsp; * For example, if you specify a prefix named 'PRE1.', activiti will query for executions in a table named<br>&nbsp;&nbsp; * 'PRE1.ACT_RU_EXECUTION_'. <br>&nbsp;&nbsp; * <br>&nbsp;&nbsp; * <p /><br>&nbsp;&nbsp; * <strong>NOTE: the prefix is not respected by automatic database schema management. If you use <br>&nbsp;&nbsp; * {@link ProcessEngineConfiguration#DB_SCHEMA_UPDATE_CREATE_DROP} <br>&nbsp;&nbsp; * or {@link ProcessEngineConfiguration#DB_SCHEMA_UPDATE_TRUE}, activiti will create the database tables <br>&nbsp;&nbsp; * using the default names, regardless of the prefix configured here.</strong>&nbsp; <br>&nbsp;&nbsp; * <br>&nbsp;&nbsp; * @since 5.9<br>&nbsp;&nbsp; */<br>&nbsp; protected String databaseTablePrefix = "";<br>

You should manually create the tables using the prefix. Look for the right files in github or in the engine jar (each DB has a set of *create*.sql files). Alter those to respect the prefix you set. From that point on, if the engine boots, the prefix will be used.

<br>/modules/activiti-engine/src/main/resources/org/activiti/db/create/activiti.h2.create.engine.sql<br>

aitor

Perfect!!!

I tried it and all ok. It's what I needed.

Thank you very much.