topic Possible bug when using MS-SQL server configuration in Alfresco Archive

Possible bug when using MS-SQL server configuration

tommyalf — Mon, 03 Mar 2014 16:17:29 GMT

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

Re: Possible bug when using MS-SQL server configuration

tommyalf — Mon, 03 Mar 2014 16:46:42 GMT

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


…
public boolean isEngineTablePresent(){
    return isTablePresent("ACT_RU_EXECUTION") || isTablePresent(prependDatabaseTablePrefix("ACT_RU_EXECUTION"));
  }
  public boolean isHistoryTablePresent(){
    return isTablePresent("ACT_HI_PROCINST")  || isTablePresent(prependDatabaseTablePrefix("ACT_HI_PROCINST"));
  }
  public boolean isIdentityTablePresent(){
    return isTablePresent("ACT_ID_USER")   || isTablePresent(prependDatabaseTablePrefix("ACT_ID_USER"));
  }

  public boolean isTablePresent(String tableName) {
//    tableName = prependDatabaseTablePrefix(tableName);
    Connection connection = null;
    try {
      connection = sqlSession.getConnection();
      DatabaseMetaData databaseMetaData = connection.getMetaData();
      ResultSet tables = null;
      
      String schema = this.connectionMetadataDefaultSchema;
      if (dbSqlSessionFactory.getDatabaseSchema()!=null) {
        schema = dbSqlSessionFactory.getDatabaseSchema();
…

What do you think?

Re: Possible bug when using MS-SQL server configuration

jbarrez — Mon, 10 Mar 2014 10:28:17 GMT

hmm it is a right fix for your use case - but more generically Im wondering if it wouldn't cause issues for people … i mean what if there is a prefix AND one without prefix … ?