nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

activiti installation with oracle or mssql

dheuman

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.6
2) installed tomcat7.052 on /usr/share/apache-tomcat path (work fine)
3) downloaded activiti from main site
4) unziped the archive
5) deployed the war file (activiti-explorer.war) using the tomcat application manager (my link: http://192.168.0.245:8080/manager/html)
6) opened the link "http://192.168.0.245:8080/activiti-explorer/" and it work (can see login page and access using kermit/kermit)

now i tried to modified the db.properties file to configure a mssql or oracle connection

7) created a blank schema on oracle db (activiti) and create a database on mssql (both tested using oracle-developper-tool)
8 ) downloaded the JDBC Driver 4.0 (sqljdbc4.jar file) from http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
9) downloaded the ojdbc6.jar from http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
10) copy and paste both file to /usr/share/apache-tomcat-7.0.52/webapps/activiti-explorer/WEB-INF/lib/
11) edited the classes/db.properties file:
"db=mssql
jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://151.1.180.50:1433/activiti
jdbc.username=activiti
jdbc.password=activiti"

for mssql and

"db=oracle
jdbc.driver=oracle.jdbc.OracleDriver
jdbc.url=jdbc

racle:thin:@localhost:1521

rcl
jdbc.username=ACTIVITI
jdbc.password=ACTIVITI"

for oracle

12) via tomcat manager stop/start the application but none of this will work. Where am I wrong?

I can advise you to do a better step-by-step installation guide?

Thx advance

Find more posts tagged with

Comments

trademak

Hi,

Do you see an stack trace in the Tomcat log?

Best regards,

dheuman

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.<br>mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject<br>WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.<br>mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject<br>WARNING: Error in serialization of the application: Class org.activiti.explorer.ui.MainWindow must implement serialization.<br>mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject<br>WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.<br>mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject<br>WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.<br>mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject<br>WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.<br>mar 03, 2014 11:17:04 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc<br>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.<br>mar 03, 2014 11:18:16 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc<br>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.<br>mar 03, 2014 11:27:07 AM org.apache.catalina.util.LifecycleBase start<br>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.<br>tInterceptor.execute(CommandContextInterceptor.java:57)<br> at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)<br> at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)<br> at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)<br> at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<br> at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)<br> at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)<br> at org.activiti.engine.impl.TaskServiceImpl.claim(TaskServiceImpl.java:160)<br> at org.activiti.explorer.demo.DemoDataGenerator$1.run(DemoDataGenerator.java:273)<br> at java.lang.Thread.run(Unknown Source)<br>Exception in thread "http-apr-8080-exec-23" java.lang.OutOfMemoryError: PermGen space<br>

[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.<br>mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject<br>WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.<br>mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject<br>WARNING: Error in serialization of the application: Class org.activiti.explorer.ui.MainWindow must implement serialization.<br>mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject<br>WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.<br>mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject<br>WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.<br>mar 03, 2014 11:17:04 AM com.vaadin.event.ListenerMethod writeObject<br>WARNING: Error in serialization of the application: Class com.vaadin.ui.Panel must implement serialization.<br>mar 03, 2014 11:17:04 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc<br>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.<br>mar 03, 2014 11:18:16 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc<br>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.<br>mar 03, 2014 11:27:07 AM org.apache.catalina.util.LifecycleBase start<br>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<br>WARNING: Cannot serialize session attribute notificationManager for session AA9F7DB39C2F6861A0B0102C12927EC2<br>java.io.NotSerializableException: org.activiti.spring.SpringProcessEngineConfiguration<br> at java.io.ObjectOutputStream.writeObject0(Unknown Source)<br> &hellip;&hellip;&hellip;<br> at java.io.ObjectOutputStream.writeObject(Unknown Source)<br> at java.util.LinkedList.writeObject(Unknown Source)<br> at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br> at java.lang.reflect.Method.invoke(Unknown Source)<br> at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source)<br> &hellip;&hellip;.<br> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)<br> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)<br> at java.lang.Thread.run(Unknown Source)<br><br>mar 03, 2014 11:17:04 AM org.apache.catalina.core.ApplicationContext log<br>INFO: Closing Spring root WebApplicationContext<br>mar 03, 2014 11:17:16 AM org.apache.catalina.core.ApplicationContext log<br>INFO: No Spring WebApplicationInitializer types detected on classpath<br>mar 03, 2014 11:17:16 AM org.apache.catalina.core.ApplicationContext log<br>INFO: Initializing Spring root WebApplicationContext<br>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&nbsp; - Error while closing command context<br>org.activiti.engine.ActivitiObjectNotFoundException: Cannot find task with id 6195<br> at org.activiti.engine.impl.cmd.NeedsActiveTaskCmd.execute(NeedsActiveTaskCmd.java:54)<br> at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)<br> at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)<br> at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)<br> at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)<br> at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)<br> at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<br> at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)<br> at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)<br> at org.activiti.engine.impl.TaskServiceImpl.claim(TaskServiceImpl.java:160)<br> at org.activiti.explorer.demo.DemoDataGenerator$1.run(DemoDataGenerator.java:273)<br> at java.lang.Thread.run(Unknown Source)<br>&hellip;.

aitor

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

dheuman

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.

aitor

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 = jdbc

racle: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

dheuman

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

dheuman

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:

<br>&hellip;.<br>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<br>&hellip;. &hellip; 45 more<br>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<br>&hellip;.<br>

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:

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

Any Idea would be appreciated
Thx

frederikherema1

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

dheuman

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

frederikherema1

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?

dheuman

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

jbarrez

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"

dheuman

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.

jordan_blair

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…

lifejoice

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.

tchu_2000

@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!

sunilkumartk

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