topic REST Api with SQL Server Repository gives exception with context.xml in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/rest-api-with-sql-server-repository-gives-exception-with-context/m-p/156836#M111060 <HTML><HEAD></HEAD><BODY><SPAN>Prior to using SQL Server Repository I was using an in memory h2 DB which was working pretty fine.</SPAN><BR /><SPAN>Now I have change the db.properties file to point to my activiti db in SQL server for both activiti-explorer as well as activiti-rest.</SPAN><BR /><SPAN>I have executed sql server Create/Update scripts which got execute without any issues , I am able to create a process and start a process using acitviti explorer.</SPAN><BR /><BR /><SPAN>Using Rest api I am not able to fetch the process definition for the process deployed using activiti explorer. Do I need to deploy the same process using Activiti Rest api as well ?</SPAN><BR /><BR /><SPAN>Exception which get printed is :</SPAN><BR /><SPAN>*************************************************************************************************************************************</SPAN><BR /><SPAN>07:19:48,168 [http-8080-6] INFO&nbsp; org.activiti.engine.ProcessEngines&nbsp; - Initializing process engine using Spring configuration 'file:/D:/Program%20Files/apache-tomcat-6.0.36/webapps/activiti-rest/WEB-INF/classes/activiti-context.xml'</SPAN><BR /><SPAN>07:19:48,183 [http-8080-6] INFO&nbsp; org.springframework.beans.factory.xml.XmlBeanDefinitionReader&nbsp; - Loading XML bean definitions from URL [file:/D:/Program%20Files/apache-tomcat-6.0.36/webapps/activiti-rest/WEB-INF/classes/activiti-context.xml]</SPAN><BR /><SPAN>Mar 18, 2014 7:19:48 PM org.restlet.engine.application.StatusFilter doHandle</SPAN><BR /><SPAN>WARNING: Exception or error caught in status serviceorg.activiti.engine.ActivitiException: couldn't initialize process engine from spring configuration resource file:/D:/Program%20Files/apache-tomcat-6.0.36/webapps/activiti-rest/WEB-INF/classes/activiti-context.xml: null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.ProcessEngines.initProcessEngineFromSpringResource(ProcessEngines.java:130)</SPAN><BR /><SPAN>*************************************************************************************************************************************</SPAN><BR /><BR /><SPAN>My activiti-context.xml looks like this:</SPAN><BR /><SPAN>**************************************************************************************</SPAN><BR /><SPAN>&lt;beans xmlns="</SPAN><A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A><SPAN>"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;xmlns:context="</SPAN><A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A><SPAN>" xmlns:tx="</SPAN><A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A><SPAN>"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;xmlns:xsi="</SPAN><A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A><SPAN>"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;xsi:schemaLocation="</SPAN><A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A><SPAN> </SPAN><A href="http://www.springframework.org/schema/beans/spring-beans.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans/spring-beans.xsd</A><BR /><A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A><SPAN> </SPAN><A href="http://www.springframework.org/schema/context/spring-context-2.5.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context/spring-context-2.5.xsd</A><BR /><A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A><SPAN> </SPAN><A href="http://www.springframework.org/schema/tx/spring-tx-3.0.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx/spring-tx-3.0.xsd</A><SPAN>"&gt;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;!– Comment this if you don't need demo data –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;!–</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="demoDataGenerator" class="org.activiti.rest.service.demo.DemoDataGenerator"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;init-method="init"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="processEngine" ref="processEngine" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="createDemoUsersAndGroups" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="createDemoProcessDefinitions" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="createDemoModels" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="dbProperties"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="location" value="classpath:db.properties" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!– Allow other PropertyPlaceholderConfigurer to run as well –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;!–&nbsp;&nbsp;&nbsp;&lt;property name="ignoreUnresolvablePlaceholders" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><SPAN>–&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="dataSource"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.jdbc.datasource.SimpleDriverDataSource"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="driverClass" value="${jdbc.driver}" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="url" value="${jdbc.url}" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="username" value="${jdbc.username}" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="password" value="${jdbc.password}" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="transactionManager"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.jdbc.datasource.DataSourceTransactionManager"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><SPAN>&lt;!–</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="transactionManager" ref="transactionManager" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseSchemaUpdate" value="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="mailServerHost" value="localhost" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="mailServerPort" value="5025" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jobExecutorActivate" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><SPAN>–&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="processEngineConfiguration" ref="processEngineConfiguration" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><BR /><SPAN>&lt;/beans&gt;</SPAN><BR /><SPAN>***************************************************************************************************************</SPAN><BR /></BODY></HTML> Tue, 18 Mar 2014 13:55:35 GMT ysomavan 2014-03-18T13:55:35Z REST Api with SQL Server Repository gives exception with context.xml https://connect.hyland.com/t5/alfresco-archive/rest-api-with-sql-server-repository-gives-exception-with-context/m-p/156836#M111060 Prior to using SQL Server Repository I was using an in memory h2 DB which was working pretty fine.Now I have change the db.properties file to point to my activiti db in SQL server for both activiti-explorer as well as activiti-rest.I have executed sql server Create/Update scripts which got execute w Tue, 18 Mar 2014 13:55:35 GMT https://connect.hyland.com/t5/alfresco-archive/rest-api-with-sql-server-repository-gives-exception-with-context/m-p/156836#M111060 ysomavan 2014-03-18T13:55:35Z Re: REST Api with SQL Server Repository gives exception with context.xml https://connect.hyland.com/t5/alfresco-archive/rest-api-with-sql-server-repository-gives-exception-with-context/m-p/156837#M111061 <HTML><HEAD></HEAD><BODY><SPAN>Are you connecting it to the same DB as the Activiti Explorer? If so it should just work. Do you get back an empty array?</SPAN></BODY></HTML> Fri, 21 Mar 2014 16:30:56 GMT https://connect.hyland.com/t5/alfresco-archive/rest-api-with-sql-server-repository-gives-exception-with-context/m-p/156837#M111061 trademak 2014-03-21T16:30:56Z