play 连接mysql_使用play-framework 2.5连接MySQL数据库

本文解决了在使用Play框架2.5.4版本时遇到的MySQL数据库连接问题,详细介绍了配置文件App.conf中连接参数的正确设置方式,并给出了具体的解决步骤。

bd96500e110b49cbb3cd949968f18be7.png

I am trying to connect MySQL database with Play-framework- Java 2.5.4.

I am getting this error,

either dataSource or dataSourceClassName is required

These are the connection codes that I am using inside App.conf file,

db {

db.default.driver=com.mysql.jdbc.Driver

db.default.url="jdbc:mysql://localhost:3306/playdb"

db.default.user="root"

db.default.password="9413678957"

}

But its giving me following errors while connecting :

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:141)

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:199)

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

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

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

When I am connecting to mysql database with same(same as in App.conf)

url (jdbc:mysql://localhost:3306/playdb)

username

password

Using Intellij, its working fine.

Please help me by telling me what I am doing wrong.

解决方案

Finally this worked for me :-

This error killed my lot of time.

Here is what worked for me,

uncomment these line.

play.db {

config = "db"

default = "default"

}

then

db {

default.driver=com.mysql.jdbc.Driver

default.url="jdbc:mysql://localhost:3306/playdb"

default.username=root

default.password="9403678957"

}

don't needdb.default.*, as you already in the db set range.

Lots of thanks to this answer.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值