I am trying Slick (JDBC) Connector tutorial
<https://developer.lightbend.com/docs/alpakka/current/slick.html> 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();
});`
--
>>>>>>>>>> Read the docs: http://akka.io/docs/
>>>>>>>>>> Check the FAQ:
>>>>>>>>>> http://doc.akka.io/docs/akka/current/additional/faq.html
>>>>>>>>>> Search the archives: https://groups.google.com/group/akka-user
---
You received this message because you are subscribed to the Google Groups "Akka
User List" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to akka-user+unsubscr...@googlegroups.com.
To post to this group, send email to akka-user@googlegroups.com.
Visit this group at https://groups.google.com/group/akka-user.
For more options, visit https://groups.google.com/d/optout.
