topic Re: activiti installation with oracle or mssql in Alfresco Archive

activiti installation with oracle or mssql

dheuman — Fri, 28 Feb 2014 14:34:26 GMT

hi all, i need help, my activiti installation don't work when i try to change the default db (H2) to mssql or oracle. I had read the guide many time but is not clear about this.my sistem:is a oracle linux.my step:1) installed jdk1.62) installed tomcat7.052 on /usr/share/apache-tomcat path (work fine

Re: activiti installation with oracle or mssql

trademak — Sat, 01 Mar 2014 07:12:11 GMT

Hi,

Do you see an stack trace in the Tomcat log?

Best regards,

Re: activiti installation with oracle or mssql

dheuman — Mon, 03 Mar 2014 13:24:34 GMT

hello again. Now work with oracle. I just change the "jdbc.driver=oracle.jdbc.OracleDriver" to dbc.driver=oracle.jdbc.driver.OracleDriver

Not work with SQL Server. This is my log file:
NOTE*= this is a new installation on windows server 2008 (jre 7, tomcat 7). I have both (linux/windows) system on.

[h3]tomcat7-stderr[/h3]

SEVERE: The web application [/activiti-explorer] appears to have started a thread named [AWT-Windows] but has failed to stop it. This is very likely to create a memory leak.
mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject
WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.
mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject
WARNING: Error in serialization of the application: Class org.activiti.explorer.ui.MainWindow must implement serialization.
mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject
WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.
mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject
WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.
mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject
WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.
mar 03, 2014 11:17:04 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: The web application [/activiti-explorer] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
mar 03, 2014 11:18:16 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: The web application [/activiti-explorer] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
mar 03, 2014 11:27:07 AM org.apache.catalina.util.LifecycleBase start
INFO: The start() method was called on component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/activiti-explorer]] after start() had already been called. The second call will be ignored.
tInterceptor.execute(CommandContextInterceptor.java:57)
 at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
 at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
 at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
 at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
 at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
 at org.activiti.engine.impl.TaskServiceImpl.claim(TaskServiceImpl.java:160)
 at org.activiti.explorer.demo.DemoDataGenerator$1.run(DemoDataGenerator.java:273)
 at java.lang.Thread.run(Unknown Source)
Exception in thread "http-apr-8080-exec-23" java.lang.OutOfMemoryError: PermGen space

[h3]Catalina log[/h3]

SEVERE: The web application [/activiti-explorer] appears to have started a thread named [AWT-Windows] but has failed to stop it. This is very likely to create a memory leak.
mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject
WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.
mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject
WARNING: Error in serialization of the application: Class org.activiti.explorer.ui.MainWindow must implement serialization.
mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject
WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.
mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject
WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.
mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject
WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.
mar 03, 2014 11:17:04 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: The web application [/activiti-explorer] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
mar 03, 2014 11:18:16 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: The web application [/activiti-explorer] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
mar 03, 2014 11:27:07 AM org.apache.catalina.util.LifecycleBase start
INFO: The start() method was called on component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/activiti-explorer]] after start() had already been called. The second call will be ignored.

[h3]localhost log file[/h3]

mar 03, 2014 11:17:04 AM org.apache.catalina.session.StandardSession writeObject
WARNING: Cannot serialize session attribute notificationManager for session AA9F7DB39C2F6861A0B0102C12927EC2
java.io.NotSerializableException: org.activiti.spring.SpringProcessEngineConfiguration
 at java.io.ObjectOutputStream.writeObject0(Unknown Source)
 ………
 at java.io.ObjectOutputStream.writeObject(Unknown Source)
 at java.util.LinkedList.writeObject(Unknown Source)
 at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source)
 …….
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)

mar 03, 2014 11:17:04 AM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
mar 03, 2014 11:17:16 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
mar 03, 2014 11:17:16 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
mar 03, 2014 11:18:16 AM org.apache.catalina.session.StandardSession writeObject

[h3]tomcat std output[/h3]

11:17:31,239 [Thread-14] ERROR org.activiti.engine.impl.interceptor.CommandContext  - Error while closing command context
org.activiti.engine.ActivitiObjectNotFoundException: Cannot find task with id 6195
 at org.activiti.engine.impl.cmd.NeedsActiveTaskCmd.execute(NeedsActiveTaskCmd.java:54)
 at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
 at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
 at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
 at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
 at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
 at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
 at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
 at org.activiti.engine.impl.TaskServiceImpl.claim(TaskServiceImpl.java:160)
 at org.activiti.explorer.demo.DemoDataGenerator$1.run(DemoDataGenerator.java:273)
 at java.lang.Thread.run(Unknown Source)
….

Re: activiti installation with oracle or mssql

aitor — Mon, 03 Mar 2014 15:21:10 GMT

Hello,

In step 7 you said: created a <b>blank</b> schema on oracle db (activiti) …

Have you created the database structure with these scripts?

activiti-5.14\database\create\activiti.oracle.create.engine.sql
activiti-5.14\database\create\activiti.oracle.create.history.sql
activiti-5.14\database\create\activiti.oracle.create.identity.sql

Re: activiti installation with oracle or mssql

dheuman — Tue, 04 Mar 2014 07:43:02 GMT

Hello.

No i didn't create any database structure in oracle but it works (just in oracle). I think, the first time that the application started, has created all the necessary structure.

