play slick database configuration issues with postgres driver

Question

I'm trying to set up a simple play 2.5 application with slick and postgres, but can't seem to get past an error.
The error I'm getting is

[error] p.a.d.s.DefaultSlickApi - Failed to create Slick database config for key default.
slick.SlickException: Error getting instance of profile "slick.jdbc.PostgresProfile"
...
Caused by: java.lang.InstantiationException: slick.jdbc.PostgresProfile
...
Caused by: java.lang.NoSuchMethodException: slick.jdbc.PostgresProfile.<init>()
...

I've got the following in my application.conf

slick.dbs.default {
  driver = "slick.jdbc.PostgresProfile"
  db = {
    driver = "org.postgresql.Driver"

    user = postgres
    host = localhost
    port = 5432
    password = ""

    host = ${?EVENTUAL_DB_HOST}
    port = ${?EVENTUAL_DB_PORT}
    user = ${?EVENTUAL_DB_USER}
    password = ${?EVENTUAL_DB_PW}
    url = "jdbc:postgresql://"${slick.dbs.default.db.host}":"${slick.dbs.default.db.port}"/"${slick.dbs.default.db.user}
  }
}

and these in my dependencies

  "com.typesafe.play" %% "play-slick" % "2.1.0",
  "com.typesafe.slick" %% "slick-codegen" % "3.1.1",
  "com.github.tminglei" %% "slick-pg" % "0.15.0-RC", //"0.14.6",
  "org.postgresql" % "postgresql" % "42.0.0"

if I change slick.dbs.default.driver to slick.driver.PostgresDriver (which is now deprecated evidently) I get

[error] p.a.d.s.DefaultSlickApi - Failed to create Slick database config for key default.
slick.SlickException: Error getting instance of profile "slick.driver.PostgresDriver"
...
Caused by: java.lang.ClassNotFoundException: slick.driver.PostgresDriver
...

I'm about pulling my hair out here and can't find any other resources to look at. Does anyone have any idea what's going on?

Maybe slick.dbs.default.driver="slick.driver.PostgresDriver$" and not Profile? — insan-e
– insan-e, Commented Apr 13, 2017 at 18:29
@insan-e sorry I had a typo there, I had tried slick.driver.PostgresDriver and I think I had tried slick.driver.PostgresDriver$ as well with the same result, but let me try again just in case. — kag0
– kag0, Commented Apr 13, 2017 at 18:31
@insan-e whelp, went back and tried with slick.jdbc.PostgresProfile$ and now it works. If you want to submit an answer I'll accept it, otherwise I'll self answer a it later. — kag0
– kag0, Commented Apr 14, 2017 at 15:26
I have a working example for play 2.5 + Slick + MySQL (yes, I know it's not Postgresql, but maybe you can find some problem comparing both. It shouldn't be very hard migration the example from MySQL to Postgresql): github.com/pedrorijo91/play-slick3-steps/tree/play2.5 (if you need a written tutorial, there's one at pedrorijo.com/blog/play-slick) — pedrorijo91
– pedrorijo91, Commented Apr 14, 2017 at 20:15

kag0 · Accepted Answer · 2017-04-17 06:28:07Z

8

Sure enough, by recommendation of insan-e, all I had to do was add a $. So slick.dbs.default.driver should be "slick.jdbc.PostgresProfile$".

answered Apr 17, 2017 at 6:28

kag0

6,1148 gold badges41 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

rocky Over a year ago

what that $ means in this context? why its needed?

kag0 Over a year ago

@freakman it has do to do with compiled class names, see something like stackoverflow.com/questions/11388840/…

rocky Over a year ago

but its strange in some places you need to pass full class name with $ and in other ones without it

Collectives™ on Stack Overflow

play slick database configuration issues with postgres driver

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related