Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

5.4's ant build.xml can not work in oracle?

ylybbs
Champ in-the-making
Champ in-the-making

‎04-02-2011 09:50 PM

I download 5.4 full pack and unpack it to somewhere. Just following the user guide,I change the parameter value in build.properties and build.oracle.properties and copy ojdbc5.jar to activiti-5.4\setup\files\dependencies, when i run 'ant demo.start',the console warn something like table unexist. Obvious the create db task hasn't executed. If i manually execute the creating ddl sql(activiti.oracle.create.XXX.sql) in db, i can run 'ant demo.start' to start the demo.


demo.install:
     [echo] installing demo

internal.define.jdbc.driver.libs:

build.webapps:
    [mkdir] Created dir: D:\Develop\activiti-5.4\setup\build\webapps
     [copy] Copying 1414 files to D:\Develop\activiti-5.4\setup\build\webapps
     [copy] Copied 442 empty directories to 5 empty directories under D:\Develop\activiti-5.4\setup\build\webapps
     [copy] Copying 50 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-explorer.war\WEB-INF\lib
     [copy] Copying 50 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-probe.war\WEB-INF\lib
     [copy] Copying 50 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-cycle.war\WEB-INF\lib
     [copy] Copying 17 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-kickstart.war\WEB-INF\lib
     [copy] Copying 25 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-administrator.war\WEB-INF\lib
     [copy] Copying 129 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-rest.war\WEB-INF\lib

internal.db.install.h2:

internal.db.install.h2.unnecessary:
     [echo] H2 is already installed

internal.db.install.unsupported:
     [echo] Automatic installation of oracle DB not supported.  It is assumed to be installed and running

h2.install:

