topic Error: activiti.javax.sql.DataSource.create.engine.sql is not available in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-activiti-javax-sql-datasource-create-engine-sql-is-not/m-p/134747#M94573 <HTML><HEAD></HEAD><BODY><SPAN>Hello, </SPAN><BR /><BR /><SPAN>I'm new to Activiti, I've tried the example of bookorder and worked fine.</SPAN><BR /><BR /><SPAN>Now i'm trying to use my data base but I'm getting this error:</SPAN><BR /><BR /><SPAN>Caused by: org.activiti.engine.ActivitiException: resource 'org/activiti/db/create/activiti.javax.sql.DataSource.create.engine.sql' is not available</SPAN><BR /><BR /><SPAN>This is my configuration:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;beans xmlns="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A>"<BR />&nbsp;&nbsp;&nbsp;xmlns:context="<A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A>" xmlns:tx="<A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A>"<BR />&nbsp;&nbsp;&nbsp;xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:activiti="<A href="http://www.activiti.org/schema/spring/components" rel="nofollow noopener noreferrer">http://www.activiti.org/schema/spring/components</A>"<BR />&nbsp;&nbsp;&nbsp;xsi:schemaLocation="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A>&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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 />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A>&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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 />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www.activiti.org/schema/spring/components" rel="nofollow noopener noreferrer">http://www.activiti.org/schema/spring/components</A> <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www.activiti.org/schema/spring/components/activiti.xsd" rel="nofollow noopener noreferrer">http://www.activiti.org/schema/spring/components/activiti.xsd</A>"&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;activiti:annotation-driven process-engine="processEngine" /&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="url" value="${DB_URL}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="username" value="${DB_USER}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="password" value="${DB_PASS}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="defaultAutoCommit" value="false" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;&nbsp;&nbsp;&nbsp; <BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="transactionManager"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.jdbc.datasource.DataSourceTransactionManager"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseType" value="javax.sql.DataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="transactionManager" ref="transactionManager" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseSchemaUpdate" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="deploymentResources" value="classpath*:bookorder/myprocess.bpmn20.xml" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="history" value="audit" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jobExecutorActivate" value="false" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="processEngineConfiguration" ref="processEngineConfiguration" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="repositoryService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getRepositoryService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="runtimeService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getRuntimeService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="taskService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getTaskService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="historyService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getHistoryService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="managementService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getManagementService" /&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="initiator" class="org.activiti.ProcessInitiator" /&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="validateTask" class="org.activiti.ValidateOrderTask" /&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="bookOrder" class="org.activiti.BookOrder" scope="process" /&gt;<BR /><BR />&lt;/beans&gt;<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>‍</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><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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>can you please help?</SPAN></BODY></HTML> Tue, 23 Apr 2013 19:00:36 GMT linkedtounivers 2013-04-23T19:00:36Z Error: activiti.javax.sql.DataSource.create.engine.sql is not available https://connect.hyland.com/t5/alfresco-archive/error-activiti-javax-sql-datasource-create-engine-sql-is-not/m-p/134747#M94573 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 availableThis is my Tue, 23 Apr 2013 19:00:36 GMT https://connect.hyland.com/t5/alfresco-archive/error-activiti-javax-sql-datasource-create-engine-sql-is-not/m-p/134747#M94573 linkedtounivers 2013-04-23T19:00:36Z Re: Error: activiti.javax.sql.DataSource.create.engine.sql is not available https://connect.hyland.com/t5/alfresco-archive/error-activiti-javax-sql-datasource-create-engine-sql-is-not/m-p/134748#M94574 <HTML><HEAD></HEAD><BODY><SPAN>Your databaseType is wrong, you have ".javax.sql.DataSource". According to the user guid, it should be one of "h2", "mysql", "oracle", …</SPAN></BODY></HTML> Wed, 24 Apr 2013 09:41:46 GMT https://connect.hyland.com/t5/alfresco-archive/error-activiti-javax-sql-datasource-create-engine-sql-is-not/m-p/134748#M94574 frederikherema1 2013-04-24T09:41:46Z Re: Error: activiti.javax.sql.DataSource.create.engine.sql is not available https://connect.hyland.com/t5/alfresco-archive/error-activiti-javax-sql-datasource-create-engine-sql-is-not/m-p/134749#M94575 <HTML><HEAD></HEAD><BODY><SPAN>Thanks, it worked! </SPAN></BODY></HTML> Wed, 24 Apr 2013 11:54:20 GMT https://connect.hyland.com/t5/alfresco-archive/error-activiti-javax-sql-datasource-create-engine-sql-is-not/m-p/134749#M94575 linkedtounivers 2013-04-24T11:54:20Z