Postgresql with Play Framework

Question

Im trying to use Postgresql with Play for their Yabe tutorial and get this error:

Cannot connected to the database, Driver not found (org.postgresql.Driver)

Here is my connection string:

# If you need a full JDBC configuration use the following :
 db.url=jdbc:postgresql:yabe
 db.driver=org.postgresql.Driver  
 db.user=yabe
 db.pass=yabe
#
# Connections pool configuration :
 db.pool.timeout=1000
 db.pool.maxSize=30
 db.pool.minSize=1

In my lib folder I have this: postgresql-9.1-901.jdbc3.jar

I tried changing the driver name to the same name is tha jar but still get the same error. Any ideas?

Have you checked that the org.postgresql.Driver is in the Jar? — niels
– niels, Commented Oct 12, 2011 at 10:37
Hi Niels. I didn't. I downloaded the driver from Postgresql. Ill check what you suggested. — Todd
– Todd, Commented Oct 12, 2011 at 12:12
I added a dependency for this in the .yml file and it successfully downloads the .jar file. I still get this error though. A database error occured : Cannot connected to the database, Driver not found (postgresql-9.0-801.jdbc4.jar) — Todd
– Todd, Commented Oct 12, 2011 at 23:15
heres whats in the jar. repo1.maven.org/maven2/postgresql/postgresql/9.0-801.jdbc4 — Todd
– Todd, Commented Oct 13, 2011 at 20:59

Anthony Skipper · Accepted Answer · 2012-05-28 15:29:23Z

40

If you are using Play 2.0 this works slightly differently. The url actually looks like this:

db.default.driver=org.postgresql.Driver
db.default.url="postgres://user:password@servername/dataBaseName"

But this will also error out unless you add the following lines to you dependencies section in build.scala or build.java:

"postgresql" % "postgresql" % "9.1-901.jdbc4"

edited May 28, 2012 at 15:29

answered May 28, 2012 at 15:12

Anthony Skipper

9241 gold badge9 silver badges11 bronze badges

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

Comments

reen · Accepted Answer · 2011-12-08 14:45:49Z

13

If you need SSL support:

db=postgres://user:[email protected]:5432/dbname?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory

answered Dec 8, 2011 at 14:45

reen

2,5025 gold badges30 silver badges41 bronze badges

Comments

Pere Villega · Accepted Answer · 2011-10-13 11:05:48Z

10

The Play framework already includes the driver for Postgres. do the following:

Remove any reference to postgreSQL drivers from your dependencies.yml files
Do a "play deps --sync"
Remove any jar in your lib/ folder related to postgreSQL drivers
Change your connection string to:

db=postgres://user:pwd@localhost:5432/yabe

This should solve the conflict you have.

answered Oct 13, 2011 at 11:05

Pere Villega

16.4k5 gold badges66 silver badges100 bronze badges

2 Comments

Mike Slinn Over a year ago

None of this is true for Play 2

Pere Villega Over a year ago

@MikeSlinn yes, well, this was a Play 1 question :)

Alan · Accepted Answer · 2011-10-11 21:15:47Z

6

You don't need to edit a full JDBC configuration. I use postgesql in local and I just add this line in application.conf file in conf folder :

# To connect to a local PostgreSQL9 database, use:
db=postgres://userName:yourPassword@localhost:5432/nameOfYourDB

If you are in local, userName is often postgres unless you changed it.

answered Oct 11, 2011 at 21:15

Alan

1501 silver badge5 bronze badges

1 Comment

Todd Over a year ago

I tried what you suggested and this is the error i receive: A JPA error occurred (Cannot start a JPA manager without a properly configured database): No datasource configured

sojin · Accepted Answer · 2011-10-12 23:58:15Z

3

You should copy PostgresSql driver version "JDBC 4" [What you have is JDBC 3]. Get it from here

Alternatively you may use - postgresql 9.1-901.jdbc4 in your dependencies. But I think Maven doesn't have this latest version yet.

answered Oct 12, 2011 at 23:58

sojin

4,7842 gold badges39 silver badges41 bronze badges

4 Comments

Todd Over a year ago

Copy? Doesn't the dependency pull it down?

sojin Over a year ago

Dependency will pull it down if the jar is available in Maven central. But as I said, this latest version is not available yet. mvnrepository.com/artifact/postgresql/postgresql

Todd Over a year ago

It doesnt matter what version i pull down. I get an error. Here is what i have setup: application.conf db.url=jdbc:postgresql:yabe db.driver=postgresql-9.0-801.jdbc4.jar db.user=yabe db.pass=password dependancies.yml require: - play - postgresql -> postgresql 9.0-801.jdbc4 The error: A database error occured : Cannot connected to the database, Driver not found (postgresql-9.0-801.jdbc4.jar) What am I doing wrong?

kdazzle Over a year ago

libraryDependencies += "postgresql" % "postgresql" % "9.1-901.jdbc4"

Collectives™ on Stack Overflow

Postgresql with Play Framework

5 Answers 5

Comments

Comments

2 Comments

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

2 Comments

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related