AnsweredAssumed Answered

activiti installation with oracle or mssql

Question asked by dheuman on Feb 28, 2014
Latest reply on Apr 27, 2016 by sunilkumartk
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:oracle:thin:@localhost:1521:orcl
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

Outcomes