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=jdbcracle:thin:@localhost:1521rcl
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

[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