topic Writing JUnit Test Cases for a workflow - Error initializing ActivityRule() in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/writing-junit-test-cases-for-a-workflow-error-initializing/m-p/215993#M169123 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to write a JUnit TC for my workflow using JUnit 4.0</P><P>Attached is my workflow.bpm.xml file. Also attached is my test case.</P><P>While starting the activityrule, I get the following exception:</P><P></P><P>org.apache.ibatis.exceptions.PersistenceException: <BR />### Error querying database.&nbsp; Cause: java.sql.SQLException: ORA-00942: table or view does not exist</P><P>### The error may exist in org/activiti/db/mapping/entity/Property.xml<BR />### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline<BR />### The error occurred while setting parameters<BR />### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?<BR />### Cause: java.sql.SQLException: ORA-00942: table or view does not exist</P><P>&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)<BR />&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)<BR />&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)<BR />&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)<BR />&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:453)<BR />&nbsp;at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:988)<BR />&nbsp;at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1369)<BR />&nbsp;at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)<BR />&nbsp;at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)<BR />&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)<BR />&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)<BR />&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)<BR />&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)<BR />&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<BR />&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)<BR />&nbsp;at org.activiti.engine.impl.ProcessEngineImpl.&lt;init&gt;(ProcessEngineImpl.java:74)<BR />&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:408)<BR />&nbsp;at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:66)<BR />&nbsp;at org.activiti.engine.impl.test.TestHelper.getProcessEngine(TestHelper.java:232)<BR />&nbsp;at org.activiti.engine.test.ActivitiRule.initializeProcessEngine(ActivitiRule.java:237)<BR />&nbsp;at org.activiti.engine.test.ActivitiRule.starting(ActivitiRule.java:205)<BR />&nbsp;at org.activiti.engine.test.ActivitiRule.startingQuietly(ActivitiRule.java:171)<BR />&nbsp;at org.activiti.engine.test.ActivitiRule.access$000(ActivitiRule.java:86)<BR />&nbsp;at org.activiti.engine.test.ActivitiRule$1.evaluate(ActivitiRule.java:124)<BR />&nbsp;at org.junit.rules.RunRules.evaluate(RunRules.java:20)<BR />&nbsp;at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)<BR />&nbsp;at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)<BR />&nbsp;at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)<BR />&nbsp;at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)<BR />&nbsp;at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)<BR />&nbsp;at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)<BR />&nbsp;at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)<BR />&nbsp;at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)<BR />&nbsp;at org.junit.runners.ParentRunner.run(ParentRunner.java:363)<BR />&nbsp;at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:678)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)<BR />Caused by: java.sql.SQLException: ORA-00942: table or view does not exist</P><P>&nbsp;at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)<BR />&nbsp;at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)<BR />&nbsp;at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)<BR />&nbsp;at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)<BR />&nbsp;at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)<BR />&nbsp;at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)<BR />&nbsp;at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)<BR />&nbsp;at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)<BR />&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)<BR />&nbsp;at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)<BR />&nbsp;at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)<BR />&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56)<BR />&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)<BR />&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)<BR />&nbsp;at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)<BR />&nbsp;at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)<BR />&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)<BR />&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)<BR />&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)<BR />&nbsp;... 38 more</P><P>java.lang.NullPointerException<BR />&nbsp;at com.pru.wf.engine.WorkflowTest.testFedFlow(WorkflowTest.java:27)<BR />&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<BR />&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR />&nbsp;at java.lang.reflect.Method.invoke(Method.java:498)<BR />&nbsp;at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)<BR />&nbsp;at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)<BR />&nbsp;at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)<BR />&nbsp;at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)<BR />&nbsp;at org.activiti.engine.test.ActivitiRule$1.evaluate(ActivitiRule.java:126)<BR />&nbsp;at org.junit.rules.RunRules.evaluate(RunRules.java:20)<BR />&nbsp;at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)<BR />&nbsp;at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)<BR />&nbsp;at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)<BR />&nbsp;at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)<BR />&nbsp;at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)<BR />&nbsp;at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)<BR />&nbsp;at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)<BR />&nbsp;at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)<BR />&nbsp;at org.junit.runners.ParentRunner.run(ParentRunner.java:363)<BR />&nbsp;at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:678)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)</P><P>java.lang.NullPointerException<BR />&nbsp;at org.activiti.engine.test.ActivitiRule.finished(ActivitiRule.java:273)<BR />&nbsp;at org.activiti.engine.test.ActivitiRule.finishedQuietly(ActivitiRule.java:179)<BR />&nbsp;at org.activiti.engine.test.ActivitiRule.access$400(ActivitiRule.java:86)<BR />&nbsp;at org.activiti.engine.test.ActivitiRule$1.evaluate(ActivitiRule.java:135)<BR />&nbsp;at org.junit.rules.RunRules.evaluate(RunRules.java:20)<BR />&nbsp;at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)<BR />&nbsp;at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)<BR />&nbsp;at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)<BR />&nbsp;at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)<BR />&nbsp;at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)<BR />&nbsp;at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)<BR />&nbsp;at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)<BR />&nbsp;at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)<BR />&nbsp;at org.junit.runners.ParentRunner.run(ParentRunner.java:363)<BR />&nbsp;at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:678)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)<BR />&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)</P><P></P><P>It appears that my way of initializing activityRule is not correct. Can anyone please guide?</P><P></P><P>Thank you.</P><P>Jayashree.</P></BODY></HTML> Tue, 27 Dec 2016 14:58:23 GMT gjaya26 2016-12-27T14:58:23Z Writing JUnit Test Cases for a workflow - Error initializing ActivityRule() https://connect.hyland.com/t5/alfresco-archive/writing-junit-test-cases-for-a-workflow-error-initializing/m-p/215993#M169123 Hi,I am trying to write a JUnit TC for my workflow using JUnit 4.0Attached is my workflow.bpm.xml file. Also attached is my test case.While starting the activityrule, I get the following exception<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.apache.ibatis.exceptions.PersistenceException: ### Error querying database.&nbsp; Cause: java.sql.SQLExc Tue, 27 Dec 2016 14:58:23 GMT https://connect.hyland.com/t5/alfresco-archive/writing-junit-test-cases-for-a-workflow-error-initializing/m-p/215993#M169123 gjaya26 2016-12-27T14:58:23Z Re: Writing JUnit Test Cases for a workflow - Error initializing ActivityRule() https://connect.hyland.com/t5/alfresco-archive/writing-junit-test-cases-for-a-workflow-error-initializing/m-p/215994#M169124 <HTML><HEAD></HEAD><BODY><P>Jayashree,</P><P></P><P>The best way to get started with a unit test is to use the Activiti Unit Test Archetype.<BR />This will build out the basic structure and create a starter configuration.</P><P></P><P>The Archetype is nicely documented here:&nbsp;<A class="link-titled" href="http://tech.blog.saeidmirzaei.com/?p=306" title="http://tech.blog.saeidmirzaei.com/?p=306" rel="nofollow noopener noreferrer">Activiti Maven Archetype | Saeid Mirzaei's Tech Blog</A>&nbsp;<BR /><BR />Hope this helps,<BR />Greg</P><P></P><P><A href="https://migration33.stage.lithium.com/t5/tag/bp3/tg-p"></A>‌</P></BODY></HTML> Mon, 09 Jan 2017 17:47:40 GMT https://connect.hyland.com/t5/alfresco-archive/writing-junit-test-cases-for-a-workflow-error-initializing/m-p/215994#M169124 gdharley 2017-01-09T17:47:40Z