未找到模块: com.microsoft.sqlserver#sqljdbc4;4.0

Question

我有一个使用IntelliJ开发的Scala应用程序。当我试图使用sbt对其进行打包时，我会得到以下错误，它会抱怨我在build.sbt文件中包含的build.sbt。

> package
[info] Updating {file:/C:/Users/jthomas1/IdeaProjects/AvroToParquet/}avrotoparquet...
[info] Resolving com.microsoft.sqlserver#sqljdbc4;4.0 ...
[warn]  module not found: com.microsoft.sqlserver#sqljdbc4;4.0
[warn] ==== local: tried
[warn]   C:\Users\jthomas1\.ivy2\local\com.microsoft.sqlserver\sqljdbc4\4.0\ivys\ivy.xml
[warn] ==== public: tried
[warn]   https://repo1.maven.org/maven2/com/microsoft/sqlserver/sqljdbc4/4.0/sqljdbc4-4.0.pom
[warn] ==== local-preloaded-ivy: tried
[warn]   C:\Users\jthomas1\.sbt\preloaded\com.microsoft.sqlserver\sqljdbc4\4.0\ivys\ivy.xml
[warn] ==== local-preloaded: tried
[warn]   file:/C:/Users/jthomas1/.sbt/preloaded/com/microsoft/sqlserver/sqljdbc4/4.0/sqljdbc4-4.0.pom
[info] Resolving jline#jline;2.11 ...
[warn]  ::::::::::::::::::::::::::::::::::::::::::::::
[warn]  ::          UNRESOLVED DEPENDENCIES         ::
[warn]  ::::::::::::::::::::::::::::::::::::::::::::::
[warn]  :: com.microsoft.sqlserver#sqljdbc4;4.0: not found
[warn]  ::::::::::::::::::::::::::::::::::::::::::::::
[warn]
[warn]  Note: Unresolved dependencies path:
[warn]          com.microsoft.sqlserver:sqljdbc4:4.0 (C:\Users\jthomas1\IdeaProjects\AvroToParquet\build.sbt#L13-14)
[warn]            +- default:avrotoparquet_2.11:0.1
[trace] Stack trace suppressed: run last *:update for the full output.
[error] (*:update) sbt.ResolveException: unresolved dependency: com.microsoft.sqlserver#sqljdbc4;4.0: not found
[error] Total time: 4 s, completed Nov 2, 2017 5:18:51 PM

由build.sbt文件跟踪

name := "AvroToParquet"

version := "0.1"

scalaVersion := "2.11.1"

libraryDependencies += "com.microsoft.sqlserver" 
% "sqljdbc4" % "4.0" 
% "runtime"


libraryDependencies ++= Seq(
  "org.apache.spark" %% "spark-core" % "1.6.1",
  "org.apache.spark" %% "spark-sql" % "1.6.1",
  "org.apache.spark" %% "spark-hive" % "1.6.1"
)

感谢你的帮助！

Answer 1

你可以添加

resolvers += "Clojars" at "http://clojars.org/repo/"

对于您的build.sbt，它应该解决问题。

注意，已经有类似问题了，在人们写的答案中

不幸的是，微软并没有通过任何maven存储库提供这个工件。您需要从Microsoft网站下载jar，然后手动将其安装到本地maven存储库中。

因此，如果您不想从上面使用Clojars存储库，您可以从微软下载这个jar，并将它放在您的sbt项目的lib/文件夹中。

还请参阅这个答案，它引用了Maven Central中提供的该驱动程序的另一个工件。

Answer 2

maven central 这里中列出了Microsoft。

该页面上有一个选项卡，列出了这个jar的sbt信息：

libraryDependencies += "com.microsoft.sqlserver" % "mssql-jdbc" % "7.4.1.jre12"