unresolved dependency for postgresql 9.2 jar in play framework

Question

I am using postgresql 9.2 with play framework 2.1

I downloaded the driver here: http://jdbc.postgresql.org/download.html (JDBC4 Postgresql Driver, Version 9.2-1002)

My project/Build.scala file is as follows:

import sbt._
import Keys._
import play.Project._

object ApplicationBuild extends Build {

  val appName = "myApp"
  val appVersion = "0.1"

  val appDependencies = Seq(
    "postgresql" % "postgresql" % "9.2-1002.jdbc4")

  val main = play.Project(appName, appVersion, appDependencies)
}

I have placed the jdbc driver in the following locations in the play directory structure:

myApp/lib/postgresql-9.2-1002.jdbc4.jar
myApp/lib/9.2-1002.jdbc4.jar
myApp/lib/postgresql/postgresql/9.2-1002.jdbc4.jar

However, running the app with play run, I get the following error and the build fails:

[warn]  module not found: postgresql#postgresql;9.2-1002.jdbc4              
[warn] ==== local: tried
[warn]   /home/ubuntu/play-2.1.0/repository/local/postgresql/postgresql/9.2-1002.jdbc4/ivys/ivy.xml
[warn] ==== Typesafe Releases Repository: tried
[warn]   http://repo.typesafe.com/typesafe/releases/postgresql/postgresql/9.2-1002.jdbc4/postgresql-9.2-1002.jdbc4.pom
[warn] ==== Typesafe Snapshots Repository: tried
[warn]   http://repo.typesafe.com/typesafe/snapshots/postgresql/postgresql/9.2-1002.jdbc4/postgresql-9.2-1002.jdbc4.pom
[warn] ==== public: tried
[warn]   http://repo1.maven.org/maven2/postgresql/postgresql/9.2-1002.jdbc4/postgresql-9.2-1002.jdbc4.pom
[warn]  ::::::::::::::::::::::::::::::::::::::::::::::                       
[warn]  ::          UNRESOLVED DEPENDENCIES         ::
[warn]  ::::::::::::::::::::::::::::::::::::::::::::::
[warn]  :: postgresql#postgresql;9.2-1002.jdbc4: not found
[warn]  ::::::::::::::::::::::::::::::::::::::::::::::
sbt.ResolveException: unresolved dependency: postgresql#postgresql;9.2-1002.jdbc4: not found

Any tips on how to get the Play! to recognize my jar file?

ndeverge · Accepted Answer · 2013-02-12 19:48:29Z

14

The 9.2 version of Postgresql driver has not yet hit the Maven central repo, so you'll have to use the 9.1 version :

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

Or you can use the 9.2 version by dropping the JAR in your myApp/lib folder and remove any dependency from your project/Build.scala file (the lib folder is automatically added by sbt).

answered Feb 12, 2013 at 19:48

ndeverge

21.6k4 gold badges58 silver badges86 bronze badges

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

1 Comment

David Kaczynski Over a year ago

Yep, silly me. I need to remove the dependency from Build.scala if I want to include it manually in myApp/lib. Cheers

Ayoub · Accepted Answer · 2013-06-10 15:24:17Z

13

I have found this in the Repository:

"org.postgresql" % "postgresql" % "9.2-1003-jdbc4"

answered Jun 10, 2013 at 15:24

Ayoub

3565 silver badges16 bronze badges

1 Comment

mgttlinger Over a year ago

The newer versions are also there

Phuc Vuu · Accepted Answer · 2013-10-17 17:49:05Z

1

When I change 9.2 version to 9.1 version, it works perfectly. Thanks for your answer nico_ekito

My buid.scala

  val appDependencies = Seq(
  "postgresql" % "postgresql" % "9.1-901-1.jdbc4",
  jdbc,
  javaCore,
  javaEbean
  )

My application.conf

db.default.driver=org.postgresql.Driver
db.default.url="jdbc:postgresql://localhost:5432/DBName"
db.default.user=postgres
db.default.password=123456

answered Oct 17, 2013 at 17:49

Phuc Vuu

111 bronze badge

Comments

Raffaele Ciliberti · Accepted Answer · 2013-08-26 16:30:17Z

0

I solved the problem using the information at the following link:

https://github.com/tminglei/slick-pg/issues/1

I hope you find it useful!! :)

good luck ;)

linixinil.

answered Aug 26, 2013 at 16:30

Raffaele Ciliberti

1

1 Comment

Drew Over a year ago

Please describe the solution here -- do not just point to a URL.

Alfaville · Accepted Answer · 2014-08-17 21:07:40Z

0

In file application.conf:

 db.default.driver=org.postgresql.Driver
 db.default.url="jdbc:postgresql://localhost:5432/dataBaseName"
 db.default.user=user
 db.default.password="password"

create the pasta /lib in your main project and should add the .jar do postgres.

Download here, and after reload the project.

answered Aug 17, 2014 at 21:07

Alfaville

5537 silver badges16 bronze badges

Collectives™ on Stack Overflow

unresolved dependency for postgresql 9.2 jar in play framework

5 Answers 5

1 Comment

1 Comment

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related