Activiti+oracle problem analysis and solution for starting a project without automatically building tables or updating tables

Description of the phenomenon: according to normal configuration, the first startup cannot automatically build the table

The key configuration fragments are as follows:

<bean id= "processengineconfiguration" class= "Org.activiti.spring.SpringProcessEngineConfiguration" >

<property name= "DataSource" ref= "DataSource"/>

<property name= "TransactionManager" ref= "TransactionManager"/>

<property name= "Databaseschemaupdate" value= "true"/>

<property name= "Jobexecutoractivate" value= "true"/>

</bean>

Error after startup:

# # # The error may exist in Org/activiti/db/mapping/entity/property.xml

# # # The error may involve Defaultparametermap

# # # The error occurred while setting parameters

# # # Sql:select Value_ from act_ge_property where name_ = ' schema.version '

# # # cause:java.sql.sqlsyntaxerrorexception:ora-00942: Table or view does not exist

After debugging analysis, it is found that the key judgment table is the existence of code return True value caused by org.activiti.engine.impl.db.DbSqlSession.isTablePresent (String tableName) The problem is the Schema=null in the method, and another user Activiti has already created the table under the connected DB instance.

Then add the properties to the engine configuration:

<property name= "Databaseschema" value= "act"/>

Start again to create the table successfully. To this point that the problem has been resolved, the shutdown service started again, failed, reported a table error: the object already exists. Debug found Istablepresent returned or false (the table has not yet been created).

Found to be case-sensitive, and finally changed to

<property name= "Databaseschema" value= "ACT"/>

Solve.

Activiti+oracle problem analysis and solution for starting a project without automatically building tables or updating tables