cfg.create:
    [mkdir] Created dir: D:\Develop\activiti-5.4\setup\build\activiti-cfg
     [copy] Copying 1 file to D:\Develop\activiti-5.4\setup\build\activiti-cfg
      [zip] Building zip: D:\Develop\activiti-5.4\setup\build\activiti-cfg.jar
     [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
    [unzip] Expanding: D:\Develop\activiti-5.4\setup\build\activiti-cfg.jar into D:\Develop\activiti-5.4\workspace\activiti-engine-examples\src\main\config

internal.classpath.libs:

internal.taskdef.launch:

h2.start:

cfg.create:
     [copy] Copying 1 file to D:\Develop\activiti-5.4\setup\build\activiti-cfg
     [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
    [unzip] Expanding: D:\Develop\activiti-5.4\setup\build\activiti-cfg.jar into D:\Develop\activiti-5.4\workspace\activiti-engine-examples\src\main\config

internal.classpath.libs:

db.create:
     [echo] creating db
     [java] 2011-4-5 9:13:24 org.activiti.engine.ProcessEngines initProcessEnginFromResource
     [java] 信息: initializing process engine for resource jar:file:/D:/Develop/activiti-5.4/setup/build/activiti-cfg.jar!/activiti.cfg.xml
     [java] ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
     [java] SLF4J: The requested version 1.6 by your slf4j binding is not compatible with [1.5.5, 1.5.6]
     [java] SLF4J: See http://www.slf4j.org/codes.html#version_mismatch for further details.
     [java] 2011-4-5 9:13:25 oracle.jdbc.driver.OracleDriver registerMBeans
     [java] 警告: Error while registering Oracle JDBC Diagnosability MBean.
     [java] java.security.AccessControlException: access denied (javax.management.MBeanTrustPermission register)
     [java]    at java.security.AccessControlContext.checkPermission(AccessControlContext.java:374)
     [java]    at java.lang.SecurityManager.checkPermission(SecurityManager.java:568)
     [java]    at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.checkMBeanTrustPermission(DefaultMBeanServerInterceptor.java:1824)
     [java]    at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:310)
     [java]    at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:482)
     [java]    at oracle.jdbc.driver.OracleDriver.registerMBeans(OracleDriver.java:360)
     [java]    at oracle.jdbc.driver.OracleDriver$1.run(OracleDriver.java:199)
     [java]    at java.security.AccessController.doPrivileged(Native Method)
     [java]    at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:195)
     [java]    at java.lang.Class.forName0(Native Method)
     [java]    at java.lang.Class.forName(Class.java:247)
     [java]    at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.initializeDriver(UnpooledDataSource.java:173)
     [java]    at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:57)
     [java]    at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:349)
     [java]    at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:55)
     [java]    at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDatabaseType(ProcessEngineConfigurationImpl.java:426)
     [java]    at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDataSource(ProcessEngineConfigurationImpl.java:390)
     [java]    at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:259)
     [java]    at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:236)
     [java]    at org.activiti.engine.ProcessEngines.buildProcessEngine(ProcessEngines.java:177)
     [java]    at org.activiti.engine.ProcessEngines.initProcessEnginFromResource(ProcessEngines.java:150)
     [java]    at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:88)
     [java]    at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.java:207)
     [java]    at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEngines.java:200)
     [java]    at org.activiti.engine.impl.db.DbSchemaUpdate.main(DbSchemaUpdate.java:34)
     [java]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
     [java]    at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
     [java]    at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
     [java]    at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
     [java]    at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
     [java]    at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
     [java]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]    at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]    at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
     [java]    at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
     [java]    at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
     [java]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]    at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]    at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]    at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
     [java]    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
     [java]    at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]    at org.apache.tools.ant.Main.runBuild(Main.java:809)
     [java]    at org.apache.tools.ant.Main.startAnt(Main.java:217)
     [java]    at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
     [java]    at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
     [java] 2011-4-5 9:13:27 org.activiti.engine.impl.interceptor.CommandContext close
     [java] 严重: Error while closing command context
     [java] org.apache.ibatis.exceptions.PersistenceException: 
     [java] ### Error querying database.  Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java] 
     [java] ### The error may involve org.activiti.persistence.selectProperty-Inline
     [java] ### The error occurred while setting parameters
     [java] ### Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java] 
     [java]    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
     [java]    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
     [java]    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
     [java]    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38)
     [java]    at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:195)
     [java]    at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:601)
     [java]    at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:854)
     [java]    at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)
     [java]    at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
     [java]    at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
     [java]    at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
     [java]    at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:77)
     [java]    at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:237)
     [java]    at org.activiti.engine.ProcessEngines.buildProcessEngine(ProcessEngines.java:177)
     [java]    at org.activiti.engine.ProcessEngines.initProcessEnginFromResource(ProcessEngines.java:150)
     [java]    at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:88)
     [java]    at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.java:207)
     [java]    at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEngines.java:200)
     [java]    at org.activiti.engine.impl.db.DbSchemaUpdate.main(DbSchemaUpdate.java:34)
     [java]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
     [java]    at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
     [java]    at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
     [java]    at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
     [java]    at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
     [java]    at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
     [java]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]    at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]    at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
     [java]    at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
     [java]    at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
     [java]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]    at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]    at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]    at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
     [java]    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
     [java]    at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]    at org.apache.tools.ant.Main.runBuild(Main.java:809)
     [java]    at org.apache.tools.ant.Main.startAnt(Main.java:217)
     [java]    at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
     [java]    at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
     [java] Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java] 
     [java]    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
     [java]    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
     [java]    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
     [java]    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
     [java]    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
     [java]    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
     [java]    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
     [java]    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
     [java]    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
     [java]    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
     [java]    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
     [java]    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
     [java]    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
     [java]    at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)
     [java]    at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
     [java]    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
     [java]    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
     [java]    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
     [java]    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)
     [java]    … 56 more
     [java] 2011-4-5 9:13:27 org.activiti.engine.ProcessEngines initProcessEnginFromResource
     [java] 严重: Exception while initializing process engine :
     [java] ### Error querying database.  Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java] 
     [java] ### The error may involve org.activiti.persistence.selectProperty-Inline
     [java] ### The error occurred while setting parameters
     [java] ### Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java] 
     [java] org.apache.ibatis.exceptions.PersistenceException: 
     [java] ### Error querying database.  Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java] 
     [java] ### The error may involve org.activiti.persistence.selectProperty-Inline
     [java] ### The error occurred while setting parameters
     [java] ### Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java] 
     [java]    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
     [java]    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
     [java]    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
     [java]    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38)
     [java]    at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:195)
     [java]    at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:601)
     [java]    at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:854)
     [java]    at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)
     [java]    at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
     [java]    at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
     [java]    at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
     [java]    at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:77)
     [java]    at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:237)
     [java]    at org.activiti.engine.ProcessEngines.buildProcessEngine(ProcessEngines.java:177)
     [java]    at org.activiti.engine.ProcessEngines.initProcessEnginFromResource(ProcessEngines.java:150)
     [java]    at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:88)
     [java]    at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.java:207)
     [java]    at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEngines.java:200)
     [java]    at org.activiti.engine.impl.db.DbSchemaUpdate.main(DbSchemaUpdate.java:34)
     [java]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
     [java]    at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
     [java]    at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
     [java]    at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
     [java]    at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
     [java]    at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
     [java]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]    at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]    at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
     [java]    at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
     [java]    at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
     [java]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]    at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]    at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]    at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
     [java]    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
     [java]    at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]    at org.apache.tools.ant.Main.runBuild(Main.java:809)
     [java]    at org.apache.tools.ant.Main.startAnt(Main.java:217)
     [java]    at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
     [java]    at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
     [java] Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java] 
     [java]    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
     [java]    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
     [java]    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
     [java]    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
     [java]    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
     [java]    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
     [java]    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
     [java]    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
     [java]    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
     [java]    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
     [java]    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
     [java]    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
     [java]    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
     [java]    at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)
     [java]    at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
     [java]    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
     [java]    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
     [java]    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
     [java]    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)
     [java]    … 56 more
     [java] java.lang.NullPointerException
     [java]    at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:194)
     [java]    at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
     [java]    at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
     [java]    at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
     [java]    at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
     [java]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]    at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]    at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
     [java]    at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
     [java]    at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
     [java]    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]    at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]    at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]    at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]    at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
     [java]    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
     [java]    at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]    at org.apache.tools.ant.Main.runBuild(Main.java:809)
     [java]    at org.apache.tools.ant.Main.startAnt(Main.java:217)
     [java]    at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
     [java]    at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
     [java] Caused by: java.lang.NullPointerException
     [java]    at org.activiti.engine.impl.db.DbSchemaUpdate.main(DbSchemaUpdate.java:35)
     [java]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]    at java.lang.reflect.Method.invoke(Method.java:597)
     [java]    at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
     [java]    at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
     [java]    … 33 more
     [java] Java Result: -1

