Help with exception with Slick JDBC connector for MS SQL Server

[indusbull]

I am trying Slick (JDBC) Connector tutorial to connect to MS SQL Server 2012 in my prototype Java Akka project. But I am having difficulties since last few hours to connect to DB through JDBC. It keeps throwing below exception - Not sure what I am missing either in config or code. It is simple example.

Exception:
java.sql.SQLTransientConnectionException: slick-sqlserver.db - Connection is not available, request timed out after 1001ms. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:548) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:145) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:83) at slick.jdbc.hikaricp.HikariCPJdbcDataSource.createConnection(HikariCPJdbcDataSource.scala:14) at slick.jdbc.JdbcBackend$BaseSession.<init>(JdbcBackend.scala:438) at slick.jdbc.JdbcBackend$DatabaseDef.createSession(JdbcBackend.scala:46) at slick.jdbc.JdbcBackend$DatabaseDef.createSession(JdbcBackend.scala:37) at slick.basic.BasicBackend$DatabaseDef.acquireSession(BasicBackend.scala:216) at slick.basic.BasicBackend$DatabaseDef.acquireSession$(BasicBackend.scala:215) at slick.jdbc.JdbcBackend$DatabaseDef.acquireSession(JdbcBackend.scala:37) at slick.basic.BasicBackend$DatabaseDef$$anon$3.run(BasicBackend.scala:279) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

application.config
slick-sqlserver {
 profile = "slick.jdbc.SQLServerProfile$" 

 db { 

     dataSourceClass = "slick.jdbc.DriverDataSource" 

     properties = { 

          driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver3;databaseName=dbname"
          url = "jdbc:sqlserver://host:1433"
          user = "username"
          password = "password"
     }
  }
}

My Code

ActorSystem system = ActorSystem.create("testSystem");
final Materializer materializer = ActorMaterializer.create(system);
final SlickSession session = SlickSession.forConfig("slick-sqlserver");

final CompletionStage<Done> done =
  Slick
    .source(
      session,
      "SELECT 1",
      //(SlickRow row) -> new Object(row.nextInt(), row.nextString())
      (SlickRow row) -> new Object()
    )
    .log("user")
    .runWith(Sink.ignore(), materializer);

done.whenComplete((value, exception) -> {
  session.close();
  system.terminate();
});`

[lutzh]

It doesn't really match the error message, but your "driver" entry looks a bit off to me - shouldn't that just be the driver class name?

I think the ";databaseName=<your database name>" would be attached to the URL part, not the driver. And the 3 before the ";", I don't know..

[indusbull]

My bad. It was typo while I was formatting to post here. Corrected app.conf with same exception -

application.config
slick-sqlserver {
 profile = "slick.jdbc.SQLServerProfile$"

 db {

     dataSourceClass = "slick.jdbc.DriverDataSource"

     properties = {

          driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
          url = "jdbc:sqlserver://host:1433;databaseName=dbname"