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

15 views
Skip to first unread message

an sowmya

unread,
Mar 10, 2019, 1:19:17 PM3/10/19
to Slick / ScalaQuery
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 

sql.png

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

unread,
Mar 10, 2019, 1:31:43 PM3/10/19
to scala...@googlegroups.com
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

unread,
Mar 11, 2019, 12:14:42 AM3/11/19
to scala...@googlegroups.com
I am using slick 3.2 and numThreads=8 


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


--
with Regards,
 
A.N.Sowmya 
Reply all
Reply to author
Forward
0 new messages