AnsweredAssumed Answered

Error: activiti.javax.sql.DataSource.create.engine.sql is not available

Question asked by linkedtouniverse on Apr 23, 2013
Latest reply on Apr 24, 2013 by linkedtouniverse
Hello,

I'm new to Activiti, I've tried the example of bookorder and worked fine.

Now i'm trying to use my data base but I'm getting this error:

Caused by: org.activiti.engine.ActivitiException: resource 'org/activiti/db/create/activiti.javax.sql.DataSource.create.engine.sql' is not available

This is my configuration:


<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:activiti="http://www.activiti.org/schema/spring/components"
   xsi:schemaLocation="http://www.springframework.org/schema/beans   
                           http://www.springframework.org/schema/beans/spring-beans.xsd
                           http://www.springframework.org/schema/context 
                           http://www.springframework.org/schema/context/spring-context-2.5.xsd
                           http://www.springframework.org/schema/tx      
                           http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
                           http://www.activiti.org/schema/spring/components
                           http://www.activiti.org/schema/spring/components/activiti.xsd">

   <activiti:annotation-driven process-engine="processEngine" />

   <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
      <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
      <property name="url" value="${DB_URL}" />
      <property name="username" value="${DB_USER}" />
      <property name="password" value="${DB_PASS}" />
      <property name="defaultAutoCommit" value="false" />
   </bean>   

   <bean id="transactionManager"
      class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
      <property name="dataSource" ref="dataSource" />
   </bean>

   <bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
      <property name="databaseType" value="javax.sql.DataSource" />
      <property name="dataSource" ref="dataSource" />
      <property name="transactionManager" ref="transactionManager" />
      <property name="databaseSchemaUpdate" value="true" />
      <property name="deploymentResources" value="classpath*:bookorder/myprocess.bpmn20.xml" />
      <property name="history" value="audit" />
      <property name="jobExecutorActivate" value="false" />
   </bean>

   <bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean">
      <property name="processEngineConfiguration" ref="processEngineConfiguration" />
   </bean>

   <bean id="repositoryService" factory-bean="processEngine"
      factory-method="getRepositoryService" />
   <bean id="runtimeService" factory-bean="processEngine"
      factory-method="getRuntimeService" />
   <bean id="taskService" factory-bean="processEngine"
      factory-method="getTaskService" />
   <bean id="historyService" factory-bean="processEngine"
      factory-method="getHistoryService" />
   <bean id="managementService" factory-bean="processEngine"
      factory-method="getManagementService" />

   <bean id="initiator" class="org.activiti.ProcessInitiator" />

   <bean id="validateTask" class="org.activiti.ValidateOrderTask" />

   <bean id="bookOrder" class="org.activiti.BookOrder" scope="process" />

</beans>


can you please help?

Outcomes