topic Setting up Oracle database for Activiti in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/setting-up-oracle-database-for-activiti/m-p/228825#M181955 <HTML><HEAD></HEAD><BODY><SPAN>Hi experts,</SPAN><BR /><BR /><SPAN>I'm switching Activiti application from in-memory database to Oracle. Scripts activiti.oracle.create.engine.sql, activiti.oracle.create.history.sql, activiti.oracle.create.identity.sql were successfully executed and all tables were created in the database. Application starts up fine and gets initialized without any problems. However, I get the following error when I try running one of my Activiti workflows. </SPAN><BR /><BR /><SPAN>Hibernate: select hibernate_sequence.nextval from dual</SPAN><BR /><SPAN>[2016-03-09 10:02:35] [W] [SqlExceptionHelper.logExceptions:144] SQL Error: 2289, SQLState: 42000</SPAN><BR /><SPAN>[2016-03-09 10:02:35] [E] [SqlExceptionHelper.logExceptions:146] ORA-02289: sequence does not exist</SPAN><BR /><BR /><SPAN>My workflow takes a couple of variables that are persisted in JPA repository. I understand that the error is returned because Hibernate can't find the sequence for generating IDs for my variables. </SPAN><BR /><BR /><SPAN>My question is whether I need to create this sequence myself or it's created by one of the scripts that I missed? Thanks a lot in advance!</SPAN><BR /><BR /><SPAN>By the way, I have the following settings to ensure that DDL scripts are not executed on start-up</SPAN><BR /><BR /><SPAN>spring.jpa.generate-ddl=false</SPAN><BR /><SPAN>spring.jpa.hibernate.ddl-auto=none</SPAN><BR /><BR /></BODY></HTML> Thu, 10 Mar 2016 15:50:06 GMT jubedus 2016-03-10T15:50:06Z Setting up Oracle database for Activiti https://connect.hyland.com/t5/alfresco-archive/setting-up-oracle-database-for-activiti/m-p/228825#M181955 Hi experts,I'm switching Activiti application from in-memory database to Oracle. Scripts activiti.oracle.create.engine.sql, activiti.oracle.create.history.sql, activiti.oracle.create.identity.sql were successfully executed and all tables were created in the database. Application starts up fine and g Thu, 10 Mar 2016 15:50:06 GMT https://connect.hyland.com/t5/alfresco-archive/setting-up-oracle-database-for-activiti/m-p/228825#M181955 jubedus 2016-03-10T15:50:06Z Re: Setting up Oracle database for Activiti https://connect.hyland.com/t5/alfresco-archive/setting-up-oracle-database-for-activiti/m-p/228826#M181956 <HTML><HEAD></HEAD><BODY><SPAN>Hi Andrei,</SPAN><BR /><BR /><SPAN>Which version of Activiti are you using? The Activiti Engine doesn't include Hibernate, only MyBatis. Or are you using Alfresco Activiti BPM Suite?</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Fri, 11 Mar 2016 08:27:43 GMT https://connect.hyland.com/t5/alfresco-archive/setting-up-oracle-database-for-activiti/m-p/228826#M181956 trademak 2016-03-11T08:27:43Z