java.sql.SQLException:找不到适用于jdbc:sqlserver://的合适驱动程序-基于Java的Azure函数 [英] java.sql.SQLException: No suitable driver found for jdbc:sqlserver:// - Java based Azure Functions

问题描述

我具有基于Java的Azure函数，该函数正在写入Azure SQL. 但是，触发功能时出现错误. 我需要使用VS Code处理驱动程序问题吗? 我对JDBC或任何其他与Azure Functions最佳的驱动器都很好

I have java based Azure Functions with, which is writing to Azure SQL. However I get error when Function is triggered. What I need to do with VS Code for driver issue? I'm fine with JDBC or any other drive which is best with Azure Functions

}

推荐答案

我需要使用VS Code处理驱动程序问题吗?

What I need to do with VS Code for driver issue?

您需要将jdbc驱动程序依赖项添加到pom.xml文件中.这是我用来连接到Azure SQL的依赖项示例.

You need to add the jdbc driver dependency to the pom.xml file. Here is the dependency sample I used to connect to Azure SQL.

    <dependency>
        <groupId>com.microsoft.sqlserver</groupId>
        <artifactId>mssql-jdbc</artifactId>
        <version>8.2.2.jre8</version>
    </dependency>

参考:

https://docs.microsoft.com/zh-cn/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

这篇关于java.sql.SQLException:找不到适用于jdbc:sqlserver://的合适驱动程序-基于Java的Azure函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！