Possible bug when using MS-SQL server configuration

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.

tommyalf

Hi all,
  when I use this configuration:

<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
        <property name="dataSource" ref="dataSource"/>
        <property name="transactionManager" ref="transactionManager"/>
        <property name="databaseSchemaUpdate" value="false"/>
        <property name="databaseSchema" value="mySchema"/>
        <property name="databaseTablePrefix" value="mySchema."/>
    …..
    </bean>
‍‍‍‍‍‍‍‍‍‍

I receive this error:
org.activiti.engine.ActivitiException: Activiti database problem: Tables missing for component(s) engine, history, identity

This is because JTDS ( it is my jdbc connector but I investigated also on SQLJDBC which it has the same behaviour)
uses 'sp_tables' system stored procedure when check Table Metadata. 'sp_tables' fails because the name of table is changed by :
tableName = prependDatabaseTablePrefix(tableName);   (isTablePresent – DbSqlSession - 766).

Use prependDatabase seems a rigth thing but in this case causes the store procededure fail.

On the contrary I can't remove "databaseTablePrefix" because activiti tables are under a not default schema for my db user.
If I remove it Activiti will be not able to find tables.











 

tommyalf

I solve it. I change DbSqlSession (5.15-SNAPSHOT) :

<br>&hellip;<br>public boolean isEngineTablePresent(){<br>&nbsp;&nbsp;&nbsp; return isTablePresent("ACT_RU_EXECUTION") || isTablePresent(prependDatabaseTablePrefix("ACT_RU_EXECUTION"));<br>&nbsp; }<br>&nbsp; public boolean isHistoryTablePresent(){<br>&nbsp;&nbsp;&nbsp; return isTablePresent("ACT_HI_PROCINST")&nbsp; || isTablePresent(prependDatabaseTablePrefix("ACT_HI_PROCINST"));<br>&nbsp; }<br>&nbsp; public boolean isIdentityTablePresent(){<br>&nbsp;&nbsp;&nbsp; return isTablePresent("ACT_ID_USER")&nbsp;&nbsp; || isTablePresent(prependDatabaseTablePrefix("ACT_ID_USER"));<br>&nbsp; }<br><br>&nbsp; public boolean isTablePresent(String tableName) {<br>//&nbsp;&nbsp;&nbsp; tableName = prependDatabaseTablePrefix(tableName);<br>&nbsp;&nbsp;&nbsp; Connection connection = null;<br>&nbsp;&nbsp;&nbsp; try {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connection = sqlSession.getConnection();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DatabaseMetaData databaseMetaData = connection.getMetaData();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultSet tables = null;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String schema = this.connectionMetadataDefaultSchema;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (dbSqlSessionFactory.getDatabaseSchema()!=null) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; schema = dbSqlSessionFactory.getDatabaseSchema();<br>&hellip;<br>
What do you think?