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

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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", …