cfg.create:
     [copy] Copying 1 file to D:\Develop\activiti-5.4\setup\build\activiti-cfg
      [zip] Building zip: D:\Develop\activiti-5.4\setup\build\activiti-cfg.jar
     [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
    [unzip] Expanding: D:\Develop\activiti-5.4\setup\build\activiti-cfg.jar into D:\Develop\activiti-5.4\workspace\activiti-engine-examples\src\main\config

internal.classpath.libs:

db.demo.data:
     [echo] populating demo data
    [mkdir] Created dir: D:\Develop\activiti-5.4\setup\build\demo
     [copy] Copying 1 file to D:\Develop\activiti-5.4\setup\build\demo
      [sql] Executing resource: D:\Develop\activiti-5.4\setup\build\demo\oracle.data.sql
      [sql] Failed to execute:  insert into ACT_ID_GROUP values ('admin',       1, 'System administrator', 'security-role')

BUILD FAILED
D:\Develop\activiti-5.4\setup\build.xml:157: The following error occurred while executing this line:
D:\Develop\activiti-5.4\setup\build.xml:227: java.sql.SQLException: ORA-00942: 表或视图不存在

   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
   at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
   at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1890)
   at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855)
   at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
   at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:775)
   at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:745)
   at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1055)
   at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:985)
   at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:653)
   at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
   at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
   at org.apache.tools.ant.Task.perform(Task.java:348)
   at org.apache.tools.ant.Target.execute(Target.java:390)
   at org.apache.tools.ant.Target.performTasks(Target.java:411)
   at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
   at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
   at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
   at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
   at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
   at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
   at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
   at org.apache.tools.ant.Task.perform(Task.java:348)
   at org.apache.tools.ant.Target.execute(Target.java:390)
   at org.apache.tools.ant.Target.performTasks(Target.java:411)
   at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
   at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
   at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
   at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
   at org.apache.tools.ant.Main.runBuild(Main.java:809)
   at org.apache.tools.ant.Main.startAnt(Main.java:217)
   at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
   at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)

Total time: 10 seconds
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
Labels:
0 Kudos
6 REPLIES 6

jbarrez
Star Contributor
Star Contributor

‎04-04-2011 02:54 AM

I tested it here with postgres and mysql, and the database was created fine.

Do you have a trace of running the demo setup on Oracle?
0 Kudos

ylybbs
Champ in-the-making
Champ in-the-making

‎04-04-2011 09:20 PM

I tested it here with postgres and mysql, and the database was created fine.

Do you have a trace of running the demo setup on Oracle?

I have added the ant output log.

Here is my ojdbc5.jar\META-INF\MANIFEST.MF's content

