topic Integration Test: Standalone & App Server Datasource conflict -help in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/integration-test-standalone-app-server-datasource-conflict-help/m-p/140470#M98402 <HTML><HEAD></HEAD><BODY><SPAN>Using JUnit for Integration testing I am trying to kick-off workflows which are already deployed on the application server. I have a HumanTask with a custom ExecutionListener. ExecutionListener loads SpringApplicationContext to make a JDBC call (using JdbcDaoSupport)&nbsp; via ActivitDS datasource like this: </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>&lt;jee:jndi-lookup id="dataSource" jndi-name="jdbc/ActivitiDS" expected-type="org.activiti.spring.SpringProcessEngineConfiguration" /&gt;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><BR /><BR /><SPAN> In my Integ test I am using a standalone datasource, which points to the same database as the server's datasource.</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp; &lt;bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="driverClassName" value="${jdbc.driver}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="url" value="${jdbc.url}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="username" value="${jdbc.username}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="password" value="${jdbc.password}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="defaultAutoCommit" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp; &lt;/bean&gt; <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Unit Test</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />public class WorkflowTest {<BR /><BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp; @Rule<BR />&nbsp;&nbsp;&nbsp;&nbsp; public ActivitiRule activitiRule = new ActivitiRule();<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp; @Test<BR />&nbsp;&nbsp;&nbsp;public void test() {<BR />&nbsp;&nbsp;&nbsp;// Start<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RuntimeService runtimeService = activitiRule.getRuntimeService();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Map&lt;String, Object&gt; variableMap = new HashMap&lt;String, Object&gt;();<BR />………………………<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessInstance processInstance = runtimeService<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.startProcessInstanceByKey("MyProcess", variableMap);<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><BR /><SPAN>After starting the Test, when the execution comes to ExecutionListener - I get a datasource init exception :</SPAN><BR /><BR /><SPAN style="color:red;"> Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource': Invocation of init method failed; nested exception is javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:&nbsp; java.naming.factory.initial</SPAN><BR /><BR /><SPAN>JUnit test uses the same Spring Context (incl datasource) thro its lifecycle, it perhaps is not able to create another datasource at ExecutionListner? I know I can mock the behaviour of the ExecutionListener, but since this being an Integ Test I have to get actual data in my ExecutionListener .</SPAN><BR /><SPAN>Any ideas are welcome.</SPAN></BODY></HTML> Mon, 29 Jul 2013 22:06:34 GMT rangoo 2013-07-29T22:06:34Z Integration Test: Standalone & App Server Datasource conflict -help https://connect.hyland.com/t5/alfresco-archive/integration-test-standalone-app-server-datasource-conflict-help/m-p/140470#M98402 Using JUnit for Integration testing I am trying to kick-off workflows which are already deployed on the application server. I have a HumanTask with a custom ExecutionListener. ExecutionListener loads SpringApplicationContext to make a JDBC call (using JdbcDaoSupport)&nbsp; via ActivitDS datasource like t Mon, 29 Jul 2013 22:06:34 GMT https://connect.hyland.com/t5/alfresco-archive/integration-test-standalone-app-server-datasource-conflict-help/m-p/140470#M98402 rangoo 2013-07-29T22:06:34Z Re: Integration Test: Standalone & App Server Datasource conflict -help https://connect.hyland.com/t5/alfresco-archive/integration-test-standalone-app-server-datasource-conflict-help/m-p/140471#M98403 <HTML><HEAD></HEAD><BODY><SPAN>Looks like JNDI look up is the issue.</SPAN><BR /><BR /><SPAN>To give a little more perspective - I am using Custom Jars(for ExecutionListeners) and&nbsp; I am placing them inside activiti-explorer lib. Now&nbsp; for some reason JNDI look-up for Datasource from Custom jar is failing .&nbsp; I have the same datasource working perfectly in a Webapp .</SPAN><BR /><BR /><SPAN> Is it because Look-up is from a JAR inside another webapp(explorer)? If so can I somehow re-use the Datasource of&nbsp; activiti-explorer ?</SPAN></BODY></HTML> Mon, 29 Jul 2013 23:39:29 GMT https://connect.hyland.com/t5/alfresco-archive/integration-test-standalone-app-server-datasource-conflict-help/m-p/140471#M98403 rangoo 2013-07-29T23:39:29Z Re: Integration Test: Standalone & App Server Datasource conflict -help https://connect.hyland.com/t5/alfresco-archive/integration-test-standalone-app-server-datasource-conflict-help/m-p/140472#M98404 <HTML><HEAD></HEAD><BODY><SPAN>It's definitely a JNDI lookup exception. Are you sure you have all necessary dependencies on the classpath to do a JNDI lookup and don't you need more configuration like server + port for the JNDI lookup?</SPAN><BR /></BODY></HTML> Tue, 30 Jul 2013 09:45:59 GMT https://connect.hyland.com/t5/alfresco-archive/integration-test-standalone-app-server-datasource-conflict-help/m-p/140472#M98404 trademak 2013-07-30T09:45:59Z