I'm still trying to run activiti on mssql without success. I tried with ojdbc v.4, ojdbc v.3 and jTDS driver also. No one of this want to work.

Re: activiti installation with oracle or mssql

aitor — Tue, 04 Mar 2014 11:49:55 GMT

Hello.

A works for me well. I have Oracle 10g. I added "ojdbc14.jar" in "WEB-INF\lib". My "WEB-INF\classes\db.properties" contains:

db = oracle
jdbc.driver = oracle.jdbc.OracleDriver
jdbc.url = jdbcracle:thin:@192.168.2.1:1521:MYDB
jdbc.username = myuser
jdbc.password = mypwd

I ran the three scripts: create.engine, create.history and create.identity

Re: activiti installation with oracle or mssql

dheuman — Tue, 04 Mar 2014 14:19:41 GMT

Hello. I said that work for me on oracle too. Not work on Microsoft Sql server.

Re: activiti installation with oracle or mssql

dheuman — Wed, 05 Mar 2014 09:12:40 GMT

By the way i tested the driver (sqljdbc4.jar) using Netbeans and it's work (same connection string). Is activiti-explorer that does not want to work.

log file catalina.out:


….
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: couldn't create db schema: create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_) where BUSINESS_KEY_ is not null
…. … 45 more
Caused by: org.activiti.engine.ActivitiException: couldn't create db schema: create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_) where BUSINESS_KEY_ is not null
….

using my database Client (oracle sql developer) i opened the file "activiti.mssql.create.engine.sql" located in "…./activiti-5.14/database/create/" path and run it as script.
The output is:


….. (many create table)
create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_) where BUSINESS_KEY_ is not null
Error row 172 column : 1
Errore SQL: Incorrect syntax near the keyword 'where'.
…..

Any Idea would be appreciated
Thx

Re: activiti installation with oracle or mssql

frederikherema1 — Mon, 10 Mar 2014 10:27:43 GMT

Are you sure activiti explorer is using the correct database-type?

Re: activiti installation with oracle or mssql

dheuman — Mon, 10 Mar 2014 10:33:42 GMT

I think so, the sql query above is located in "activiti.mssql.create.engine.sql" file.

Re: activiti installation with oracle or mssql

frederikherema1 — Mon, 10 Mar 2014 11:08:50 GMT

What version of mssql are you using? Our QA runs against 2008 using sqljdbc4.

What did you mean by "By the way i tested the driver (sqljdbc4.jar) using Netbeans and it's work". Did you test activiti-schema-creation or just that the driver works?

Re: activiti installation with oracle or mssql

dheuman — Mon, 10 Mar 2014 12:50:40 GMT

I tried with 2005, 2008 and 2008 r2.
I just tested that the driver connection work using netBeans.
After that i tried to execute the activiti.mssql.create.engine.sql using sqlOracleDevelopper obtaining the same error logged in catalina.out

Re: activiti installation with oracle or mssql

jbarrez — Tue, 11 Mar 2014 12:36:29 GMT

The Activiti QA uses

<code>
<dependency>
        <groupId>net.sourceforge.jtds</groupId>
        <artifactId>jtds</artifactId>
        <version>1.3.0</version>
      </dependency>
</code>

it seems.

However, with all the different issues in this thread I don't know what this latest one is.

Do note that your original stacktrace showed "Exception in thread "http-apr-8080-exec-23" java.lang.OutOfMemoryError: PermGen space"

Re: activiti installation with oracle or mssql

dheuman — Wed, 12 Mar 2014 08:23:28 GMT

What should I do with the code above?
In any case i've tried both the drivers (jtds and sqljdbc4) for mssql without success.
By the way, the logs shown in the first post refer to the tests with oracle. I will report in a bit the entire log with mssql.

Re: activiti installation with oracle or mssql

jordan_blair — Wed, 12 Mar 2014 14:36:44 GMT

I am running my own Activiti REST API application using SQL Server 2012 with JTDS… and am having no issues.

I am currently using this version of jtds in my maven pom.xml.
<dependency>
   <groupId>net.sourceforge.jtds</groupId>
   <artifactId>jtds</artifactId>
   <version>1.2.8</version>
</dependency>

In my application properties file…
jdbc.driver=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://SERVER_NAME:15015/MyDatabase;domain=MyDomain

I did run all three mssql create SQL scripts prior to trying to startup my Tomcat server…

Re: activiti installation with oracle or mssql

lifejoice — Thu, 03 Jul 2014 08:39:01 GMT

I have this problem too.

I tried and found that, you should add activiti.cfg.xml to your classpath, so that it will create the database schema.

My activiti version is 5.15.

Re: activiti installation with oracle or mssql

tchu_2000 — Thu, 30 Oct 2014 06:53:21 GMT

@dheuman: Thank you for the detailed installation steps!~
My environment is: Win7 64bit + JDK7 + Tomcat7 + Activiti 5.16.4 + sqljdbc4.jar copied to activiti-explorer\WEB-INF\lib
In fact I managed to link to mssql with the following db.properties settings:
db=mssql
jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=activiti
jdbc.username=sa
jdbc.password=

HTH!

Re: activiti installation with oracle or mssql

sunilkumartk — Wed, 27 Apr 2016 03:02:09 GMT

i have a blogpost on activiti Oracle DB configuration

http://techsunils.blogspot.com/2016/04/activiti-bpmn-configure-oracle-database.html

or a video

Activiti 5.22 Introduction and Installation - YouTube