MANIFEST.MF
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.6.5
Created-By: 1.5.0_24-rev-b08 (Sun Microsystems Inc.)
Implementation-Vendor: Oracle Corporation
Implementation-Title: JDBC
Implementation-Version: 11.2.0.2.0
Repository-Id: JAVAVM_11.2.0.2.0_LINUX_100812.1
Specification-Vendor: Sun Microsystems Inc.
Specification-Title: JDBC
Specification-Version: 4.0
Main-Class: oracle.jdbc.OracleDriver
sealed: true

Name: oracle/sql/converter/
Sealed: false

Name: oracle/sql/
Sealed: false

Name: oracle/sql/converter_xcharset/
Sealed: false
0 Kudos

ylybbs
Champ in-the-making
Champ in-the-making

‎04-04-2011 10:59 PM

i notice flowing warning
警告: Error while registering Oracle JDBC Diagnosability MBean.
     [java] java.security.AccessControlException: access denied (javax.management.MBeanTrustPermission register)
so add this snippet into my jre policy file
permission javax.management.MBeanTrustPermission "register";
then i run ant demo.clean demo.start ,no more java.security.AccessControlException error but it still warn table not exist.

demo.install:
     [echo] installing demo

internal.define.jdbc.driver.libs:

build.webapps:
    [mkdir] Created dir: D:\Develop\activiti-5.4\setup\build\webapps
     [copy] Copying 1414 files to D:\Develop\activiti-5.4\setup\build\webapps
     [copy] Copied 442 empty directories to 5 empty directories under D:\Develop\activiti-5.4\setup\build\webapps
     [copy] Copying 50 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-explorer.war\WEB-INF\lib
     [copy] Copying 50 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-probe.war\WEB-INF\lib
     [copy] Copying 50 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-cycle.war\WEB-INF\lib
     [copy] Copying 17 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-kickstart.war\WEB-INF\lib
     [copy] Copying 25 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-administrator.war\WEB-INF\lib
     [copy] Copying 129 files to D:\Develop\activiti-5.4\setup\build\webapps\activiti-rest.war\WEB-INF\lib

internal.db.install.h2:

internal.db.install.h2.unnecessary:
     [echo] H2 is already installed

internal.db.install.unsupported:
     [echo] Automatic installation of oracle DB not supported.  It is assumed to be installed and running

h2.install:

