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

[linkedtounivers]

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?

[frederikherema1]

Your databaseType is wrong, you have ".javax.sql.DataSource". According to the user guid, it should be one of "h2", "mysql", "oracle", …

[linkedtounivers]

Thanks, it worked!