我正在尝试让这三个东西一起工作,但无法实现。Slick文档不够详细。我已经按照以下方式设置了Typesafe配置的application.conf:
mysql = {
url = "jdbc:mysql://localhost/slickdb"
slick.driver=scala.slick.driver.MySQLDriver
driver=com.mysql.cj.jdbc.Driver
properties = {
user = root
password = null
}
connectionPool = true
keepAliveConnection = true
}
并且要建立sbt相关的依赖:
libraryDependencies ++= Seq(
...
"org.eclipse.jetty" % "jetty-webapp" % "9.2.15.v20160210" % "container",
"javax.servlet" % "javax.servlet-api" % "3.1.0" % "provided",
"com.typesafe.slick" %% "slick" % "3.2.0",
"com.typesafe.slick" %% "slick-hikaricp" % "3.2.0",
"mysql" % "mysql-connector-java" % "latest.integration"
...
)
尝试编译一个简单的DAO
import slick.jdbc.MySQLProfile.api._
class testDAO {
private val db = Database.forConfig("mysql")
}
但是SBT编译器抛出了这个异常:
java.lang.ClassNotFoundException: true
at java.lang.ClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at slick.util.ClassLoaderUtil$$anon$1.loadClass(ClassLoaderUtil.scala:17)
at slick.jdbc.JdbcDataSource$.loadFactory$1(JdbcDataSource.scala:37)
at slick.jdbc.JdbcDataSource$.forConfig(JdbcDataSource.scala:46)
我也尝试了以下内容:
import slick.jdbc.MySQLProfile.api._
import slick.basic.DatabaseConfig
class testDAO {
val dbConfig = DatabaseConfig.forConfig("mysql")
}
但是我收到了另一个异常:
slick.SlickException: Configured profile com.mysql.cj.jdbc.Driver does not conform to requested profile scala.runtime.Nothing$
at slick.basic.DatabaseConfig$.forConfig(DatabaseConfig.scala:99)
at com.unamur.service.testDAO.<init>(CatDAO.scala:18)
at com.unamur.app.TestServlet.<init>(TestServlet.scala:11)
at ScalatraBootstrap.init(ScalatraBootstrap.scala:7)
有人有想法吗?提前致谢。
forConfig[JdbcProfile]("mysql")
吗? - Cyrille Corpet