CODEWITHSUNDEEP
sql-server-2008jdbcplayframework
Deval Bhatt
Deval Bhatt

Reputation: 25

sql server connection in play framework

How we can connect to Microsoft SQL Server in play framework.

I am able to connect MYSql.

I have done following config in application.conf file :

db.default.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
db.default.url="jdbc:sqlserver://localhost\\SQLEXPRESS:1433;databaseName=test"
db.default.username=sa
db.default.password="test01"

I have also try with copy sqljdbc4.jar in my Project -> libexec folder.

Upvotes: 0

Views: 1462

Answers (1)

Tony Vincent
Tony Vincent

Reputation: 14282

Try adding the following to application.config 

db.default.hikaricp.connectionTestQuery="SELECT 1"

Upvotes: 1

Related Questions