02-16-2018 08:26 AM
I am new to Activiti. I have installed and run the db script in two oracle schemas: one for activiti-admin, the other for activiti-app. Activiti-app is running fine, but activiti-admin failed to start because of the following error. Please help. Thanks.
11:13:31,190 [main] DEBUG com.activiti.conf.DatabaseConfiguration - Configuring Liquibase
11:13:32,408 [main] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKOUT.
11:13:32,424 [main] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKOUT has SUCCEEDED.
11:13:34,018 [C3P0PooledConnectionPoolManager[identityToken->2ym9xt9t18849bx17stx9u|23202c31]-HelperThread-#1] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKIN.
11:13:34,033 [C3P0PooledConnectionPoolManager[identityToken->2ym9xt9t18849bx17stx9u|23202c31]-HelperThread-#1] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKIN has SUCCEEDED.
11:13:34,127 [main] INFO com.activiti.domain.generator.MinimalDataGenerator - Verifying if minimal data is present
11:13:34,158 [main] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKOUT.
11:13:34,158 [main] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKOUT has SUCCEEDED.
11:13:34,674 [main] DEBUG com.mchange.v2.c3p0.impl.NewPooledConnection - com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4 handling a throwable.
java.sql.SQLSyntaxErrorException: ORA-00904: "SERVERCONF0_"."PASSWORD": invalid identifier
02-16-2018 09:55 AM
I found both USER_INFO and SERVRE_CONFIG tables have a column "password". After I changed the column name to "PASSWORD", the 'ORA-00904: "SERVERCONF0_"."PASSWORD": invalid identifier' error was gone. I am curious to know why the column name "password" has all lower-case character, while other column names have all upper-case characters. Is this a liquibase problem with oracle dialect?
02-19-2018 06:53 AM
I presume that the problem is that 'password' is a reserved word in oracle. I am not sure why changing the case resolved it but I think it has something to do with How do I escape a reserved word in Oracle? - Stack Overflow . Some tables use a prefix before the column name for the password Activiti/db-changelog.xml at 6.x · Activiti/Activiti · GitHub but that one doesn't Activiti/db-changelog.xml at 6.x · Activiti/Activiti · GitHub .
02-20-2018 06:49 PM
Thank you.
Explore our Alfresco products with the links below. Use labels to filter content by product module.