Configuration error: cannot connect to database[ebean]

[Hudson Taylor]

Hello there,

I am new to the Play Framework, currently learning how to connect to a database with Play 2.5.3

I get a Configuration error: cannot connect to database[ebean]  with logs as seen below.

Your help with this will be very appreciated

Warning: node.js detection failed, sbt will use the Rhino based Trireme JavaScri

pt engine instead to run JavaScript assets compilation, which in some cases may

be orders of magnitude slower than using node.js.

[info] application - Creating Pool for datasource 'ebean'

[error] c.z.h.HikariConfig - either dataSource or dataSourceClassName is required

[info] application - Creating Pool for datasource 'ebean'

[error] c.z.h.HikariConfig - either dataSource or dataSourceClassName is required

[info] application - Creating Pool for datasource 'ebean'

[error] c.z.h.HikariConfig - either dataSource or dataSourceClassName is required

[info] application - Creating Pool for datasource 'ebean'

[error] c.z.h.HikariConfig - either dataSource or dataSourceClassName is required

[error] application -

! @70f8o26fg - Internal server error, for (GET) [/dashboard] ->

play.api.Configuration$$anon$1: Configuration error[Cannot connect to database [

ebean]]

        at play.api.Configuration$.configError(Configuration.scala:154)

        at play.api.Configuration.reportError(Configuration.scala:806)

        at play.api.db.DefaultDBApi$$anonfun$connect$1.apply(DefaultDBApi.scala:48)

        at play.api.db.DefaultDBApi$$anonfun$connect$1.apply(DefaultDBApi.scala:42)

        at scala.collection.immutable.List.foreach(List.scala:381)

        at play.api.db.DefaultDBApi.connect(DefaultDBApi.scala:42)

        at play.api.db.DBApiProvider.get$lzycompute(DBModule.scala:72)

        at play.api.db.DBApiProvider.get(DBModule.scala:62)

        at play.api.db.DBApiProvider.get(DBModule.scala:58)

        at com.google.inject.internal.ProviderInternalFactory.provision(Provider

InternalFactory.java:81)

Caused by: play.api.Configuration$$anon$1: Configuration error[either dataSource

 or dataSourceClassName is required]

        at play.api.Configuration$.configError(Configuration.scala:154)

        at play.api.PlayConfig.reportError(Configuration.scala:996)

        at play.api.db.HikariCPConnectionPool.create(HikariCPModule.scala:69)

        at play.api.db.PooledDatabase.createDataSource(Databases.scala:200)

        at play.api.db.DefaultDatabase.dataSource$lzycompute(Databases.scala:124

)

        at play.api.db.DefaultDatabase.dataSource(Databases.scala:122)

        at play.api.db.DefaultDatabase.getConnection(Databases.scala:143)

        at play.api.db.DefaultDatabase.getConnection(Databases.scala:139)

        at play.api.db.DefaultDBApi$$anonfun$connect$1.apply(DefaultDBApi.scala:44)

        at play.api.db.DefaultDBApi$$anonfun$connect$1.apply(DefaultDBApi.scala:42)

Caused by: java.lang.IllegalArgumentException: either dataSource or dataSourceClassName is required

        at com.zaxxer.hikari.HikariConfig.validate(HikariConfig.java:785)

        at play.api.db.HikariCPConfig.toHikariConfig(HikariCPModule.scala:140)

        at play.api.db.HikariCPConnectionPool$$anonfun$1.apply(HikariCPModule.scala:57)

        at play.api.db.HikariCPConnectionPool$$anonfun$1.apply(HikariCPModule.scala:54)

        at scala.util.Try$.apply(Try.scala:192)

        at play.api.db.HikariCPConnectionPool.create(HikariCPModule.scala:54)

        at play.api.db.PooledDatabase.createDataSource(Databases.scala:200)

        at play.api.db.DefaultDatabase.dataSource$lzycompute(Databases.scala:124

)

        at play.api.db.DefaultDatabase.dataSource(Databases.scala:122)

        at play.api.db.DefaultDatabase.getConnection(Databases.scala:143)

[Suraj Mundada]

Please check if your application.conf for DB configuration. Below should work for Play Java 2.5.x

play.db {

  # The combination of these two settings results in "db.default" as the

  # default JDBC pool:

  config = "db"

  default = "default"

  # Play uses HikariCP as the default connection pool.  You can override

  # settings by changing the prototype:

  prototype {

    # Sets a fixed JDBC connection pool size of 50

    hikaricp.minimumIdle = 5

    hikaricp.maximumPoolSize = 5

  }

}

db {

  # You can declare as many datasources as you want.

  # By convention, the default datasource is named `default`

  # https://www.playframework.com/documentation/latest/Developing-with-the-H2-Database

  default.driver = com.mysql.jdbc.Driver

  default.url = "jdbc:mysql://localhost/temp"

  default.username = root

  default.password = "*****"

  # You can turn on SQL logging for any datasource

  # https://www.playframework.com/documentation/latest/Highlights25#Logging-SQL-statements

  default.logSql=true

}

ebean.default = ["models.*"]