akpbond
akpbond

Reputation: 21

Not able to connect to postgres database using play slick

I'm trying to connect to postgres via play slick.

my application conf file

slick.dbs.default.driver= "slick.driver.PostgresDriver$"
slick.dbs.default.db.dataSourceClass = "slick.jdbc.DatabaseUrlDataSource"
slick.dbs.default.db.properties.driver = "org.postgresql.Driver"
slick.dbs.default.db.url = url
slick.dbs.default.db.user=username
slick.dbs.default.db.password=password

Normally I connect via val connection = DB.getConnection()

How to connect when i'm using click?

Upvotes: 1

Views: 537

Answers (1)

Henrique Gonçalves
Henrique Gonçalves

Reputation: 1582

add to your application.conf an entry like:

slick.dbs {
  default.driver="slick.driver.PostgresDriver$"
  default.db.driver="org.postgresql.Driver"
  default.db.url=url
  default.db.user=user
  default.db.password=password
}

then, to get the connection (since this config is DatabaseConfig format) use:

val dbConfig: DatabaseConfig[PostgresDriver] = DatabaseConfig.forConfig("slick.dbs.default")
val db = dbConfig.db

Upvotes: 1

Related Questions