尝试连接到 MySql 时出现异常 [英] slick exception when trying to connect to MySql

问题描述

我正在尝试使用 MySql 遵循 slick2 示例.但是，当尝试连接到数据库时，我遇到了结束异常

import scala.slick.driver.MySQLDriver.simple._导入 slickTest.DB.SuppliersEntity对象 slickTestDB {def main(args: Array[String]) {println("创建数据库！")val schemaName = "slickTest"val conn_str = "jdbc:mysql://localhost:3306/" + schemaNameval database = Database.forURL(conn_str,user="",password="",driver="com.mysql.jdbc.Driver")}}

<块引用>

获得此异常

线程main"中的异常 java.lang.ClassNotFoundException: com.mysql.jdbc.Driver在 java.net.URLClassLoader$1.run(URLClassLoader.java:366)在 java.net.URLClassLoader$1.run(URLClassLoader.java:355)在 java.security.AccessController.doPrivileged(Native Method)在 java.net.URLClassLoader.findClass(URLClassLoader.java:354)在 java.lang.ClassLoader.loadClass(ClassLoader.java:425)在 sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)在 java.lang.ClassLoader.loadClass(ClassLoader.java:358)在 java.lang.Class.forName0(Native Method)在 java.lang.Class.forName(Class.java:190)在 scala.slick.jdbc.JdbcBackend$DatabaseFactoryDe​​f$$anon$4.(JdbcBackend.scala:62)在 scala.slick.jdbc.JdbcBackend$DatabaseFactoryDe​​f$class.forURL(JdbcBackend.scala:61)在 scala.slick.jdbc.JdbcBackend$$anon$2.forURL(JdbcBackend.scala:23)在 slickTest.slickTestDB$.main(slickTestDB.scala:18)在 slickTest.slickTestDB.main(slickTestDB.scala)

解决方案

您可能需要在项目中添加 MySQL 连接器库作为依赖项.

libraryDependencies += "mysql" % "mysql-connector-java" % "latest.release"

I am trying to follow the slick2 examples using MySql. however when trying to connect to the database I am getting end exception

import scala.slick.driver.MySQLDriver.simple._
import slickTest.DB.SuppliersEntity

object slickTestDB {

  def main(args: Array[String]) {
    println("CreateDb!")
    val schemaName = "slickTest"
    val conn_str = "jdbc:mysql://localhost:3306/" + schemaName
    val database = Database.forURL(conn_str,user="",password="",driver="com.mysql.jdbc.Driver")
  }
}

getting this exception

Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:190)
    at scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$4.<init>(JdbcBackend.scala:62)
    at scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$class.forURL(JdbcBackend.scala:61)
    at scala.slick.jdbc.JdbcBackend$$anon$2.forURL(JdbcBackend.scala:23)
    at slickTest.slickTestDB$.main(slickTestDB.scala:18)
    at slickTest.slickTestDB.main(slickTestDB.scala)

解决方案

You probably need to add the MySQL Connector library as a dependency in your project.

libraryDependencies += "mysql" % "mysql-connector-java" % "latest.release"

这篇关于尝试连接到 MySql 时出现异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！