New Activiti 6 installation issue

[noor_bpm]

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 console
Followed 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 me to resolve this issue and let me know any thing i missed
find the attachment of activiti-app.properities
tomcat_server_log_error.txt
Thanks
Noor

[jbarrez]

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.

[noor_bpm]

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

[noor_bpm]

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

[exaltedjim]

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


[sunilkumartk]

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 

[monlee]

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.