JDBC

Accessing the DB using Java Database Connectivity (JDBC) is common in applications using relational DBs. Play provides a plugin to manage the JDBC connection pool. The plugin internally uses BoneCP (http://jolbox.com/), a fast Java Database Connection pool (JDBC pool) library.

Note

To use the plugin, a dependency in the build file should be added:

val appDependencies = Seq(jdbc)

The plugin supports H2, SQLite, PostgreSQL, MySQL, and SQL. Play is bundled with an H2 database driver, but to use any of the other databases we should add a dependency on its corresponding driver:

val appDependencies = Seq( jdbc,
"mysql" % "mysql-connector-java" % "5.1.18",...)

The plugin exposes the following methods:

• getConnection: It accepts the name of the database it should get the connection for and whether any statement executed using this connection should commit automatically or not. If a name is not provided, it fetches the connection for database with the default name.
• withConnection...