Issues connecting to sql server using slick extensions

[Preethi Dasa]

Hi,

I am running a Windows VM with sql server ( with port forwarding). I am having trouble connecting to the db.

These are the dependencies:

"com.typesafe.slick" %% "slick" % "3.1.0",
"com.typesafe.slick" %% "slick-hikaricp" % "3.1.0",
"com.typesafe.slick" %% "slick-extensions" % "3.1.0",
"net.sourceforge.jtds" % "jtds" % "1.3.1",

And this is the code:

import com.typesafe.slick.driver.ms.SQLServerDriver.api._ 

import slick.jdbc.meta.MTable

import scala.concurrent.Await 

import scala.concurrent.duration._ 

val db = Database.forURL("jdbc:sqlserver://localhost:1433;databaseName=mydb;encrypt=false;trustServerCertificate=true;",driver="com.typesafe.slick.driver.ms.SQLServerDriver") 

val f = Await.result(db.run(MTable.getTables), 1.second) 

Gives this error: 

slick.SlickException: Driver com.typesafe.slick.driver.ms.SQLServerDriver does not know how to handle URL jdbc:sqlserver://localhost:1433;databaseName=mydb;encrypt=false;trustServerCertificate=true; 

  at slick.jdbc.DriverDataSource$$anonfun$init$2$$anonfun$apply$3.apply(DriverDataSource.scala:67) 

  at slick.jdbc.DriverDataSource$$anonfun$init$2$$anonfun$apply$3.apply(DriverDataSource.scala:62) 

. 

. 

Caused by: java.sql.SQLException: No suitable driver 

Can anybody give me some leads? Any help is appreciated.

Thanks,

Preethi 

[wolfgan...@hotmail.com]

I run into the same issue! Could you solve the problem?

[Ruslans Tarasovs]

As a minimum the one need to replace "jdbc:sqlserver" by "jdbc:jtds" if the one uses jTDS as a driver.

See the following for more details:

http://jtds.sourceforge.net/faq.html#urlFormat