topic Re: New Activiti 6 installation issue in Alfresco Archive

New Activiti 6 installation issue

noor_bpm — Tue, 22 Sep 2015 13:18:11 GMT

Hi team After deploying the activiti-app.war with DB changes for SQL Server in activiti-app.properities it shows the following error in tomcat consoleFollowed by step given by Tijs Rade (http://bpmn20inaction.blogspot.in/2015/09/getting-started-with-new-activiti-6-ui.html)so could you please help

Re: New Activiti 6 installation issue

jbarrez — Tue, 22 Sep 2015 15:45:00 GMT

It does look like your jdbc connections are wrong. the exception is "Connections could not be acquired from the underlying
database!" coming out of the connection pool.

Re: New Activiti 6 installation issue

noor_bpm — Mon, 28 Sep 2015 14:05:50 GMT

Thanks for the reply , could you please provide DB configuration parameters which required for MS SQL Server 2008
When I tried using below configuration for normal java application it works fine without any issues
datasource.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
datasource.url=jdbc:sqlserver://servername:1433;databaseName=activiti6ui
datasource.username=xxxx
datasource.password=xxxx

Re: New Activiti 6 installation issue

noor_bpm — Mon, 28 Sep 2015 14:05:50 GMT

Hi team,
Could you please help me regarding the SQL server connectivity for Activiti 6.0 beta version
I have modified the activiti-app.properities with the following and copy SQL server Driver (sqljdbc4.jar) to tomcat lib folder and inside \Tomcat 7.0\webapps\activiti-app\WEB-INF\lib also but there is no tables are created for activiti
and in console there is no exception as such and when i tried the http://localhost:8080/activiti-app/ it shows below error

HTTP Status 404 - /activiti-app/

type Status report

message /activiti-app/

description The requested resource is not available.

Apache Tomcat/7.0.64
DB properities
===========
datasource.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
datasource.url=jdbc:sqlserver://ServerName:1433;databaseName=activiti6ui
datasource.username=xxxxx
datasource.password=XXXXXX
hibernate.dialect=org.hibernate.dialect.SQLServerDialect

Thanks
Noor

Re: New Activiti 6 installation issue

exaltedjim — Mon, 05 Oct 2015 04:01:35 GMT

I managed to get activiti-app connecting to my sql server database with these settings:


datasource.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
datasource.url=jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=xxx
datasource.username=xxx
datasource.password=xxx
hibernate.dialect=org.hibernate.dialect.SQLServer2008Dialect

Re: New Activiti 6 installation issue

sunilkumartk — Fri, 25 Aug 2017 04:04:16 GMT

Heres a video on how how to install Activiti 6.0 on Oracle. The installation is similar in all types of databases. You just need to use the correct url to db.

Activiti 6 - Part 1 - Installation on Oracle - YouTube

Re: New Activiti 6 installation issue

monlee — Tue, 06 Feb 2018 18:49:32 GMT

In addition to what you have, I also have the following for the database

datasource.min-pool-size=5

datasource.max-pool-size=100

datasource.acquire-increment=5

datasource.preferred-test-query=select 1

datasource.test-connection-on-checkin=true

datasource.test-connection-on-checkout=true

datasource.max-idle-time=1800

datasource.max-idle-time-excess-connections=1800

Also, make sure you use the correct version of the MS SQL JDBC driver depending on your version of Java - sqljdbc42 is for Java 1.8, sqljdbc41 is for java 1.7.