cfg.create:
    [mkdir] Created dir: D:\Develop\activiti-5.4\setup\build\activiti-cfg
     [copy] Copying 1 file to D:\Develop\activiti-5.4\setup\build\activiti-cfg
      [zip] Building zip: D:\Develop\activiti-5.4\setup\build\activiti-cfg.jar
     [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
    [unzip] Expanding: D:\Develop\activiti-5.4\setup\build\activiti-cfg.jar into D:\Develop\activiti-5.4\workspace\activiti-engine-examples\src\main\config

internal.classpath.libs:

internal.taskdef.launch:

h2.start:

cfg.create:
     [copy] Copying 1 file to D:\Develop\activiti-5.4\setup\build\activiti-cfg
     [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
    [unzip] Expanding: D:\Develop\activiti-5.4\setup\build\activiti-cfg.jar into D:\Develop\activiti-5.4\workspace\activiti-engine-examples\src\main\config

internal.classpath.libs:

db.create:
     [echo] creating db
     [java] 2011-4-5 10:30:22 org.activiti.engine.ProcessEngines initProcessEnginFromResource
     [java] 信息: initializing process engine for resource jar:file:/D:/Develop/activiti-5.4/setup/build/activiti-cfg.jar!/activiti.cfg.xml
     [java] ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
     [java] SLF4J: The requested version 1.6 by your slf4j binding is not compatible with [1.5.5, 1.5.6]
     [java] SLF4J: See http://www.slf4j.org/codes.html#version_mismatch for further details.
     [java] 2011-4-5 10:30:25 org.activiti.engine.impl.interceptor.CommandContext close
     [java] 严重: Error while closing command context
     [java] org.apache.ibatis.exceptions.PersistenceException:
     [java] ### Error querying database.  Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java]
     [java] ### The error may involve org.activiti.persistence.selectProperty-Inline
     [java] ### The error occurred while setting parameters
     [java] ### Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java]
     [java]  at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
     [java]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
     [java]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
     [java]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38)
     [java]  at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:195)
     [java]  at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:601)
     [java]  at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:854)
     [java]  at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)
     [java]  at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
     [java]  at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
     [java]  at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
     [java]  at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:77)
     [java]  at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:237)
     [java]  at org.activiti.engine.ProcessEngines.buildProcessEngine(ProcessEngines.java:177)
     [java]  at org.activiti.engine.ProcessEngines.initProcessEnginFromResource(ProcessEngines.java:150)
     [java]  at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:88)
     [java]  at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.java:207)
     [java]  at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEngines.java:200)
     [java]  at org.activiti.engine.impl.db.DbSchemaUpdate.main(DbSchemaUpdate.java:34)
     [java]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]  at java.lang.reflect.Method.invoke(Method.java:597)
     [java]  at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
     [java]  at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
     [java]  at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
     [java]  at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
     [java]  at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
     [java]  at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
     [java]  at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]  at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]  at java.lang.reflect.Method.invoke(Method.java:597)
     [java]  at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]  at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]  at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]  at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]  at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]  at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
     [java]  at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]  at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
     [java]  at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
     [java]  at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]  at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]  at java.lang.reflect.Method.invoke(Method.java:597)
     [java]  at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]  at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]  at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]  at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]  at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]  at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
     [java]  at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
     [java]  at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]  at org.apache.tools.ant.Main.runBuild(Main.java:809)
     [java]  at org.apache.tools.ant.Main.startAnt(Main.java:217)
     [java]  at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
     [java]  at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
     [java] Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java]
     [java]  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
     [java]  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
     [java]  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
     [java]  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
     [java]  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
     [java]  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
     [java]  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
     [java]  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
     [java]  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
     [java]  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
     [java]  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
     [java]  at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
     [java]  at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
     [java]  at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)
     [java]  at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
     [java]  at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
     [java]  at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
     [java]  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
     [java]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)
     [java]  … 56 more
     [java] 2011-4-5 10:30:25 org.activiti.engine.ProcessEngines initProcessEnginFromResource
     [java] 严重: Exception while initializing process engine :
     [java] ### Error querying database.  Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java]
     [java] ### The error may involve org.activiti.persistence.selectProperty-Inline
     [java] ### The error occurred while setting parameters
     [java] ### Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java]
     [java] org.apache.ibatis.exceptions.PersistenceException:
     [java] ### Error querying database.  Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java]
     [java] ### The error may involve org.activiti.persistence.selectProperty-Inline
     [java] ### The error occurred while setting parameters
     [java] ### Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java]
     [java]  at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
     [java]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
     [java]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
     [java]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38)
     [java]  at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:195)
     [java]  at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:601)
     [java]  at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:854)
     [java]  at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)
     [java]  at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
     [java]  at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
     [java]  at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
     [java]  at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:77)
     [java]  at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:237)
     [java]  at org.activiti.engine.ProcessEngines.buildProcessEngine(ProcessEngines.java:177)
     [java]  at org.activiti.engine.ProcessEngines.initProcessEnginFromResource(ProcessEngines.java:150)
     [java]  at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:88)
     [java]  at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.java:207)
     [java]  at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEngines.java:200)
     [java]  at org.activiti.engine.impl.db.DbSchemaUpdate.main(DbSchemaUpdate.java:34)
     [java]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]  at java.lang.reflect.Method.invoke(Method.java:597)
     [java]  at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
     [java]  at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
     [java]  at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
     [java]  at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
     [java]  at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
     [java]  at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
     [java]  at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]  at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]  at java.lang.reflect.Method.invoke(Method.java:597)
     [java]  at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]  at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]  at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]  at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]  at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]  at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
     [java]  at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]  at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
     [java]  at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
     [java]  at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]  at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]  at java.lang.reflect.Method.invoke(Method.java:597)
     [java]  at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]  at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]  at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]  at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]  at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]  at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
     [java]  at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
     [java]  at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]  at org.apache.tools.ant.Main.runBuild(Main.java:809)
     [java]  at org.apache.tools.ant.Main.startAnt(Main.java:217)
     [java]  at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
     [java]  at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
     [java] Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在
     [java]
     [java]  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
     [java]  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
     [java]  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
     [java]  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
     [java]  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
     [java]  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
     [java]  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
     [java]  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
     [java]  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
     [java]  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
     [java]  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
     [java]  at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
     [java]  at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
     [java]  at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)
     [java]  at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
     [java]  at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
     [java]  at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
     [java]  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
     [java]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)
     [java]  … 56 more
     [java] java.lang.NullPointerException
     [java]  at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:194)
     [java]  at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
     [java]  at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
     [java]  at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
     [java]  at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
     [java]  at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]  at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]  at java.lang.reflect.Method.invoke(Method.java:597)
     [java]  at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]  at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]  at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]  at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]  at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]  at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
     [java]  at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]  at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
     [java]  at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
     [java]  at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
     [java]  at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
     [java]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]  at java.lang.reflect.Method.invoke(Method.java:597)
     [java]  at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
     [java]  at org.apache.tools.ant.Task.perform(Task.java:348)
     [java]  at org.apache.tools.ant.Target.execute(Target.java:390)
     [java]  at org.apache.tools.ant.Target.performTasks(Target.java:411)
     [java]  at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
     [java]  at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
     [java]  at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
     [java]  at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
     [java]  at org.apache.tools.ant.Main.runBuild(Main.java:809)
     [java]  at org.apache.tools.ant.Main.startAnt(Main.java:217)
     [java]  at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
     [java]  at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
     [java] Caused by: java.lang.NullPointerException
     [java]  at org.activiti.engine.impl.db.DbSchemaUpdate.main(DbSchemaUpdate.java:35)
     [java]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]  at java.lang.reflect.Method.invoke(Method.java:597)
     [java]  at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
     [java]  at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
     [java]  … 33 more
     [java] Java Result: -1

