# Database schema/table prefix - spring process engine config

**URL:** <https://forum.flowable.org/t/database-schema-table-prefix-spring-process-engine-config/9443>\
**Category:** Flowable Engine\
**Created:** [June 21, 2022, 8:24pm UTC](https://forum.flowable.org/t/database-schema-table-prefix-spring-process-engine-config/9443 "2022-06-21T20:24:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jake.kochocki](https://avatars.discourse-cdn.com/v4/letter/j/e8c25b/32.png) [@jake.kochocki](https://forum.flowable.org/u/jake.kochocki)\
**Post date:** [June 21, 2022, 8:24pm UTC](https://forum.flowable.org/t/database-schema-table-prefix-spring-process-engine-config/9443/1 "2022-06-21T20:24:42Z")

</div>

Attempting a migration from activiti 5.21.0 to Flowable 6.7.2 - using the custom configuration pattern from the spring boot docs, I’m setting the schema for our oracle db and trying to use that schema as the table prefix -

```auto
public class MyConfigurer implements EngineConfigurationConfigurer<SpringProcessEngineConfiguration> {
    ...
    public void configure(SpringProcessEngineConfiguration processEngineConfiguration) {
        processEngineConfiguration.setDatabaseSchemaUpdate(schemaUpdate);
		processEngineConfiguration.setDatabaseSchema(databaseSchema);
		processEngineConfiguration.setDatabaseTablePrefix(databaseSchema + ".");
		processEngineConfiguration.setTablePrefixIsSchema(true);
		processEngineConfiguration.setDeploymentName(deploymentName);
		processEngineConfiguration.setFlowable5CompatibilityEnabled(flowable5Compatibility);
		processEngineConfiguration.setFlowable5CompatibilityHandlerFactory(springFlowable5CompatibilityHandlerFactory());
    }

}

```

The engine is failing the migration of the flowable schema for an insert into ACT\_GE\_PROPERTY, which is not being found for the insert. The prepared sql statement is missing the schema, i.e. I am getting

```auto
insert into ACT_GE_PROPERTY values ('common.schema.version', '6.2.0.0', 1)

```

where I think I should be getting

```auto
insert into MY_DB.ACT_GE_PROPERTY values ('common.schema.version', '6.2.0.0', 1)

```

Digging into the spring configuration setup, I find my configurer associated with the other autoconfigurers when the engine starts, but the prefix/schema value appears to be getting overwritten by an autoconfiguration. What am I missing?

Additional logs of errors:

```auto
e[2m2022-06-21 16:16:58.926e[0;39m e[31mERRORe[0;39m e[33m[_svc_,,,]e[0;39m e[35m29520e[0;39m e[2m---e[0;39m e[2m[restartedMain]e[0;39m e[36mo.f.c.e.impl.db.CommonDbSchemaManager e[0;39m e[2m:e[0;39m Could not get property from table ACT_GE_PROPERTY

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

```

```auto
2022-06-21 16:16:59.072e[0;39m e[31mERRORe[0;39m e[33m[_svc_,,,]e[0;39m e[35m29520e[0;39m e[2m---e[0;39m e[2m[restartedMain]e[0;39m e[36mo.f.c.e.impl.db.CommonDbSchemaManager e[0;39m e[2m:e[0;39m problem during schema upgrade, statement insert into ACT_GE_PROPERTY values ('common.schema.version', '6.2.0.0', 1)

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

```

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [July 1, 2022, 5:22pm UTC](https://forum.flowable.org/t/database-schema-table-prefix-spring-process-engine-config/9443/2 "2022-07-01T17:22:56Z")

</div>

> [@jake.kochocki](#):
>
> ```auto
> processEngineConfiguration.setDatabaseSchema(databaseSchema);
> 
> ```

For Oracle, that should be enough. The schema is set on the JDBC level and all SQL statements are done implicitly in that schema (that’s also how we’ve configured our QA tests for running against a specific Oracle schema). How does the jdbc url looks like? What config were you using with activiti?