How to setup Play Slick with Postgresql

Question

I'm trying for the first time to setup a Play project and I already got stuck! In fact when I run the application I get this exception as soon as I try to call "http://localhost:9000/":

java.sql.SQLTransientConnectionException: db - Connection is not available, request timed out after 1004ms

I also get this in the logs every 2 seconds:

[error] c.z.h.p.PoolBase - db - Failed to execute isValid() for connection, configure connection test query. (Method org.postgresql.jdbc4.Jdbc4Connection.isValid(int) is not yet implemented.)

This is what I did:

Code side I just created a class DAO to add, remove and list the records for the user table and called the "add" method from the controller.

I hope I gave enough details

This sounds like a connection leak! Can you also show us how you use the DB Connection object to make the database calls? — joesan
Thanks for the answer. I added the part where I do the calls to the db — Mirko
Did you try logging the calls from Slick? logger.scala.slick=DEBUG — joesan
I tried now but nothing changed because I noticed that the exception is triggered before everything, even before the controller is called — Mirko
Can you perhaps avoid using play-slick library? Have a look at my answer! — joesan

Mirko Mirko · Accepted Answer · 2018-02-06T19:10:05

I found the final solution using the Play Slick library, configuring it in this way:

You can see the versions of Slick and Play used in the PlaySlick library from the table in this page

How to setup Play Slick with Postgresql

2 Answers