cfg.create:
     [copy] Copying 1 file to D:\Develop\activiti-5.4\setup\build\activiti-cfg
      [zip] Building zip: D:\Develop\activiti-5.4\setup\build\activiti-cfg.jar
     [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
    [unzip] Expanding: D:\Develop\activiti-5.4\setup\build\activiti-cfg.jar into D:\Develop\activiti-5.4\workspace\activiti-engine-examples\src\main\config

internal.classpath.libs:

db.demo.data:
     [echo] populating demo data
    [mkdir] Created dir: D:\Develop\activiti-5.4\setup\build\demo
     [copy] Copying 1 file to D:\Develop\activiti-5.4\setup\build\demo
      [sql] Executing resource: D:\Develop\activiti-5.4\setup\build\demo\oracle.data.sql
      [sql] Failed to execute:  insert into ACT_ID_GROUP values ('admin',       1, 'System administrator', 'security-role')

BUILD FAILED
D:\Develop\activiti-5.4\setup\build.xml:157: The following error occurred while executing this line:
D:\Develop\activiti-5.4\setup\build.xml:227: java.sql.SQLException: ORA-00942: 表或视图不存在

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1890)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:775)
at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:745)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1055)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:985)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:653)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:390)
at org.apache.tools.ant.Target.performTasks(Target.java:411)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)
at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:390)
at org.apache.tools.ant.Target.performTasks(Target.java:411)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
at org.apache.tools.ant.Main.runBuild(Main.java:809)
at org.apache.tools.ant.Main.startAnt(Main.java:217)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)

Total time: 10 seconds
0 Kudos

jbarrez
Star Contributor
Star Contributor

‎04-05-2011 04:02 AM

This is most definitely a bug, created http://jira.codehaus.org/browse/ACT-762

The problem is probably related to the fact you have a chinese Oracle (and our logic checks an English exception message).
0 Kudos

frederikherema1
Star Contributor
Star Contributor

‎04-05-2011 05:41 AM

Hi,

Seems that the bug above (ACT-762), isn't causing the issue. The demo-setup has dbSchemaUpdate set to true, which checks the availablity of the tables through the JDBC meta-data.

Is the user you configured in jdbc-properties an oracle DBA? And does your oracle contain other schema with activiti in it? Because the JDBC-metadata on oracle sees all tables (even other schema) of you run as DBA (which is not reccomended to run application as DBA)
0 Kudos

ylybbs
Champ in-the-making
Champ in-the-making

‎04-08-2011 10:57 PM

Hi,

Seems that the bug above (ACT-762), isn't causing the issue. The demo-setup has dbSchemaUpdate set to true, which checks the availablity of the tables through the JDBC meta-data.

Is the user you configured in jdbc-properties an oracle DBA? And does your oracle contain other schema with activiti in it? Because the JDBC-metadata on oracle sees all tables (even other schema) of you run as DBA (which is not reccomended to run application as DBA)
yes,my oracle db contain another schema with activiti tables and my demo db user has a DBA role,when i revoke the dba role from the demo dbuser,and just connection and resource roles remained,the demo.start can work. thanks.
0 Kudos
Getting started

Tags

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2025 Khoros, LLC