Posts

Showing posts from January 3, 2019

How correctly connect to Oracle 12g database in Play Framework?

Image
-1 I am new in Play Framework (Scala) and need some advise. I use Scala 2.12 and Play Framework 2.6.20 . I need to use several databases in my project. Right now I connected MySQL database as it says in documentation. How correctly connect project to remote Oracle 12g database? application.conf: db mysql.driver = com.mysql.cj.jdbc.Driver mysql.url = "jdbc:mysql://host:port/database?characterEncoding=UTF-8" mysql.username = "username" mysql.password = "password" First of all to lib folder I put ojdbc8.jar file from oracle website. Then add libraryDependencies += "com.oracle" % "ojdbc8" % "12.1.0.1" code to sbt.build file. Finally I wrote settings to aplication.conf file. After that step I notice error in terminal: [error] (*:update) sbt.ResolveException: unresolved dependency: com.oracle#ojdbc8;12.1.0.1: not found [error] Total time: 6 s, completed 10.11.2018 16:48:30 Java HotSpot(TM) 64-Bit Server VM w