how to connect to postgresql in play framework 2.0 (Java)

Question

i am have problem while connecting to postgresql with playframework.

error is Driver not found: [org.postgresql.Driver]

we have added Code in application.conf:

db.default.url="postgres://localhost:root@secret/testdb"
db.default.driver=org.postgresql.Driver
db.default.user=""
db.default.password=""

code in Build.scala:

"postgresql" % "postgresql" % "9.1-902.jdbc4"

And we have placed postgresql-9.1-902.jdbc4.jar file in libraries folder

Could anyone has suggestions regarding this problem.

James Ward · Accepted Answer · 2012-06-28 15:42:23Z

4

I don't think that is a valid version of the Postgres library. Try:

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

Then restart Play.

answered Jun 28, 2012 at 15:42

James Ward

29.4k9 gold badges52 silver badges85 bronze badges

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

2 Comments

DSKVP Over a year ago

Hi james, thank you very much.. we are getting another problem regarding the line db.default.url="jdbc:postgresql://localhost/testdb" cannot connect to the database [default]

James Ward Over a year ago

You should ask another question for that with details of the error message.

Brian Agnew · Accepted Answer · 2012-06-28 15:37:01Z

1

Do you have the PostgreSQL JDBC driver in your classpath ? See the final section of this document.

For example, if you use MySQL5, you need to add a dependency for the connector:

val appDependencies = Seq(
     // Add your project dependencies here,
     ...
     "mysql" % "mysql-connector-java" % "5.1.18"
     ...
)

answered Jun 28, 2012 at 15:37

Brian Agnew

273k38 gold badges342 silver badges443 bronze badges

2 Comments

DSKVP Over a year ago

Hi Brian,thank you for replying ... I have added the app dependencies in the build.scala file as you specified. but still i am getting same error.

Salil Over a year ago

@user1156917, Brian was giving an example. The exact line to be added in dependency is: "postgresql" % "postgresql" % "9.1-902.jdbc4"

Bjarni Sævarsson · Accepted Answer · 2012-06-28 15:55:14Z

0

You are most likely missing the jdbc driver.

Get the driver from http://jdbc.postgresql.org/download.html.
Place it in the lib/ directory in application folder.

edited Jun 28, 2012 at 15:55

answered Jun 28, 2012 at 15:37

Bjarni Sævarsson

1762 silver badges8 bronze badges

4 Comments

DSKVP Over a year ago

Hi Bjarni, thanks for replying.. We have added the jar file. But i am still getting the same error

Bjarni Sævarsson Over a year ago

The driver version is correct, as long as you downloaded "postgresql-9.1-902.jdbc4.jar". Are you sure you placed the file in the "application/lib" folder?

Bjarni Sævarsson Over a year ago

The url changed in play 2 db.default.url="postgres://user:password@servername/dataBaseName"

DSKVP Over a year ago

we have the code: "postgres://a:a@localhost/testdb". but still we are getting the same problem

Collectives™ on Stack Overflow

how to connect to postgresql in play framework 2.0 (Java)

3 Answers 3

2 Comments

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related