Slick application for login works fine but hangs after some idle time

[an sowmya]

Hi

      My Scala Slick application for Login is working , but after some idle time  , if i send request it hangs  for few minutes.

My db config looks like this 

val dbConfig: DatabaseConfig[JdbcProfile] = DatabaseConfig.forConfig("sql")

 val db: JdbcProfile#Backend#Database = dbConfig.db

I am getting error like this 

The connection is closed. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:227) at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:796) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setNetworkTimeout(SQLServerConnection.java:4768) at com.zaxxer.hikari.pool.PoolBase.setNetworkTimeout(PoolBase.java:494) at com.zaxxer.hikari.pool.PoolBase.quietlyCloseConnection(PoolBase.java:130) at com.zaxxer.hikari.pool.HikariPool$1.run(HikariPool.java:414) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

Can anyone help in solving this

Thank you

[Naftoli Gugenheim]

What version of Slick? And is it showing any warnings about maxThreads?

--

---
You received this message because you are subscribed to the Google Groups "Slick / ScalaQuery" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scalaquery+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/scalaquery/da0a50e9-4db9-43e5-9fdd-61901b4086dc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[an sowmya]

I am using slick 3.2 and numThreads=8 

To view this discussion on the web visit https://groups.google.com/d/msgid/scalaquery/CANpg8PCsOM0PHD500dsoeL-vaF%3DuNqyMcjJgzu6damXJXqHu6w%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

with Regards,

 

A.N.Sowmya